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