Net4x.DapperLibrary.Extensions.Base 1.9.9.8

DapperLibrary.Extensions.Base

Extensions focused on common DataTable, DataRow, IDataReader and IDapperContext operations used across the DapperLibraries.

This project provides small, well-scoped helpers that simplify data manipulation and database table operations when working with IDapperContext and ADO.NET DataTable/DataReader objects.

Key features

• Convert collections to DataTable via IEnumerable<T>.ToDataTable() (ToDataTableExtension).
• Convert DataTable/DataRow to JSON with ToJson() (uses System.Text.Json on .NET Standard and Newtonsoft.Json on older frameworks).
• Convert IDataReader or DataTable to enumerable dictionaries with ToDictionaries() and ToDictionary() helpers.
• Chunking helpers for splitting large DataTable instances into smaller batches (ToChunks).
• Helpers to read rows by primary key, save data in chunks and create or prepare tables on the target database via IDapperContext extension methods.
• Utility methods such as RecycleParameters() for cloning DbParameter instances and FindMatchingRow() to locate matching rows by column name.

Supported targets

This project is multi-targeted to support a variety of .NET Framework and .NET Standard runtimes used in the DapperLibraries solution. Conditional compilation is used to remain compatible with older framework versions.

Usage examples

Convert an IEnumerable<T> to a DataTable:

var table = myCollection.ToDataTable("MyTable");

Serialize a DataTable to JSON:

string json = dataTable.ToJson();

Read an IDataReader into dictionaries:

foreach (var row in reader.ToDictionaries())
{
 // row is a Map<string, object?> (dictionary-like)
}

Split a large table into chunks:

var chunks = dataTable.ToChunks(batchSize: 5000);

Use IDapperContext extension to ensure a table exists before saving:

// inside a context-aware flow
await dapperContext.CreateTableIfNotExists[connectionName](table, primaryKeySize);
await dapperContext.SaveDataTableInChunksAsync[connectionName](table, batchSize);

Dependencies

This project depends on the DapperLibrary core project and types such as IDapperContext, DapperContext, DapperContextFactory, and various database model helpers available in the solution.

Notes

• JSON serialization behavior differs by target framework (System.Text.Json for .NET Standard; Newtonsoft.Json for legacy frameworks).
• Extension methods are placed in the System.Data namespace to allow natural calling code on DataTable, DataRow, IDataReader and IDapperContext.
• The package includes this README.md when packed for NuGet.

For API details, consult the source files in Extensions and the DapperLibrary core documentation.