Bump Dommel from 1.11.0 to 2.0.0

[dependabot-preview[bot]]

Bumps Dommel from 1.11.0 to 2.0.0.

Release notes

Sourced from Dommel's releases.

Dommel 2.0 is finally here :tada:

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 (expirimental) henkmollema/Dommel#75.
• [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

No release notes provided.

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

... (truncated)

Commits

• e24e675 Version 2.0
• 51b507b Bump mysqlconnector from 0.66.0 to 0.69.0 (#222)
• 362466f Bump xunit.runner.visualstudio from 2.4.1 to 2.4.2 (#219)
• ed73a54 Bump coverlet.msbuild from 2.8.1 to 2.9.0 (#217)
• 022dbf6 Bump Microsoft.Data.SqlClient from 1.1.2 to 1.1.3 (#215)
• 5c26b5e Handle null reference
• f1ba7b6 Fix build warnings
• 1a85191 Add Rider folder to .gitignore
• 0c92481 Unify package version in MSBuild props file
• 7e818bc Fallback to Dapper type map strategy (#214)
• Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) - `@dependabot use these labels` will set the current labels as the default for future PRs for this repo and language - `@dependabot use these reviewers` will set the current reviewers as the default for future PRs for this repo and language - `@dependabot use these assignees` will set the current assignees as the default for future PRs for this repo and language - `@dependabot use this milestone` will set the current milestone as the default for future PRs for this repo and language - `@dependabot badge me` will comment on this PR with code to add a "Dependabot enabled" badge to your readme Additionally, you can set the following in your Dependabot [dashboard](https://app.dependabot.com): - Update frequency (including time of day and day of week) - Pull request limits (per update run and/or open at any time) - Out-of-range updates (receive only lockfile updates, if desired) - Security updates (receive only security updates, if desired)

[TroySchmidt]

This is not a good idea and should accompany the corresponding major version bump with this library so that it doesn't permanently break everyone.

[dependabot-preview[bot]]

OK, I won't notify you again about this release, but will get in touch when a new version is available. If you'd rather skip all updates until the next major or minor version, let me know by commenting @dependabot ignore this major version or @dependabot ignore this minor version.

If you change your mind, just re-open this PR and I'll resolve any conflicts on it.