EFE - Execute-event - BulkOperationExecuting

CSharp · Console

/Program.cs

// Entity Framework Extensions
// Doc: https://entityframework-extensions.net/bulk-operation-executing

// @nuget: EntityFramework
// @nuget: Z.EntityFramework.Extensions

using System;
using System.Linq;
using System.Data.Entity;
using System.Collections.Generic;

public class Program
{
	public static void Main()
	{
		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}
		};

		// BulkOperationExecuting: Gets or sets an action to execute `before` the bulk operation is executed.
		using (var context = new EntityContext())
		{
			context.Customers.AddRange(list);
			
			
			context.BulkSaveChanges(options => 
			{
				options.BulkOperationExecuting = bulkOperation => 
				{
					list.ForEach(x =>  
					{ 
						x.Description = "Before_Execution_Description"; 
						x.IsActive = false;
					});
				};
			});
		}
		
		using (var context = new EntityContext())
		{
			FiddleHelper.WriteTable("Table",context.Customers.ToList());	
			FiddleHelper.WriteTable("List",list);	
		}
	}

	public class EntityContext : DbContext
	{
		public EntityContext() : base(FiddleHelper.GetConnectionStringSqlServer())
		{

		}
		
		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; }
	}
}