search

fsprojects / SQLProvider

A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.
https://fsprojects.github.io/SQLProvider
Other
579 stars 146 forks source link

Does SQLProvider support strongly typed sproc results? #690

Open cmeeren opened 4 years ago

cmeeren commented 4 years ago

I am trying to call a stored procedure using SQLProvider, but it seems that I don't get a return value with the strongly typed columns. The documentation also seems to access the result data in a weakly typed manner.

Does SQLProvider support strongly typed sproc results?

Thorium commented 4 years ago

Views you can query strongly typed as tables, but sprocs can't: they can return whatever and we cannot get from any schema any strongly typed info what they'll return.

cmeeren commented 4 years ago

Thanks for the reply. It must be possible in some way, because SqlClient lets me query strongly typed sprocs (but the library has certain other unrelated issues, hence why I'm here). Is this something that's possible to implement in SQLProvider?