Entity Framework - Object Services Level. Executing Stored Procedures for Query.

posted by  varson (7)  13 months ago (mtaulty.com)

I thought I'd write a simple stored procedure and add it to Northwind;

create procedure dbo.GetCustomersByCountry
(
@country nvarchar(30)
)
as
set nocount on
select c.* from dbo.Customers as c
where c.country = @country

 

And then see about calling it using ObjectQuery<T>.