DbFun.Core 2.0.0

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

                    
                

            
NuGet\Install-Package DbFun.Core -Version 2.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.Core" Version="2.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add DbFun.Core --version 2.0.0                

                    
                

            
#r "nuget: DbFun.Core, 2.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.Core as a Cake Addin
#addin nuget:?package=DbFun.Core&version=2.0.0

// Install DbFun.Core as a Cake Tool
#tool nuget:?package=DbFun.Core&version=2.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, Oracle, PostgreSQL, Firebird, 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 Oracle, making use of array parameters possible and adding more comfortable bulk copy mechanism
  • the extension for PostgreSQL, making use of array parameters possible and adding more comfortable bulk import mechanism
  • the extension for Firebird, adding more comfortable batch processing 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 (5)

Showing the top 5 NuGet packages that depend on DbFun.Core:

Package Downloads
DbFun.NpgSql

Provides PostgreSQL specific extensions to SqlFun.
DbFun.MsSql

Allows to use TVP parameters in DbFun when Microsoft.Data.SqlClient is used.
DbFun.MySqlConnector

Extension to use with MySqlConnector data provider.
DbFun.OracleManaged

Provides Oracle specific extensions to SqlFun.
DbFun.Firebird

Provides Firebird specific extensions to SqlFun.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
2.0.0 157 11/16/2024
1.2.0 147 11/5/2024
1.1.0 2,838 9/21/2024
1.0.1 84 8/5/2024
1.0.0 103 7/30/2024
0.0.2 230 3/17/2024
0.0.1 436 3/16/2024

Support for multiple connections.