public List <BrandVM> GetBrands() { using (var db = new Lead2OrderGenerateDbEntities()) { List <l2g_tbl_Brand> brands = db.l2g_tbl_Brand.ToList(); if (brands.Count > 0) { List <BrandVM> brandVMs = new List <BrandVM>(); foreach (var brand in brands) { brandVMs.Add(MappingConfig.BrandToBusinessEntity(brand)); } return(brandVMs); } return(new List <BrandVM>()); } }