How to map functions that takes table and columns as arguments?

Apr 10, 2014 at 8:28 AM
I would like to map for instance CONTAINSTABLE, so I will be able to call this:
SELECT * FROM CONTAINSTABLE(MyEntities, *, @myTerm)
(Without the need to create stored function for each table.)
Coordinator
Apr 11, 2014 at 5:44 AM
I don't know if you can pass the table argument as a parameter (or rather if you can convert it to the correct type if you pass a string). If you can create a TVF/Stored Procedure that takes parameters of type supported by EF (e.g. string for the name) and you return results with the same shape (i.e. the shape of the result does not change depending on parameters) then you should be able to map this stored function.

Thanks,
Pawel