对于无法使用EFCore Extension的情况,在进行批量插入时需要进行重复数据的处理。可以通过以下代码示例实现:
List
using (var dbContext = new MyDbContext()) { var conn = dbContext.Database.GetDbConnection(); conn.Open(); var tran = conn.BeginTransaction(); try { var sql = @"MERGE [dbo].[Person] AS target USING (SELECT * FROM @Persons) AS source ON target.[Id] = source.[Id] WHEN NOT MATCHED THEN INSERT ([Id], [Name], [Age]) VALUES (source.[Id], source.[Name], source.[Age]);"; var cmd = conn.CreateCommand(); cmd.CommandText = sql; cmd.Transaction = tran; var personsToInsertTable = ConvertListToDataTable(personsToInsert); cmd.Parameters.AddWithValue("@Persons", personsToInsertTable); var affectedRows = cmd.ExecuteNonQuery(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } }
private static DataTable ConvertListToDataTable
其中,ConvertList