Learn Entity Framework Core: https://www.learnentityframeworkcore.com/
Entity Framework Core Tutorial: https://entityframeworkcore.com/
Entity Framework 6 Tutorial: https://entityframework.net/
Info
Version: | 1.0.0.1 |
Author(s): | SmartBooks |
Last Update: | Thursday, June 5, 2014 |
.NET Fiddle: | Create the first Fiddle |
Project Url: | https://github.com/gaochundong/WhenEntityFrameworkMeetUnity/tree/master/17.WhenEntityFrameworkMeetUnity-BulkInsert |
NuGet Url: | https://www.nuget.org/packages/EntityFramework.WriteToServer |
Install
Install-Package EntityFramework.WriteToServer
dotnet add package EntityFramework.WriteToServer
paket add EntityFramework.WriteToServer
EntityFramework.WriteToServer Download (Unzip the "nupkg" after downloading)
Dependencies
- EntityFramework(6.1.0)
Tags
使用 SqlBulkCopy 类只能向 SQL Server 表写入数据。 但是,数据源不限于 SQL Server;可以使用任何数据源,只要数据可加载到 DataTable 实例或可使用 IDataReader 实例读取数据。
使用方法:
using (DataTable dataTable = CreateDataTable(tableMapping, entities))
{
using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(transaction.Connection, options, transaction))
{
sqlBulkCopy.BatchSize = batchSize;
sqlBulkCopy.DestinationTableName = dataTable.TableName;
sqlBulkCopy.WriteToServer(dataTable);
}
}.