v2.3.3

• Add CancellationToken to Delete methods (#272)
• Remove caching in the custom type map provider

v2.3.0

• Use ReflectedType instead of DeclaringType (#243) - thanks @SH1N081!
• Fix the parameter prefix of insert queries (#255) - thanks @lucasloss!
• Improve SQL Expressions compiler (#254) - thanks @lucaxchaves!
• Add CancellationToken for Async methods (#251) - thanks @DanieleSky!

v2.2.0

• Update packages
• Allow reading numbers from strings in JSON

v2.1.0

• Ignore properties with [NotMapped] attribute as well
• Fix auto multi mapping with one-to-many relations
• Add nullable annotations

Dommel 2.0

Dommel 2.0 is finally here 🎉

After two years Dommel 2.0 is finally released. It comes with a bunch of new features and bugfixes. There are some breaking changes as well. However, upgrading from 1.x shouldn't result in too much issues as most of the breaking changes revolve around the extensibility points.

New features

• Native JSON support with a new package: Dommel.Json. #134
• Automatic multi-mapping support (experimental) #75 (comment).
• [Table] and [Column] attribute support.
• [Ignore] attribute support.
• Allow non-generated primary keys. #128
• Paging support with GetPaged / GetPagesAsync and SelectPaged / SelectPagedAsync.
• like-queries for strings and in-queries for arrays using Contains in Select.
• From<T> method which support building a query. This is an experimental feature. #111
• InsertAll / InsertAllAsync method to insert a collection of entities.
• Projections support, e.g. Project<Foo>(x => new { x.Bar, x.Baz, x.Qux });. #85

Breaking changes

• Dommel only targets .NET Standard 2.0.
• Dommel has been upgraded to use Dapper 2.0.
• Some classes have been removed from the DommelMapper partial class. E.g. ISqlBuilder, IKeyPropertyResolver, etc.
• A few breaking changes have been made to the ISqlBuilder interface.
  • The PropertyInfo keyProperty has been removed from the BuildInsert method.
  • The string BuildPaging(string? orderBy, int pageNumber, int pageSize) method has been added to support paging.
  • The string QuoteIdentifier(string identifier) has been added to support adding quotes around database identifies such as tables and columns.
  • The string LimitClause(int count) method has been added to support creating limit clauses for paging purposes.
• The IKeyPropertyResolver interface has been changed to support non-generated primary keys and simplify support for multiple primary keys.
• The KeyPropertyInfo class has been renamed to ColumnPropertyInfo and is now returned by both IPropertyResolver and IKeyPropertyResolver.

Special thanks to the contributors for logging issues and proposing pull-requests!

v2.0.0-beta7

Only target .NET Standard 2.0 (#202)

v2.0.0-beta6

• Use PrefixParameter in BuildMultiMapQuery - #132
• Add a factory to create SQL expressions to allow custom implementations
• Allow adding SQL builder using the connection name
• Make SQL builders and resolvers internal for testing
• Add Dommel.Json with JSON support #134
• Update to Dapper 2.0
• Align package targets with Dapper: drop .NET 4.5.2 and .NET Standard 1.3 target / target .NET 4.6.2 and .NET Standard 2.0
• Add nullable annotations

v2.0.0-beta5

• Fix is (not) null expressions #108
• Allow variables in string-contains expressions
• Add experimental From-queryies #111
• Allow non-generated primary keys #128
  • This introduces a breaking change in IKeyPropertyResolver and Resolvers.KeyProperty.
• Pass primary key columns to multimapping query #129
• Add [Ignore] attribute support #130
• Automatic multi-mapping for GetAll #131

v1.11.0

• Allow specifying both start and end escape char
• Add Count method
• Update Dapper package version

v2.0.0-beta4

• Remove deprecated EscapeCharacterStart and EscapeCharacterEnd settings
• Add support for projections - #85
• Add PrefixParameter method to ISqlBuilder - #92
• Allow returning generated GUID as priamry key
• Pass missing transaction parameter to several methods - #95, #100
• Escape table and column names with brackets for SQL Server/SQL Server CE - #96
• Include all key columns for update and delete statements
• Support for IN-clause - #103
• Fix a caching bug where the same column or table name was used for nested types