private static void Main(string[] args) { var dc = new AdventureWorksLT2008Entities(); object c; dc.TryGetObjectByKey(GetEntityKey(dc.Customers, 23), out c); var customer = c as Customer; Console.WriteLine(customer.EmailAddress); }
public static List <Product> ListarProdutosPorCategoria(int?query) { using (var ctx = new AdventureWorksLT2008Entities()) { if (query == null) { return(ctx.Product.ToList <Product>()); } return(ctx.Product.Where(p => p.ProductCategoryID == query).ToList <Product>()); } }
public static List <Product> ListarProdutos(string query) { using (var ctx = new AdventureWorksLT2008Entities()) { if (string.IsNullOrEmpty(query)) { return(ctx.Product.ToList <Product>()); } return(ctx.Product.Where(p => p.Name.StartsWith(query)).ToList <Product>()); } }
public static string BuscarProduto(int query) { using (var ctx = new AdventureWorksLT2008Entities()) { try { return(ctx.Product.Where(p => p.ProductID == query).FirstOrDefault <Product>().Name); } catch { return("nenhum produto com código " + query); } } }