Giving a StackOverflowException when connecting a list to a list

Question

I created a class Auction.cswith this code behind:

namespace WebApplication5
{
    public class Auction
    {
        public string Productname { get; set; }
        public string Lastbidder { get; set; }
        public int Bidvalue { get; set; }

        private List<Auction> listaAukcija = new List<Auction>();

        public List<Auction> ListaAukcija
        {
            get { return listaAukcija; }
            set { listaAukcija = value; }
        }

        public void getAll()
        {
            using (SqlConnection conn = new SqlConnection(@"data source=JOVAN-PC;database=aukcija_jovan_gajic;integrated security=true;"))
            {
                SqlCommand cmd = conn.CreateCommand();
                cmd.CommandText = @"SELECT a.id AS aid, p.name AS pn, u.name AS un, a.lastbid AS alb FROM (Auction a INNER JOIN Product p ON a.productid = p.id) INNER JOIN User u ON a.lastbider = u.id";
                conn.Open();
                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    listaAukcija.Clear();

                    while (reader.Read())
                    {
                        Auction auction = new Auction();

                        if (reader["aid"] as int? != null)
                        {
                            auction.Productname = reader["pn"] as string;
                            auction.Lastbidder = reader["un"] as string;
                            auction.Bidvalue = (int)reader["alb"];
                        }

                        listaAukcija.Add(auction);
                    }
                }
            }
        }

        public override string ToString()
        {
            return base.ToString();
        }
    }
}

I called it methods in another class DbBroker.cs:

 public class DbBroker : Home
 {
     Auction aukcija = new Auction();

     public void executeQuery()
     {
         aukcija.getAll();
     }

     public void getArr()
     {
         List<string[]> lista = aukcija.ListaAukcija.Cast<string[]>().ToList();
         var x = ListBox1.Text;
         x = lista.ToString();
     }
 }

And called getArron the Homepage:

public partial class Home : System.Web.UI.Page
{
    DbBroker dbb = new DbBroker();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Label3.Text = Session["Username"].ToString();
            dbb.getArr();
        } 
    }
}

The problem is that I get an error StackOverflowExceptionin Auction aukcija = new Auction();the class DbBroker.cs. I do not know why and how to solve it.

Answer 1

You create a list of Auctionsobjects within yourself = Stackoverflow .

It's your problem:

public class Auction {
    private List<Auction> listaAukcija = new List<Auction>();
}

You will need to separate the model Auctionfrom the service or repository that receives the data.

For example:

//the model
public class Auction {
    public string Productname { get; set; }
    public string Lastbidder { get; set; }
    public int Bidvalue { get; set; }

    public override string ToString()
    {
        return base.ToString();
    }
}

//the service (or can replace this with a repository)
public class AuctionService {
    private List<Auction> listaAukcija = new List<Auction>();

    public List<Auction> ListaAukcija
    {
        get { return listaAukcija; }
        set { listaAukcija = value; }
    }

    public void getAll()
    {
        //get the data and populate the list
    }
}

UPDATE

AuctionService DbBroker. DbBroker Home ().

public class DbBroker //: Home <-- circular reference
{
    AuctionService auctionService = new AuctionService();

    public void executeQuery()
    {
        auctionService.getAll();
    }

    public void getArr()
    {
        string[] lista = auctionService.ListaAukcija.ConvertAll(obj => obj.ToString()).ToArray();

        ListBox1.Text = string.Join("\n", lista);
    }
}

_Load() - executeQuery(), .

public partial class Home : System.Web.UI.Page
{
    DbBroker dbb = new DbBroker();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Label3.Text = Session["Username"].ToString();
            dbb.executeQuery(); //populate list.
            dbb.getArr(); //convert to string and update textbox
        } 
    }
}

PS. AuctionService , DbBroker . .

, .