DbFun.MsSql 1.0.0

.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher. 
dotnet add package DbFun.MsSql --version 1.0.0                

                    
                

            
NuGet\Install-Package DbFun.MsSql -Version 1.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="DbFun.MsSql" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add DbFun.MsSql --version 1.0.0                

                    
                

            
#r "nuget: DbFun.MsSql, 1.0.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install DbFun.MsSql as a Cake Addin
#addin nuget:?package=DbFun.MsSql&version=1.0.0

// Install DbFun.MsSql as a Cake Tool
#tool nuget:?package=DbFun.MsSql&version=1.0.0

DbFun

DbFun is a tool for writing data access code in F# functional way.

It's fast, type safe and gives you full control on your queries.

No custom query DSL enabled - just raw SQL.

Features

  • All SQL features available
  • Type safety
  • High performance
  • support for record/tuple/discriminated union parameters
  • support for record/tuple/discriminated union results
  • Support for parameter and column conversions
  • Support for result transformations
  • Support for enum types
  • Asynchrony
  • Template-based queries
  • Computation expression for database operations

Supported databases

In its core DbFun does not use any features specific to some db provider, so it works with any ADO.NET provider. The only limitation is possibility of execution of commands in SchemaOnly mode.

It was tested against MS SqlServer, PostgreSQL, MySQL and SQLite.

There are extensions, enabling provider-specific features:

  • the extension for MS SQL, that allows to use table valued parameters
  • the extension for PostgreSQL, making use of array parameters possible and adding more comfortable bulk import mechanism
  • the extension for MySQL (when using MySqlConnector) improving use of bulk copy
  • the extension for SQLite, that allows to use date and time values
Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.0.0 77 7/30/2024
0.0.2 152 3/17/2024

Non-TVP compound type collection parameters.