CSharp · Console
// Entity Framework Extensions
// Doc: https://entityframework-extensions.net/post-configuration
// @nuget: Microsoft.EntityFrameworkCore.SqlServer
// @nuget: Z.EntityFramework.Extensions.EFCore
using System;
using System.Linq;
using Microsoft.EntityFrameworkCore;
using System.Collections.Generic;
using Microsoft.Data.SqlClient;
public class Program
{
public static void Main()
{
using (var context = new EntityContext())
{
context.Database.EnsureCreated();
}
var list = new List<Customer>()
{
new Customer() { Name ="Customer_A", IsActive = true},
new Customer() { Name ="Customer_B", IsActive = true},
new Customer() { Name ="Customer_C", IsActive = true}
};
// PostConfiguration: Gets or sets an action to execute `before` the bulk operation is executed.
using (var context = new EntityContext())
{
context.BulkInsert(list, options =>
{
options.PostConfiguration = operations =>
{
operations.Log = Console.WriteLine;
};
});
}
using (var context = new EntityContext())
{
var list1 = context.Customers.ToList();
}
}
public class EntityContext : DbContext
{
public EntityContext()
{
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseSqlServer(new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()));
base.OnConfiguring(optionsBuilder);
}
public DbSet<Customer> Customers { get; set; }
}
public class Customer
{
public int CustomerID { get; set; }
public string Name { get; set; }
public string Description { get; set; }
public Boolean IsActive { get; set; }
}
}