/// <summary> /// Returns an OrdersEntity object populated with he specified order /// </summary> /// <param name="orderID"></param> /// <returns>OrdersEntity object</returns> public OrdersEntity GetOrderByOrderID(int orderID) { return this.GetEntity("OrdersSelectByPK", this.CreateParameter("@OrderID", orderID)); }Stored Procedure
CREATE PROCEDURE dbo.OrdersSelectByPK ( @OrderID Int ) AS SET NOCOUNT OFF; SELECT CustomerID, EmployeeID, Freight, OrderDate, OrderID, RequiredDate, ShipAddress, ShipCity, ShipCountry, ShipName, ShippedDate, ShipPostalCode, ShipRegion, ShipVia FROM [Orders] WHERE OrderID = @OrderID GO