views:

22

answers:

0

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)

PLEASE CLICK This Link it is my question!

Click link