Dapper Plus - High-Efficient Bulk Actions (Insert, Update, Delete, and Merge) for .NET
Download the library here
BulkInsertAsync
ThenBulkInsertAsync
AlsoBulkInsertAsync
DateOnly
and TimeOnly
type (#142)Trial unlocked until the end of April
Download the library here
DapperPlusManager.ClearInformationTableCache()
to clear cached information retrieved from the databaseMicrosoft.CSharp
Trial unlocked until the end of March
Download the library here
MySQL
that could keep a table lock when pooling is enabled and an error happen within the statementTrial unlocked until the end of February
Download the library here
CreateTable
method now creates a [DATETIME2]
instead of a [DATETIME]
for SQL Server for the DateTime
property type.Trial unlocked until the end of January
Download the library here
Schema
in the Table
Data Annotation[Table("Product", Schema = "Test")]
public class Product
{
public int ProductID { get; set; }
public string Name { get; set; }
public string Url { get; set; }
}
Trial unlocked until the end of December
Download the library here
DapperPlusContext
now inherits from the IDisposable
interface// from mapping
var bulkOptionsGeneric = new BulkOperationOptions<Customer>();
bulkOptionsGeneric.ColumnPrimaryKeyExpression = x => x.CustomerID;
DapperPlusManager.Entity<Customer>().UseBulkOptions(bulkOptionsGeneric);
// from connection
var bulkOptions = new BulkOperationOptions();
bulkOptions.BatchTimeout = 90;
connection.UseBulkOptions(bulkOptions).BulkInsert(customers);
Microsoft.CSharp
Trial unlocked until the end of December
Download the library here
Trial unlocked until the end of December
Download the library here
conn.CreateTable<T>()
issue for version below SQL Server 2019 (Removed OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF
from the table creation script)Trial unlocked until the end of October