Monday, April 02, 2012 1:51 PM
What I need now is dynamicity meaning when the user via the web-application modifies the SQL tables, I need to trigger the F# function to recompute the corresponding table.
I was wondering if I could
- trigger F# from MS SQL Server
- trigger F# from SQL from any database in a generic way
- "compile" or "reflect" the F# function into an SQL stored procedure in MS SQL Server
- do so in a generic way with any database
Monday, April 02, 2012 4:07 PM
You can use SQLCLR objects written in F# smthng similar explained for example here:
Also you could take a look at new F# 3.0 feature called Type Providers:
Tuesday, April 03, 2012 8:17 AM
SQLCLR allows running F# in MS SQL Server which should do the trick.
I am not sure however how F# Type Providers could solve my problem though. Could you be more specific ?
Also, any hints on how to solve the issue if I need any other database than MS SQL ?