Allows to configure DbFun to compile expressions with FastExpressionCompiler instead of standard System.Linq.Expressions-based compiler. Thanks to faster compilation (even 10-14x), its usage improves startup performance and, in some cases, runtime performance.
Get Started
$ dotnet add package DbFun.FastExpressionCompilerReadme
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