SqlBulkPro.Lite 1.0.3

SqlBulkPro.Lite

Free, MIT-licensed bulk insert for SQL Server

What is SqlBulkPro.Lite?

SqlBulkPro.Lite is a free, open-source library that provides high-performance bulk insert operations for SQL Server with Entity Framework Core and Dapper.

It's the free tier of SqlBulkPro (author Daniel Davis, https://www.nuget.org/profiles/danieldavisdev), offering bulk insert without a commercial license.

Features

✅ BulkInsert - Fast bulk insertion using SqlBulkCopy
✅ EF Core integration - Automatic mapping from EF model
✅ Dapper support - Works with plain SqlConnection
✅ Transaction support - Respects existing transactions
✅ MIT licensed - Use commercially without restrictions
✅ No dependencies (except EF Core for EF integration)

Installation

dotnet add package SqlBulkPro.Lite

Usage

With EF Core

using SqlBulkPro.Lite;

var products = new List<Product>
{
    new() { Name = "Widget", Price = 9.99m },
    new() { Name = "Gadget", Price = 19.99m }
};

await context.BulkInsertAsync(products);

With Dapper/ADO.NET

using SqlBulkPro.Lite;
using Microsoft.Data.SqlClient;

using var connection = new SqlConnection(connectionString);

await connection.BulkInsertAsync(
    tableName: "Products",
    entities: products,
    schema: "dbo"
);

Options

await context.BulkInsertAsync(
    entities: products,
    batchSize: 10000,
    timeoutSeconds: 60
);

Performance

SqlBulkPro.Lite was not benchmarked as its own package. The measured BulkInsertAsync numbers for SqlBulkPro, which also uses SqlBulkCopy, are in benchmarks.md.

What's NOT Included

SqlBulkPro.Lite only supports BulkInsert. For additional operations, upgrade to SqlBulkPro:

• ❌ BulkUpsert (insert or update)
• ❌ BulkUpdate
• ❌ BulkDelete
• ❌ BulkSync
• ❌ Custom key column matching
• ❌ Column filtering
• ❌ Identity propagation (in Lite)
• ❌ Advanced options

Upgrade to SqlBulkPro

Need upsert, update, or delete operations?

SqlBulkPro — $149 per developer per year, or $599 per year for up to 10 developers. The license key is emailed after purchase.

dotnet add package SqlBulkPro

Requirements

• .NET 8.0 or later
• SQL Server 2016+ or Azure SQL Database

License

MIT License

Copyright (c) 2026 Daniel Davis

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Support

Commercial support: dbdavis1990apple@gmail.com

Docs for the paid package are in this repository (docs/licensing.md).