I just introduced my first F# based open source project dotnet-sqldb. It's a DotNet Global Tool, distributed via NuGet. It uses DbUp and Command Line Parser to offer a simple CLI for applying migration scripts etc. against a SQL-Server database. It started out as a C# project that I've been using in my own little projects, but as I've started learning F#, I thought it would be a nice little candidate for getting started.
I'll be doing some separate posts about F# "features", that I (as a C# developer) have appreciated when putting together this small project.
Another post of mine, that might be of interest is: "Resources I've found useful to get going with F#"
dotnet tool install -g dotnet-sqldb
To install it locally, you use the dotnet tool install command with the
dotnet tool install dotnet-sqldb --tool-path /path/for/tool
To use it you will need to include it in the current environment path.
Note: It's your data. Use at your own risk. As the license (MIT) says: "THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND..."
Ensures that the specified DB exists. If it does not exist, it gets created.
dotnet-sqldb ensure --connectionstring mycnstring
Upgrades the database by applying SQL-scripts using DbUp
dotnet-sqldb up --connectionstring mycnstring --assembly myassembly_with_embedded_scripts
Drops the specified database if it exists.
dotnet-sqldb drop --connectionstring mycnstring
Feel free to contribute improvements to the repo at GitHub, so that I get to learn the dos and don'ts of F#.