Dapper.SimpleCRUD
2.3.0
dotnet add package Dapper.SimpleCRUD --version 2.3.0
NuGet\Install-Package Dapper.SimpleCRUD -Version 2.3.0
<PackageReference Include="Dapper.SimpleCRUD" Version="2.3.0" />
paket add Dapper.SimpleCRUD --version 2.3.0
#r "nuget: Dapper.SimpleCRUD, 2.3.0"
// Install Dapper.SimpleCRUD as a Cake Addin #addin nuget:?package=Dapper.SimpleCRUD&version=2.3.0 // Install Dapper.SimpleCRUD as a Cake Tool #tool nuget:?package=Dapper.SimpleCRUD&version=2.3.0
Simple Get, GetList, GetListPaged, Insert, Update, Delete, DeleteList, and RecordCount extensions for Dapper. Uses smart defaults for attribute free classes but can be overridden as needed.
By default uses Id column as the primary key but this can be overridden with an attribute
By default queries the table matching the class name but this can be overridden with an attribute
By default queries the column matching the property name but this can be overridden with an attribute
- Supports SQL Server, PostgreSQL, and MySQL
- Includes async methods
- Supports .Net Core
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. 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. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- Dapper (>= 2.0.78)
- Microsoft.CSharp (>= 4.4.0)
NuGet packages (38)
Showing the top 5 NuGet packages that depend on Dapper.SimpleCRUD:
Package | Downloads |
---|---|
EachShow.DataAccess.Core
Package Description |
|
Edakik.Shared.Library
Package Description |
|
TianFeng.FrameworkCore
天枫 .net core 组件,支持.net6 |
|
YuckQi.Data.Sql.Dapper
An implementation of YuckQi.Data for SQL databases using Dapper and SimpleCRUD. |
|
Cigel.DotNetCore
Package Description |
GitHub repositories (2)
Showing the top 2 popular GitHub repositories that depend on Dapper.SimpleCRUD:
Repository | Stars |
---|---|
yilezhu/Czar.Cms
.NET Core实战项目之CMS系列教程的源码,精简而又功能丰富的权限设计,内容管理设计让你轻松搭建一个ASP.NET Core2.2的网站系统.此项目准备用EFCore进行重构,敬请期待
|
|
MoonStorm/FastCrud
fast .NET ORM for strongly typed people
|
Version | Downloads | Last updated |
---|---|---|
2.3.0 | 1,725,335 | 3/15/2021 |
2.2.0.1 | 1,347,569 | 12/18/2019 |
2.2.0 | 223,467 | 10/2/2019 |
2.1.0 | 334,128 | 2/22/2019 |
2.0.1 | 186,042 | 10/2/2018 |
2.0.0 | 51,190 | 7/12/2018 |
2.0.0-beta | 3,021 | 7/9/2018 |
1.13.0 | 309,508 | 9/19/2016 |
1.12.0 | 12,556 | 8/1/2016 |
1.11.1 | 12,121 | 6/16/2016 |
1.11.0 | 3,946 | 6/15/2016 |
1.10.0 | 25,517 | 12/3/2015 |
1.9.3 | 4,124 | 12/1/2015 |
1.9.2 | 15,005 | 10/27/2015 |
1.9.1 | 6,924 | 8/29/2015 |
1.9.0 | 4,807 | 7/27/2015 |
1.9.0-beta | 3,119 | 7/22/2015 |
1.8.7 | 48,722 | 5/14/2015 |
1.8.6 | 8,742 | 4/23/2015 |
1.8.5 | 21,761 | 2/27/2015 |
1.8.4 | 3,751 | 2/8/2015 |
1.8.3 | 3,670 | 1/30/2015 |
1.8.2 | 3,428 | 1/20/2015 |
1.8.1 | 3,345 | 1/19/2015 |
1.8.0 | 3,863 | 1/19/2015 |
1.7.0 | 3,556 | 1/9/2015 |
1.6.0 | 3,732 | 12/30/2014 |
1.4.1 | 6,492 | 6/23/2014 |
1.4.0 | 3,574 | 6/4/2014 |
1.3.0 | 4,108 | 12/19/2013 |
1.2.2 | 4,555 | 7/4/2013 |
1.2.1 | 3,702 | 7/4/2013 |
1.2.0 | 3,734 | 3/18/2013 |
1.1.4 | 3,567 | 2/14/2013 |
1.1.3 | 3,462 | 2/4/2013 |
1.1.2 | 3,550 | 2/4/2013 |
1.1.1 | 3,452 | 2/4/2013 |
1.1.0 | 3,569 | 1/25/2013 |
1.0.7 | 3,410 | 1/23/2013 |
1.0.6 | 3,453 | 1/17/2013 |
1.0.5 | 3,535 | 1/8/2013 |
1.0.4 | 3,497 | 1/8/2013 |
1.0.3 | 3,633 | 1/4/2013 |
1.0.2 | 3,563 | 12/26/2012 |
1.0.1 | 3,421 | 12/24/2012 |
1.0.0 | 4,159 | 12/24/2012 |
Full documentation can be found at https://github.com/ericdc1/Dapper.SimpleCRUD/
* version 1.3.0: Support for multiple schemas, non int primary keys. Fixed issue with editable attribute annotations. Made enums be considered "editable" so you can have integers in the database and represent them as enums in the code and have SimpleCRUD map them without extra pain.
* version 1.4.0: Switched to using Nullable.GetUnderlyingType(type) so we don't need to explicitly check for all nullable types. This also has the side effect of fixing checks for nullable enums without the editable attribute.
* version 1.4.1: Added support for short and long primary key types on insert method
* version 1.5.0 Target .Net 4.5, support for PostgreSQL, SQL Server now uses scope_identity on insert rather than @@identity. Add support for GUID primary keys
* version 1.6.0 Target .Net 4.0 and 4.5 and add async support / remove SQLCE support Special thanks to https://github.com/Prnda1976 for help with the pull request backlog
* version 1.7.0 Added column attribute and made gets specify column names rather than select * . Changed GUID to autogenerate when the property value is empty. Ability to change database dialect from SQL Server to PostgreSQL.
* version 1.8.0 Added support and tests for SQLite. Added additional GetList method that accepts a raw SQL where clause for more advanced queries.
* version 1.8.2 Added logo, updated package description
* version 1.8.3 Fix for async get method, added additional tests around async methods
* version 1.8.4 Fix for custom column name on primary key in get and delete methods
* version 1.8.5 Added support for ReadOnly attribute on properties which allows selecting it from the database but ignores it on inserts and updates
* version 1.8.6 Allow a column named Id column to not be considered a key when another [Key] is specified
* version 1.8.7 Fix for GUID primary key named Id
* version 1.9.0 Added GetListPaged, DeleteList, and RecordCount methods and support for specified value in primary key
* version 1.9.1 MySQL Support
* version 1.9.2 Fix for async insert with specified value in primary key
* version 1.9.3 Fix for issue with GetPagedList with custom column name for primary key - Thanks haleaurelian. Added DeleteList with anonymous object
* version 1.10.0 Added IgnoreUpdate, IgnoreInsert, and IgnoreSelect attributes
* version 1.11.0 Added resolvers PR, typed attributes, merged recordcount where conditions PR, performance improvements PR
* version 1.11.1 Bug fix for resolvers to allow attributes from different namespaces (SimpleCRUD and Data Annotations)
* version 1.12.0 Added notmapped attribute to match DataAnnotations (thanks Mattykins). Allow insert with string primary key (thanks xalikoutis)
* version 1.13.0 Accept parameters on getlist, getlistpaged, deletelist, recordcount, and matching async methods
* version 2.0.0 Bug fixes, .Net Core support, remove Sqlite support
* version 2.0.1 Re-add SQLite, allow string primary keys
* version 2.1.0 Speed improvements (thanks jonathanlarouche)
* version 2.2.0 Dapper 2.x support
* version 2.3.0 Update DB2 support (mvaz77), Interface support (jonathanlarouche)