ms-sql
entity framework에서 stored procedure
마피아9
2013. 1. 2. 19:59
public IList<Product> GetProductsByCategoryId(int categoryId)
{
IList<Product> products;
using (var context = new NorthwindData())
{
SqlParameter categoryParam = new SqlParameter("@categoryID", categoryId);
products = context.Database.SqlQuery<Product>("Products_GetByCategoryID @categoryID", categoryParam).ToList();
}
return products;
}
public Product GetProductById(int productId)
{
Product product = null;
using (var context = new NorthwindData())
{
SqlParameter idParameter = new SqlParameter("@productId", productId);
product = context.Database.SqlQuery<Product>("Product_GetByID @productId", idParameter).FirstOrDefault();
}
return product;
}
http://www.codeproject.com/Articles/121340/Exposing-a-Stored-Procedure-in-WCF-Data-Service
http://www.lucbos.net/2012/03/calling-stored-procedure-with-entity.html