How can I use this stored procedure in Entity Framework? I need to call it from like that :
foreach (SalesOrderDetail order in
objCtx.GetOrderDetails(soHeaderNumber))
Console.WriteLine("Header#: {0} " +
"Order#: {1} ProductID: {2} Quantity: {3} Price: {4}",
soHeaderNumber, order.SalesOrderDetailID,
order.ProductID,
order.OrderQty, order.UnitPrice);
My Stored Procedure:
SELECT *
FROM Customers INNER JOIN
Departments ON Customers.ID = Departments.ID INNER JOIN
Personels ON Departments.ID = Personels.DID INNER JOIN
Randevus ON Customers.ID = Randevus.CID AND Departments.ID = Randevus.DID AND Personels.ID = Randevus.PID INNER JOIN
TimeTables ON Randevus.SID = TimeTables.ID where Customers.ID=@customerid)