Net.Code.ADONet 7.1.0

• .NETStandard 2.1

  • Microsoft.Data.SqlClient (>= 7.1.1)
  • Microsoft.Extensions.Logging.Abstractions (>= 10.0.14)
  • System.ComponentModel.Annotations (>= 5.0.0)
  • System.Security.Cryptography.Pkcs (>= 10.0.14)

• net8.0

  • Microsoft.Data.SqlClient (>= 7.1.1)
  • Microsoft.Extensions.Logging.Abstractions (>= 10.0.14)
  • System.Security.Cryptography.Pkcs (>= 10.0.14)

7.1.0
Binary compatible with 7.0.0 (verified with package validation).
New:
- CancellationToken overloads for all async methods; IAsyncEnumerable results also honour WithCancellation.
- Db(DbDataSource) constructors (.NET 8+), e.g. new Db(NpgsqlDataSource.Create(...)).
- AsReaderAsync() returning a DbDataReader; AsEnumerableAsync(Func<IDataRecord, T>).
- WithParameter(name, value, DbType, size) for explicitly typed parameters.
- Insert/Update/Delete use DbBatch when the provider supports it (e.g. SqlClient, Npgsql): one round trip per 100 rows. Only with the built-in Default, PostGreSQL and DB2 configurations; Oracle, or a custom DbConfig with a prepare action, still executes row by row.
- BulkCopy/BulkCopyAsync overloads that take a SqlTransaction.
- Trimming/AOT annotations: reflection-based mapping and the 'dynamic' APIs are marked [RequiresUnreferencedCode]/[RequiresDynamicCode]; source generated mappers are AOT-safe.
Changed:
- Commands no longer open the connection when they are created, but when they are executed (asynchronously for async methods).
- Column to property mapping falls back to a case-insensitive match (an exact match still wins), consistent with constructor mapping and generated mappers.
- BulkCopy uses the Db's own connection instead of opening a second one. If a transaction is active on that connection, pass it to BulkCopy.
- Async commands log their parameters, like synchronous commands (at Trace level).
- With batching, Npgsql runs each batch in an implicit transaction: a failing row rolls back the rows of the same batch.
- Removed the dependencies on System.Linq.Async (conflicts with .NET 10's System.Linq.AsyncEnumerable), Microsoft.CSharp and Microsoft.Bcl.AsyncInterfaces. If your code used async LINQ operators (ToListAsync, ...) through this package, reference System.Linq.AsyncEnumerable (or use .NET 10+).
Fixed:
- BulkCopy failed with 'Login failed' after the Db's connection was opened (SqlClient removes the password from ConnectionString unless Persist Security Info=true).
- WithTimeout rounded sub-second timeouts down to 0, which means 'no timeout'.
- WithParameters threw KeyNotFoundException for types with an indexer or a property without a public getter (also in the CRUD helpers and ToDataTable).
- Insert bound the database-generated key as an extra parameter, which Oracle (BindByName) rejects; Delete bound all properties instead of only the key.

7.0.0
Breaking:
- Depends on Microsoft.Data.SqlClient 7. Entra ID (Azure AD) authentication now requires referencing Microsoft.Data.SqlClient.Extensions.Azure in your application.
New:
- net8.0 target (in addition to netstandard2.1).
- DateOnly/TimeOnly support, including Npgsql 10, which returns DateOnly/TimeOnly for date/time columns.
- IDataRecord extensions: GetDateOnly, GetTimeOnly, GetTimeSpan, GetDateTimeOffset, GetByteArray, GetEnum.
- Source generator: DateOnly, TimeOnly, TimeSpan, DateTimeOffset, byte[] and enum properties; error ADONET001 for unsupported property types.
Fixed:
- Mapping a type with a public property with a non-public setter or getter threw NullReferenceException.
- Generated mappers cached column ordinals across queries and did not map DBNull to null for nullable reference types.
- Record constructor mapping conversions, enum conversion, SelectOne key handling, WithParameters with runtime types, chunked GetBytes/GetChars, thread-safety of the query cache.
- Patched vulnerable transitive dependencies (System.Security.Cryptography.Pkcs, Microsoft.Bcl.Memory).