public CategoryList GetAll() { Database database = new Database("Customer"); database.Command.Parameters.Clear(); database.Command.CommandType = CommandType.StoredProcedure; database.Command.CommandText = "tblCategoryGetAll"; DataTable dt = database.ExecuteQuery(); Category select = new Category(); select.Id = Guid.Empty; select.Name = "-- Please Select a Category --"; _List.Add(select); foreach (DataRow dr in dt.Rows) { Category ca = new Category(); ca.Initialize(dr); ca.InitializeBusinessData(dr); ca.IsNew = false; ca.IsDirty = false; ca.Savable += Category_Savable; _List.Add(ca); } return(this); }