111,094
社区成员




CREATE TABLE [dbo].[Users] (
[Id] INT NOT NULL,
[Name] NCHAR(32) NULL
);
用SqlBulkCopy可以:
var connectionStr = "Data Source=...; Initial Catalog=...; Integrated Security=True;";
// 放1500条演示数据
var batchData = new DataTable("Users");
batchData.Columns.Add("Id");
batchData.Columns.Add("Name");
for(int i = 0; i < 1500; i++)
{
batchData.Rows.Add(i, "name" + i);
}
using (var con = new SqlConnection(connectionStr))
{
con.Open();
var sbc = new SqlBulkCopy(con)
{
DestinationTableName = "dbo.Users",
BatchSize = 1000,
};
sbc.WriteToServer(batchData);
}