CSharp · Console
// Entity Framework Extensions
// Doc: https://entityframework-extensions.net/bulk-options
// @nuget: Microsoft.EntityFrameworkCore.SqlServer
// @nuget: Z.EntityFramework.Extensions.EFCore
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using Microsoft.Data.SqlClient;
public class Program
{
public static void Main()
{
using (var context = new EntityContext())
{
context.Database.EnsureCreated();
}
var invoices = GenerateInvoices(5, 3);
using (var context = new EntityContext())
{
// CREATE bulkOptions instance
var bulkOptions = context.Invoices.CreateBulkOptions();
// var bulkOptions = new Z.BulkOperations.BulkOperationOptions<Invoice>();
// var bulkOptions = new Z.BulkOperations.BulkOperationOptions(); // only with anonymous
// SET Options
bulkOptions.IncludeGraph = true;
bulkOptions.BatchTimeout = 180;
context.BulkInsert(invoices, bulkOptions);
FiddleHelper.WriteTable("1 - Invoices", context.Invoices);
FiddleHelper.WriteTable("2 - InvoiceItems", context.InvoiceItems);
}
}
public static List<Invoice> GenerateInvoices(int countInvoice, int countInvoiceItem)
{
List<Invoice> list = new List<Invoice>();
for(int i = 0; i < countInvoice; i++)
{
var invoice = new Invoice() { Number = "Number_" + i, Items = new List<InvoiceItem>() };
list.Add(invoice);
for(int j = 0; j < countInvoiceItem; j++)
{
invoice.Items.Add(new InvoiceItem() { ProductName = "ProductName_" + i + "_" + j });
}
}
return list;
}
public class EntityContext : DbContext
{
public EntityContext()
{
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseSqlServer(new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()));
base.OnConfiguring(optionsBuilder);
}
public DbSet<Invoice> Invoices { get; set; }
public DbSet<InvoiceItem> InvoiceItems { get; set; }
}
public class Invoice
{
public int InvoiceID { get; set; }
public string Number { get; set; }
public List<InvoiceItem> Items { get; set; }
}
public class InvoiceItem
{
public int InvoiceItemID { get; set; }
public string ProductName { get; set; }
public Invoice Invoice { get; set; }
}
}