I want to execute a select using a specific type but I get an error.
SELECT * FROM TABLE(MY_CUSTOM_FU(:my_param))
System.InvalidOperationException: ‘The element type ‘MyCustomRow’ used in ‘SqlQuery’ method is not natively supported by your database provider. Either use a supported element type, or use ModelConfigurationBuilder.DefaultTypeMapping to define a mapping for your type.’
I tried to execute a select statement with a custom object.
It works in EF 6 using the SqlQuery
rows = Database.SqlQueryRaw(“SELECT * FROM TABLE(MY_CUSTOM_FU(:my_param))”, myParam);
Djamel Besseghir is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.