public IQueryable <product> getProduct(int code)
{
db_store_productEntities ctx = new db_store_productEntities();
return(ctx.products.Where(x => x.code == code).Select(x => x));
}
public IQueryable <transaction> getTransactions(int id)
{
db_store_productEntities ctx = new db_store_productEntities();
return(ctx.transactions.Where(x => x.id == id).Select(x => x));
}
public IQueryable <product> getProducts()
{
db_store_productEntities ctx = new db_store_productEntities();
return(ctx.products);
}