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