v3.0.1

What's Changed

• Bump Microsoft.EntityFrameworkCore.Design from 6.0.4 to 6.0.5 by @dependabot in #76
• Bump Microsoft.EntityFrameworkCore.SqlServer from 6.0.4 to 6.0.5 by @dependabot in #75
• Bump Microsoft.EntityFrameworkCore.Design from 6.0.5 to 6.0.6 by @dependabot in #77
• Bump Microsoft.EntityFrameworkCore.SqlServer from 6.0.5 to 6.0.6 by @dependabot in #78
• Bump Microsoft.EntityFrameworkCore.Design from 6.0.6 to 6.0.7 by @dependabot in #79
• Bump Microsoft.EntityFrameworkCore.SqlServer from 6.0.6 to 6.0.7 by @dependabot in #80
• Bump Microsoft.EntityFrameworkCore.Design from 6.0.7 to 6.0.8 by @dependabot in #81
• Bump Microsoft.EntityFrameworkCore.SqlServer from 6.0.7 to 6.0.8 by @dependabot in #82
• Bump Microsoft.EntityFrameworkCore.SqlServer from 6.0.8 to 6.0.9 by @dependabot in #83
• Bump Microsoft.EntityFrameworkCore.Design from 6.0.8 to 6.0.9 by @dependabot in #84
• Bump AutoMapper from 11.0.1 to 12.0.0 by @dependabot in #85
• Bump actions/setup-dotnet from 2 to 3 by @dependabot in #87
• Bump AutoMapper.Extensions.Microsoft.DependencyInjection from 11.0.0 to 12.0.0 by @dependabot in #86
• Bump Microsoft.EntityFrameworkCore.SqlServer from 6.0.9 to 6.0.10 by @dependabot in #88
• Bump Microsoft.EntityFrameworkCore.Design from 6.0.9 to 6.0.10 by @dependabot in #89
• Bump Microsoft.EntityFrameworkCore.SqlServer from 6.0.10 to 7.0.0 by @dependabot in #90
• Bump Microsoft.EntityFrameworkCore.Design from 6.0.10 to 7.0.0 by @dependabot in #91
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.0 to 7.0.1 by @dependabot in #92
• Bump Microsoft.EntityFrameworkCore.Design from 7.0.0 to 7.0.1 by @dependabot in #93
• Bump Microsoft.EntityFrameworkCore.Design from 7.0.1 to 7.0.2 by @dependabot in #94
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.1 to 7.0.2 by @dependabot in #95
• Bump AutoMapper from 12.0.0 to 12.0.1 by @dependabot in #96
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.2 to 7.0.3 by @dependabot in #97
• Bump Microsoft.EntityFrameworkCore.Design from 7.0.2 to 7.0.3 by @dependabot in #98
• Bump morelinq from 3.3.2 to 3.4.0 by @dependabot in #99
• Bump morelinq from 3.4.0 to 3.4.1 by @dependabot in #100
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.3 to 7.0.4 by @dependabot in #101
• Bump Microsoft.EntityFrameworkCore.Design from 7.0.3 to 7.0.4 by @dependabot in #102
• Bump morelinq from 3.4.1 to 3.4.2 by @dependabot in #103
• Bump AutoMapper.Extensions.Microsoft.DependencyInjection from 12.0.0 to 12.0.1 by @dependabot in #104
• Bump Microsoft.EntityFrameworkCore.Design from 7.0.4 to 7.0.5 by @dependabot in #105
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.4 to 7.0.5 by @dependabot in #106
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.5 to 7.0.7 by @dependabot in #107
• Bump Microsoft.EntityFrameworkCore.Design from 7.0.5 to 7.0.7 by @dependabot in #108
• Bump Microsoft.EntityFrameworkCore.Design from 7.0.7 to 7.0.8 by @dependabot in #110
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.7 to 7.0.8 by @dependabot in #109
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.8 to 7.0.9 by @dependabot in #111
• Bump Microsoft.EntityFrameworkCore.Design from 7.0.8 to 7.0.9 by @dependabot in #112
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.9 to 7.0.10 by @dependabot in #113
• Bump Microsoft.EntityFrameworkCore.Design from 7.0.9 to 7.0.10 by @dependabot in #114
• Bump actions/checkout from 3 to 4 by @dependabot in #115
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.10 to 7.0.11 by @dependabot in #116
• Bump Microsoft.EntityFrameworkCore.Design from 7.0.10 to 7.0.11 by @dependabot in #117
• Bump Microsoft.EntityFrameworkCore.Design from 7.0.11 to 7.0.12 by @dependabot in #118
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.11 to 7.0.12 by @dependabot in #119
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.12 to 7.0.13 by @dependabot in #120
• Bump Microsoft.EntityFrameworkCore.Design from 7.0.12 to 7.0.13 by @dependabot in #121
• Bump morelinq from 3.4.2 to 4.0.0 by @dependabot in #122
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.13 to 7.0.14 by @dependabot in #126
• Bump morelinq from 4.0.0 to 4.1.0 by @dependabot in #125
• Bump actions/setup-dotnet from 3 to 4 by @dependabot in #127
• Bump github/codeql-action from 2 to 3 by @dependabot in #128
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.14 to 7.0.15 by @dependabot in #129
• Bump Microsoft.EntityFrameworkCore.Design from 7.0.13 to 7.0.15 by @dependabot in #130
• Bump Microsoft.EntityFrameworkCore.Design from 7.0.15 to 7.0.16 by @dependabot in #131
• Bump Microsoft.EntityFrameworkCore.SqlServer from 7.0.15 to 7.0.16 by @dependabot in #132
• Fix memory issue with expression constants by @nino-s in #133

New Contributors

• @nino-s made their first contribution in #133

Full Changelog: v3.0.0...v3.0.1

Bugfix: Filter expressions used to retrieve distinct column values must be translatable to SQL

As explained in #74, for EFCore to be able to translate filter expressions to SQL, they must only use projection to types with a default constructor. Since this may be seen as a breaking change and also due to the update to DataTables.NetStandard:v3.0.1, this is a major release.

.NET Standard 2.1 and EFCore 6 in Sample Project

With this release, the target framework of the DataTables.NetStandard.Enhanced library has been changed to netstandard2.1. Furthermore, the sample project does now use EFCore 6. The release follows the update of DataTables.NetStandard to v2.0.0.

Fix: wrong default value in numeric range filter factory

With this release, a fix for a wrong default value (long.MaxValue for data type int) in one of the numeric range filter factories is being release. More details about the fix can be found in (#16).

Support nullable types for date range and numeric range filters

With this release, the NumericRangeFilter and the DateRangeFilter received support for nullable data types. Also changed has been the way the property selector on the search predicate provider factory methods is being interpreted. It does now support nested properties as well. For details see the corresponding pull request (#14).

New filters: multi select, numeric range and date range

With this release, three new filters were added (including the server-side processing logic):

• A new MultiSelectFilter allows selecting multiple entries of a select input at once.
• A new NumericRangeFilter allows filtering based on a numeric (range) input.
• A new DateRangeFilter allows filtering based on a date (range) input.

Detailed information can be found in each pull request:

• Add new numeric range filter (#10)
• Add new date range filter (#11)
• Add new multi select filter (#12)

Stable version & dependency updates

With this release, the package can now be considered stable. This has been achieved by splitting the package from the other packages in the group, especially from DataTables.NetStandard.

Also part of this release are the following changes:

• Bump AutoMapper from 8.0.0 to 10.0.0 (#2)
• Bump morelinq from 3.1.1 to 3.3.2 (#3)
• Update sample application to ASP.NET Core 3.1 (#5)
• Bump AutoMapper.Extensions.Microsoft.DependencyInjection from 7.0.0 to 8.0.0 (#6)
• Bump DataTables.NetStandard.TemplateMapper from 0.2.0 to 1.0.0 (#7)
• Bump DataTables.NetStandard from 0.5.2 to 1.0.0 (#8)