Depending on the version of EF, you can call a stored proc, which can call the function.




>Hi everybody,
>
>I'm wondering if there is a way to use SQL Server function (in particular, we have function that calculates age based on the birthday) without using EDMX?
>
>I checked this link http://msdn.microsoft.com/en-us/library/vstudio/dd456847(v=vs.100).aspx but wondering if there is any other way.
>
>This is what I started to write:
>
>

>  var query = db.Guests.Select(g => new GuestsList
>            {
>                LastName = g.LastName,
>                FirstName = g.FirstName,
>                BirthDate = g.BirthDate,
>                Phone = g.Address.AreaCode.Trim() + g.Address.Phone.Trim()
>               
>            });

>
>We have a SQL Server function dbo.siriusfn_AgeToday(g.birth_date) which I'd like to include into this query.
>
>Thanks a lot in advance.
>
>UPDATE. Looks like it's not supported in Code First :( http://data.uservoice.com/forums/72025-entity-framework-feature-suggestions/suggestions/1953237-code-first-support-for-user-defined-functions-udf
>
>I added 3 votes.