How to use fsc.props to make FSharp.Data.SqlClient work on .NET Core
As of 2020-03-20, FSharp.Data.SqlClient does not work out of the box with .NET Core. We still need to use the fsc.props workaround described here:
The workaround has been obsoleted, but for some Type Providers this may still be a problem.
Also described here:
Could not load file or assembly System.Data.SqlClient if building using dotnet build
This project includes an fsc.props file. I have included FscToolPath references to the fsc.exe for Visual Studio 2019 so you do not have to have Visual Studio 2017 installed.
See also here for reference:
added Visual Studio Build tools FscToolPath Can't dotnet build apps with TypeProviders if installed the F# compiler with Visual Studio Build Tools
You will need to have Visual Studio 2017 or Visual Studio 2019 installed. If you don't want to install Visual Studio or if you are running on a Build Server, you can install the Visual Studio Build Tools
- Clone the repo
dotnet build
If you see this error:
error FS3033: The type provider 'FSharp.Data.SqlCommandProvider' reported an error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and
that SQL Server is configured to allow remote connections.
You are in good shape. To further test, go into src/lib/Example.fs and change the connection string to point to your database and change the query to make sense for you schema.
I like to keep fsc.props at the solution level so I can import it into any projects I have in my solution.