Calling user-defined database functions

Question

Is this possible? I mean, I'm basically looking to do the following...

I have created a function already in my database (although if there's a way to create it using code first migrations, that's fine by me too) called GetPlayerPosition that accepts 1 parameter (an integer representing a Player ID).

I'm looking to do something like this with LINQ in my MVC code:

from p in db.Players
select new { p.PlayerId, GetPlayerPosition(p.PlayerId)};

I know I can't just simply do this, unfortunately (at least not without someway of getting EF to recognize this function), but I've tried hunting around for a while to find a way to do this and I'm just spinning my wheels. Any help is appreciated.

Pawel · Accepted Answer · 2015-02-19 05:10:57Z

3

You can use the Code First Functions convention to invoke stored procedures, TVFs and scalar UDFs from Code First (EF 6.1.1).

answered Feb 19, 2015 at 5:10

Pawel

31.7k4 gold badges76 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ChrisS Over a year ago

I will take a look at this, thanks a lot for the info, Pawel! I unfortunately can't vote up though due to being a new user.

Collectives™ on Stack Overflow

Calling user-defined database functions

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related