private List <Buyer> FillBuyerList() { Buyers.Clear(); _dataSet.Clear(); _command = "SELECT Id, Name FROM Buyers"; _sqlDataAdapter.SelectCommand = new SqlCommand(_command, _sqlConnection); _sqlDataAdapter.Fill(_dataSet); Buyers = _dataSet.Tables[0].AsEnumerable().Select(dataRow => new Buyer { Id = dataRow.Field <long>("Id"), Name = dataRow.Field <string>("Name") }).ToList(); _dataSet.Clear(); return(Buyers); }