CODEWITHSUNDEEP
c#sqllinqlinq-to-entitiesstored-functions
Stefan
Stefan

Reputation: 4317

Stored Functions with Linq to Entities

How can I make a MS-SQL stored function availabe in LINQ expressions if using the Entity framework?

The SQL function was created with CREATE FUNCTION MyFunction(@name) ...). I was hoping to access it similarly to this:

var data = from c in entities.Users where MyFunction(c.name) = 3;

Unfortunately I have only .NET 3.5 available.

Upvotes: 3

Views: 876

Answers (1)

Craig Stuntz
Craig Stuntz

Reputation: 126547

You actually can import DB functions in EF 1. But you don't get EdmFunctionAttribute in EF 1, so you're limited to the contexts where you can use them. You need EF 4 for that.

For your case you might want to consider mapping a proc returning Users (for 3.5; again, 4 is better for this feature).

Upvotes: 1

Related Questions