- First version
- Ability to
LoadWhereand specify criteria on the form[SomeProperty] = @someValueaccompanied by arguments on the formnew { someValue = "hej" } - Ability to
DeleteWherein the same way asLoadWhere - Use the excellent FastMember to extract property values from objects to be even faster
- Comments!
- Add
[DebaserUpdateCriteria]which can be used to add extra criteria to an upsert type, which must be satisfied for a potential update to be carried out (can be used for avoiding overwriting with old data)
- Fix bug that would make the upsert helper unable to handle single-column tables (i.e. a table that simply consists of PKs)
- Fix bug that would result in an exception when upserting an empty sequence
- Parameterize the
DropSchemamethod so it can be used to e.g. drop only the data type and the procedure - Parameterize the
CreateSchemamethod so it can be used to e.g. create only the table
- Handle
double(== float) andfloat(== real) properly in automapperino
- Add mechanism to allow for configuring command timeout and transaction isolation level
- Add ability to completely ignore a property
- Make
CreateSchemadefault to actually creating it
- Target .NET Standard 2.0
- Update to FastMember 1.5.0
- Update to System.Data.SqlClient 4.8.1
- Fix roundtrip bug
- Add support for Azure integrated auth
- Also target .NET Standard 2.1
- Add
LoadAllAsyncthat returnsIAsyncEnumerablewhen targeting .NET Standard 2.1 - Remove methods to be consistent with regards to the use of "Async"
- Add ability to easily specify SQL types with precision
- Enable customization of data type and sproc names
- Even faster extraction of query parameter values
- Fix bug that would sometimes result in truncating string values
- Fix nullable-value-type-in-ctor edge case
- Replace System.Data.SqlClient dep with Microsoft.Data.SqlClient
- Add overloads of all methods on
UpsertHelperthat accept anSqlConnectionand an optionalSqlTransactionfrom the outside, enabling enlisting multiple operations in the same transaction - Remove .NET Standard 2.0 target because it was in the way
- Cuddle NuGet package manifest a little bit
- Add ability to output schema generation scripts
- Fix ability to specify precision of
DateTimeOffsetproperties
- Add abilty to query by a dictionary of args and not only anonymous objects. This is useful in cases where the arguments vary, e.g. when implementing query builders and stuff
- Update Microsoft.Data.SqlClient to 2.1.1
- Update Microsoft.Data.SqlClient to 3.0.0
- Update Microsoft.Azure.Services.AppAuthentication to 1.6.1
- Tolerate
Authentication=Active Directory Integratedin the connection string to support managed identity
- Target .NET Standard 2.0 because it's the right thing to do
- Update Microsoft.Data.SqlClient to 4.0.0
- Update Microsoft.Data.SqlClient to 5.0.1
- Update Microsoft.Data.SqlClient to 5.1.2
- Fix package metadata
- Fix bug that would choke on passwords containing an equals sign
- Update Microsoft.Data.SqlClient to 5.2.2
- Add additional compilation targets because why not
- Initialize and keep more stuff to avoid a couple of allocations during upserts
- Target .NET 9 too
- Update to Microsoft.Data.SqlClient 6.0.1
- Only target .NET
- Update nuggies
- Remove support for manually handled managed identity
- Update Microsoft.Data.SqlClient to 6.1.1
- Add PostgreSQL port
- Update some packages
- Add .NET10 as target
- Update nuggies
- Add support for
DateOnly