Select Stored Procedure
CREATE PROCEDURE RetrieveContacts ( @ContactName VARCHAR(50) ) AS SELECT ContactId, ContactName, CompanyName FROM Contacts WHERE ContactName LIKE @ContactName + '%';
Using SelectProcedure
// Get All Contacts with Names that start with A
SelectProcedure selectProc = new SelectProcedure(
typeof(Contact), "RetrieveContacts");
selectProc.AddParameter("@ContactName", "A");
ObjectSet contacts = Manager.GetObjectSet(selectProc);
|