public List <Product> GetByName(string name) { using (var dbContext = new AdventureWorks2012Entities1()) { return(dbContext.Products.Where(p => p.Name.Contains(name)).ToList()); } }
public Product Get(int id) { using (var dbContext = new AdventureWorks2012Entities1()) { return(dbContext.Products.Find(id)); } }
public IList <BindableRecord> Get() { using (AdventureWorks2012Entities1 ctx = new AdventureWorks2012Entities1()) { return((from c in ctx.Customers join o in ctx.Orders on c.Order equals o join ct in ctx.CustomerTypes on c.CustomerType equals ct select new BindableRecord() { CustomerObject = c, CustomerTypeObject = ct, OrderObject = o }).ToList()); } }