Accessing TVF with table valued parameter

Sep 11, 2015 at 3:24 PM
Hi there,

Just wondering if you think it's possible to access a TVF with this method that takes in a table type parameter? In the past I have been able to select from TVFs with entity using a Database.SqlQuery with a SqlParameter, where the parameter type is SqlDbType.Structured and you can specify the TypeName (the database type of the parameter).

Since this method of accessing TVF's uses ObjectParameters instead of SqlParameters it seems to have issues mapping correctly, and there is no TypeName property on the ObjectParameter.

Am I out of luck? Thanks.
Coordinator
Sep 15, 2015 at 5:00 AM
EF does not support table-valued parameters so no, it won't work.

Thanks,
Pawel