v2.6.1

Added the missing NonQuery method to the DbContextParameterExtensions class.

v2.6

This release adds extensions to the DbContext that allow anonymous types to be used as the source of parameters for queries. The properties of the objects are converted into Db Parameters, with the property name becoming the Parameter Name and the property value becoming the Value. If a property is a DbParameter (or derived from DbParameter), the name is set from the property name, and the parameter is otherwise used as provided.

The SQL library has been updated with ParameterExtensions that can be used when auto-detection of the parameter type is not available. These methods are meant to be used in conjunction with the anonymous type parameters feature.

Example usage:

string state = "PA";
var cities = connector.Query<City>("select * from Cities where State = @State", new { state });

string name = "Chicago";
var city = connector
    .Query<City>("select * from Cities where Name = @Name", new { Name = name.AsNVarCharParam(100) })
    .SingleOrDefault();

v2.5

Added Tuple support for queries.
Added a Parameters Helper to make creation of parameters for specials SQL types such as DateTime2, Date, Time, and Table Value Parameters.
Dropped support for .NET 6.0. Now targets .NET 8.0+.

v2.4

Added Transaction support to the OpenContext() call.

v2.3

Updated to target .NET 8 as well as .NET 6.
NuGet dependency updates.

v2.2

Added HasValueConverter() method to the mapper collection to allow users to determine if a converter for a given type is already registered.
Updated dependency packages to latest versions.

v2.1

Added support for non-default constructors where the constructor parameter names match some or all of the property names of the object. This allows C# record types to be used for queries.

Added IgnoreBehavior that allows for finer-grained control over property Ignore mappings. Properties can now be Ignored OnLoad, OnSave or Both (the default). This allows for asymmetric load/save behavior when using property mapping with queries and saving via SqlBulkCopy with an EntityDataReader.

v2.0

Version 2.0 of Carbonated.Data is now available.

• The library has been updated to .NET 6.
• Built-in support DateOnly and TimeOnly has been added.
• DbContext now makes its underlying connection available.
• EntityDataReader has been added, allowing a collection of entities to be read as if they were data records. This is particularly useful in scenarios where SqlBulkCopy is being used to save large batches of data to the database.

v1.2

To support newer features such as Azure SQL, we dropped support for .NET Framework 4.0 in the Carbonated.Data and Carbonated.Data.Sql libraries. These now target only .NET Standard 2.0, which brings the .NET Framework support requirement up to 4.6, as minimum.

Underlying NuGet package dependencies were also updated to their latest versions.

Initial release - v1.1.0

First production release with support for type mapping and property mapping, including support for custom type converters that can apply to any entity.

This release is available via NuGet:

https://www.nuget.org/packages/Carbonated.Data/

https://www.nuget.org/packages/Carbonated.Data.SqlServer/