Table Valued Functions in EF Core

Viewed 6581

I am using EF Core 1.1 and have a query like

var list=from l in context.Users
         where l.SomeProp==someVal
         select l;

I have a UDF which returns a table of Id's and I basically want to generate the following query:

select * from Users where SomeProp=@someVal and SomeId in (select id from fn_myfunc(@id))

Is this possible to do?

1 Answers
Related