Entity Framework Core - Knowledge Base (KB)

EntityFramework.Plus: One or more validation errors were detected during model generation

I am using the audit feature of EntityFramework.Plus in an EF6 Code First project. When I add the following code:...public virtual DbSet<AuditEntry> AuditEntries { get; set; } public virtual DbSet<AuditEntryProperty> AuditEntryProperties { get; set; } s...

Simple Linq Select not working

I'm trying to select a list of integers and it's raising an exception....Exception message: System.ArgumentException: Expression of type 'System.Collections.Generic.IAsyncEnumerable1[System.Int32]' cannot be used for parameter of type 'System.Collec...

Why my entity primary key shows to be modified after updating entity?

I have a class ...ApplicationUser... that inherits from ...IdentityUser.... I added the property ...LastLoggedIn... which is ...OffsetDateTime... datatype and I modify it with every request to the API. Also, I am using ...Audit... from entityframework plu...

Entity Framework Z Plus Batch Update

I am using Entity Framework Z Plus Batch Update method. I am unable to proceed due to below issue. Actually Update method works good when i give static values like ...tagName="amir1".... But I need to get the ...Tagdescription... from a web service or fro...

Entity Framework Plus - FutureValue() in a foreach loop

Recently I started using ...EF+... on our project with great success however sometimes I run into an issue that I have a set of entities for which I need to run a separate query....So if I have a set of 20 customers I need to run 20 queries separately. I ...

ef core plus: ArgumentNullException: Value cannot be null. Parameter name: property

With ef core plus, I'm trying to update a set of rows on my model:...await _context.Set<Critique>() .Include(c => c.User) .Where(c => c.Closed && c.User.Id == user.Id) .UpdateAsync(c => new Critique() { User = deletedUs...

How can I batch update jsonb field using Entity Framework Extensions library?

I use PostgreSQL with EntityFrameworkCore. I need to batch update ...jsonb... field. The Z.EntityFramework packages look promising however none of them work for me....I setup jsonb field with EntityTypeBuilder:...builder.Property(o => o.Description).HasCo...

How to filter and include children using Z.EntityFramework

The query below is using Z.EntityFramework.Plus.EF6 to filter children. Its filtering and including the ...AssetXref... entity correctly however the result is not able to include ...Child.Parent... entity relationship... var result = await _repository.G...

How to use code-first with EntityFramework-Plus' audit feature?

I'm trying to setup ...EntityFramework Plus' Audit Auto-Save feature..., but it looks like I'm stuck at something very dumb. I'm following the "Saving automatically by overriding SaveChanges & SaveChangesAsync" path, but I'm trying to use code-first as th...

How to filter grand children using EF PLUS

I want get to ...Parent... and its only active ...Children... and active ...Grand Children... using Entityframework Plus...Relationship... Parent -> Children -> GrandChildren...var parent = await _dbContext.Parent .IncludeFilter(p=>p.Children...

InvalidCastException when using IncludeFilter on entity with DateTime property"

I'm encoutering an InvalidCastException that I don't understand, related to the Entity Framework Plus library and its IncludeFilter extension method in particular....To summarize, I have 3 entities: Project, Test and TestRun: - each Project has a collecti...