对于无法使用EFCore Extension的情况，在进行批量插入时需要进行重复数据的处理。可以通过以下代码示例实现：

1. 首先定义一个Model的List，将需要插入的数据加入这个List。

List personsToInsert = new List(); for(int i=1; i<=100000; i++) { Person person = new Person() { Id = $"{i}", Name = $"Person-{i}", Age = i%50 + 10 }; personsToInsert.Add(person); }

2. 在进行插入时，使用ExecuteSqlCommand方法，并在SQL语句中使用Merge语句，来判断是否有重复的数据。

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(List list) { DataTable table = new DataTable(); PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(typeof(T)); foreach (PropertyDescriptor prop in properties) { table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType); } foreach (T item in list) { DataRow row = table.NewRow(); foreach (PropertyDescriptor prop in properties) { row[prop.Name] = prop.GetValue(item) ?? DBNull.Value; } table.Rows.Add(row); } return table; }

其中，ConvertList