I'd like to call the function directly but apparently it's not possible. I think we're using EF6. I'm looking right now into SqlQuery method explained here http://msdn.microsoft.com/en-us/data/jj592907.

>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.