Dapper.FastCrud
The fastest micro-orm type extension for Dapper. For Dapper constructs in general, it is recommended to use Visual Studio 2015 for features such as nameof and string interpolation, but that's not a requirement. The package contains .NET 4.5 and 4.6 DLLs, one of which will be installed based on the target framework in your project. For .NET 4.5, the code contains the polyfills for the missing FormattableString class, which is required when targetting that framework version and using string interpolation with the C# 6 compiler in VS 2015. Features: ---------- - Support for LocalDb, Ms Sql Server, MySql, SqLite, PostgreSql - Entities having composite primary keys are supported - Multiple entity mappings are supported, useful for partial queries in large denormalized tables and data migrations between different database types. - All the CRUD methods accept a transaction, a command timeout, and a custom entity mapping. - Fast pre-computed entity queries - A simple Sql builder with alias support is provided, which is very useful when manual SQL queries are unavoidable. - A generic T4 template is also provided for convenience in the NuGet package Dapper.FastCrud.ModelGenerator. Code first entities are also supported which can either be decorated with attributes such as Table, Key and DatabaseGenerated, or can have their mappings programmatically set. Examples of usage: ------------------- - using Dapper.FastCrud - dbConnection.Insert(newEntity); - dbConnection.Get() - dbConnection.Get(new Entity() {Id = 10}); - dbConnection.Update(updatedEntity); - dbConnection.Delete(entity) - dbConnection.Find<Entity>( whereClause:
quot;{nameof(Entity.FirstName)}=@FirstNameParam", orderClause:quot;{nameof(Entity.LastName)} DESC", skipRowsCount:10, limitRowsCount:20, queryParameters: new {FirstNameParam: "John"}); This is where the power of the C# 6 compiler comes into play, and leaves no chance to mistypings or to problems arising from db entity refactorings. More details and benchmarks are available on the project site.Install
dotnet add package Dapper.FastCrud --version 2.0.0
Install-Package Dapper.FastCrud -Version 2.0.0
<PackageReference Include="Dapper.FastCrud" Version="2.0.0" />
Frameworks
No framework metadata available.
Dependencies
Adoption guide
Assess this package against its supported frameworks, license, maintenance signals and dependency graph before making it a project standard.
No SPDX license expression is published. Review the license text and your organisation's policy before redistribution.
No target framework metadata is available. Confirm compatibility in a representative project before standardising on this package.
How to read this guidance
Sources: published NuGet v3 registry metadata and explicit NuBrowse editorial guides. Refresh: package metadata is refreshed from NuGet when the page loads. Limit: this is not a security, legal or compatibility guarantee; validate the selected version in your project.
Useful next steps
Move from package metadata to a concrete selection or review workflow.