Delete last N records, Entity Framework

How can I use Entity Framework 6 and my repository to delete multiple records?

I am using Entity Framework 6 and I have a repository looking like the following with the Add and Update methods removed to make it shorter:... public class GenericRepository<T> : IRepository<T> where T : class { public GenericRepository(DbContext dbContext) { if (dbContext == null) throw new ArgumentNullException("An i...

How does Entity framework implement deleting parent and a child record on the ame SaveChanges()

I have the following two entity sets representing Dept & Emp:-...public partial class Dept { public Dept() { this.Emps = new HashSet<Emp>(); } public int DeptID { get; set; } public string Name { get; set; } public string Description { get; set; } public virtual ICollection<Emp> Emps { get; set; } } public pa...

Entity Framework: how to delete related entity upon update or delete of 'generic' parent

you can do as follow: ...public abstract class Picture { public int Id {get;set;} public string Type { get; set; } public byte[] Content { get; set; } } public class ProductImage:Picture { public int ProductId {get;set;} public virtual Product Product {get;set;} } public class CustomerImage:Picture { public int CustomerId {g...

Deleting parent-child relation with Entity Framework or Entity Framework Core

I'm learning how to use Entity Framework, having a NHibernate background. There are plenty of tutorials on the net, but I didn't find something for my specific case. I don't want to delete the Category record, I only want to delete the relation!...I have following poco's:... public class TrainingCourse { [Key] public int Cour...

Entity Framework circular dependency for last entity

Please consider the following entities...public class What { public int Id { get; set; } public string Name { get; set; } public ICollection<Track> Tracks { get; set; } public int? LastTrackId { get; set; }] public Track LastTrack { get; set; } } public class Track { public Track(string what, DateTime dt, TrackThatGeopositi...

Why is Entity Framework (Core) deleting old records on Add() operation?

I have an entity that needs history tracked on it for employee pay rates. The employeeRate object is:...public class EmployeeRate : BaseEntity { [Key] public int EmployeeRateId { get; set; } public int EmployeeId { get; set; } public double Rate { get; set; } } public class BaseEntity { public bool ActiveFlag { get; set; } ...

Entity Framework: Issue with adding new entity to the contex after deleting

In my context I am deleting one of the existing entities. And in the same context I am trying to add a new entity with using code below:... if (entity != null && EFContext.Entry(entity).State == EntityState.Detached) { try { var entityName = entity.GetType().Name; G...

Deleted entities show up as modified in Entity Framework Core's ChangeTracker

I'm trying to understand why Entity Framework Core 2's ChangeTracker sets the state of deleted entities to 'modified' if the deletion is done by removing the entity from a list in another entity....Consider this example:...Class1 List<Class2> MyListOfClass2Objects Class2 ...Both classes have their own ...DbSet... in EF's ...DbContext.... If I re...

Entity Framework Core on SQL Server: Failing to delete an optionally self-referenced record

Nevermind, the issue was my test setup, inserting the two persons. (note to myself: check line numbers in stack traces)...this code works as expected:...[Fact] public void Manually_Remove_Reference() { using (var personsContext = new PersonsContext(DbContextOptions)) { var him = new Person { Name = "Him"}; var her = new Pers...

Entity Framework 6 one-to-many with a reference to last record

I have two entities in my model, and they have a one to many relationship like this...public class Analysis : Entity { public virtual IList<Process> Processes{ get; set; } } public class Process: Entity { public virtual Analysis Analysis { get; set; } } ...This works fine, but to optimize my code and limit my model I'd like to expose only ...