public dynamic Get(int id) { using (var db = MarketingContext.Create()) { var item = db.ProductsDetails .Where(o => o.Id == id) .SingleOrDefault(); return(item); } }
public IEnumerable <int> Get() { using (var db = MarketingContext.Create()) { var all = db.ProductsDetails .Select(p => p.Id) .ToArray(); return(all); } }
public IEnumerable <dynamic> Get(string ids) { using (var db = MarketingContext.Create()) { var productIds = ids.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(s => int.Parse(s)).ToArray(); var items = db.ProductsDetails .Where(status => productIds.Any(id => id == status.Id)) .ToArray(); return(items); } }