Navigation

	Home Page
	Index
	All Pages

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

Calling a Stored Procedure from Entity Framework - EF6

With Result Set¶

• OrderDetail is a class that represents one row of the result set.
  

using (var db = new MyDataModel())
{
    var p1 = new SqlParameter("@OrderId", orderId);

    var sql = "dbo.GetOrderDetails @OrderId";

    var q = db.Database.SqlQuery<OrderDetail>(sql, p1).ToList();
}