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);
}
}
}
