public List <Category> SearchCategories(string name) { var categoryDal = new CategoryDal(); var dt = categoryDal.SearchCategories(name); var categoriesList = new List <Category>(); foreach (DataRow dr in dt.Rows) { var category = new Category() { Id = int.Parse(dr["Id"].ToString()), Name = dr["Name"].ToString(), }; categoriesList.Add(category); } return(categoriesList); }