EF Extensions - UpdateFromQuery

CSharp · Console

/Program.cs

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

using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity;
using System.Linq;
using System.Collections.Generic;
					
public class Program
{
	public static void Main()
	{
		// Insert data
		using (var context = new EntityContext())
		{
			var order = new Order() 
				{
					OrderDate = DateTime.Now.AddMinutes(-10),
					IsCompleted = false,
					Items = new List<OrderItem>()
						{
							new OrderItemA(),
							new OrderItemB(),
						}
				};
			context.Orders.Add(order);
			context.SaveChanges();
			
			FiddleHelper.WriteTable("Orders before Update", context.Orders.ToList());
			FiddleHelper.WriteTable("Items before Update", context.OrderItems.ToList());
		}
		
		using (var context = new EntityContext())
		{
			context.Database.Log = query => Console.Write(query);
			
			var transactionId = Guid.NewGuid();
			var deletionDate = DateTime.Now;
			var margin = deletionDate.AddMinutes(-1);
			var deletedItems = context.OrderItems.Where(i => !i.IsDeleted && !i.Order.IsCompleted && i.Order.OrderDate < margin).UpdateFromQuery(i => new OrderItem()
																																				 {
																																					 IsDeleted = true,
																																					 DeletedReason = 2,
																																					 DeletedDate = deletionDate,
																																					 TransactionId = transactionId,
																																				 });
			context.Database.Log = null;
			
			FiddleHelper.WriteTable("Orders after Update", context.Orders.ToList());
			FiddleHelper.WriteTable("Items after Update", context.OrderItems.ToList());
		}

	}
	

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

		}
		
		public DbSet<OrderItem> OrderItems { get; set; }
		public DbSet<OrderItemA> OrderItemAs { get; set; }
		public DbSet<OrderItemB> OrderItemBs { get; set; }
		public DbSet<Order> Orders { get; set; }
	}
	

	[Table("OrderItems")]
	public class OrderItem
	{
		[Key]
		public int Id { get; set; }

		[ForeignKey("Order"), Column("Order_Id")]
		public int OrderId { get; set; }
		public virtual Order Order { get; set; }

		public bool IsDeleted { get; set; }
		public int? DeletedReason { get; set; }
		public DateTime? DeletedDate { get; set; }
		public Guid? TransactionId { get; set; }
	}
	[Table("OrderItemAs")]
	public class OrderItemA : OrderItem
	{
		public string PropA { get; set; }
	}
	[Table("OrderItemBs")]
	public class OrderItemB : OrderItem
	{
		public string PropB { get; set; }
	}

	[Table("Orders")]
	public class Order
	{
		[Key]
		public int Id { get; set; }

		public DateTime OrderDate { get; set; }
		public bool IsCompleted { get; set; }

		public virtual List<OrderItem> Items { get; set; }
	}
}
;