public IEnumerable <tblCategory> GetCategory() { var context = new subzicartEntities(); return((from p in context.Set <tblCategory>() //where p.CategoryID == categoryID select new { catId = p.catId, catName = p.catName }).ToList() .Select(x => new tblCategory { catId = x.catId, catName = x.catName })); }
public IEnumerable <tblBrandPrefix> GetBrand() { var context = new subzicartEntities(); return((from p in context.Set <tblBrandPrefix>() //where p.CategoryID == categoryID select new { brand_id = p.brand_id, brand_name = p.brand_name }).ToList() .Select(x => new tblBrandPrefix { brand_id = x.brand_id, brand_name = x.brand_name })); }