CSharp · Console
// @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; }
}
}