64,502

Downloads

14,729

Downloads of v 1.13.0

38

Average downloads per day

2016-09-19

Last published

Share on Social Networks

License details

provided by Sonatype

Apache-2.0

Dapper.SimpleCRUD

1.13.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, SQLite, and MySQL

- Includes async methods when targeting .Net 4.5

To install Dapper.SimpleCRUD, run the following command in the Package Manager Console

Install-Package Dapper.SimpleCRUD -Version 1.13.0

Release Notes

Full documentation can be found at http://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
)

Owners

Authors

Eric Coffman

Copyright

Copyright Eric Coffman 2016

Tags

Dependencies

    • Dapper (>= 1.42.0 && < 2.0.0)

Version History

Version Downloads Last updated
Dapper.SimpleCRUD 1.13.0 (this version) 14,729 Monday, September 19, 2016
Dapper.SimpleCRUD 1.12.0 3,045 Monday, August 1, 2016
Dapper.SimpleCRUD 1.11.1 3,916 Thursday, June 16, 2016
Dapper.SimpleCRUD 1.11.0 294 Wednesday, June 15, 2016
Dapper.SimpleCRUD 1.10.0 9,013 Thursday, December 3, 2015
Dapper.SimpleCRUD 1.9.3 366 Tuesday, December 1, 2015
Dapper.SimpleCRUD 1.9.2 1,571 Tuesday, October 27, 2015
Dapper.SimpleCRUD 1.9.1 2,322 Saturday, August 29, 2015
Dapper.SimpleCRUD 1.9.0 1,145 Monday, July 27, 2015
Dapper.SimpleCRUD 1.9.0-beta 128 Wednesday, July 22, 2015
Dapper.SimpleCRUD 1.8.7 6,176 Thursday, May 14, 2015
Dapper.SimpleCRUD 1.8.6 783 Thursday, April 23, 2015
Dapper.SimpleCRUD 1.8.5 12,648 Friday, February 27, 2015
Dapper.SimpleCRUD 1.8.4 472 Sunday, February 8, 2015
Dapper.SimpleCRUD 1.8.3 289 Friday, January 30, 2015
Dapper.SimpleCRUD 1.8.2 264 Tuesday, January 20, 2015
Dapper.SimpleCRUD 1.8.1 126 Monday, January 19, 2015
Dapper.SimpleCRUD 1.8.0 153 Monday, January 19, 2015
Dapper.SimpleCRUD 1.7.0 255 Friday, January 9, 2015
Dapper.SimpleCRUD 1.6.0 205 Tuesday, December 30, 2014
Dapper.SimpleCRUD 1.4.1 1,332 Monday, June 23, 2014
Dapper.SimpleCRUD 1.4.0 254 Wednesday, June 4, 2014
Dapper.SimpleCRUD 1.3.0 723 Thursday, December 19, 2013
Dapper.SimpleCRUD 1.2.2 832 Thursday, July 4, 2013
Dapper.SimpleCRUD 1.2.1 178 Thursday, July 4, 2013
Dapper.SimpleCRUD 1.2.0 399 Monday, March 18, 2013
Dapper.SimpleCRUD 1.1.4 249 Thursday, February 14, 2013
Dapper.SimpleCRUD 1.1.3 209 Monday, February 4, 2013
Dapper.SimpleCRUD 1.1.2 204 Monday, February 4, 2013
Dapper.SimpleCRUD 1.1.1 196 Monday, February 4, 2013
Dapper.SimpleCRUD 1.1.0 210 Friday, January 25, 2013
Dapper.SimpleCRUD 1.0.7 202 Wednesday, January 23, 2013
Dapper.SimpleCRUD 1.0.6 236 Thursday, January 17, 2013
Dapper.SimpleCRUD 1.0.5 216 Tuesday, January 8, 2013
Dapper.SimpleCRUD 1.0.4 200 Tuesday, January 8, 2013
Dapper.SimpleCRUD 1.0.3 210 Friday, January 4, 2013
Dapper.SimpleCRUD 1.0.2 209 Wednesday, December 26, 2012
Dapper.SimpleCRUD 1.0.1 212 Monday, December 24, 2012
Dapper.SimpleCRUD 1.0.0 244 Monday, December 24, 2012