Entity Framework Core 3.0 new features - filtered include

How to filter "Include" entities in entity framework?

Entities:... public class Room { public Room() { this.Reservations = new HashSet<Reservation>(); } public int Id { get; set; } public decimal Rate { get; set; } public int HotelId { get; set; } public virtual Hotel Hotel { get; set; } public virtual ICollection<...

Entity Framework Core include filter

I'm new to C# and Entity Framework Core. I have searched a lot for this question but did not found an answer. I have the following three models (I have simplified it): ...public class Exercise { public int ExerciseId { get; set; } [Required] public string ExerciseName { get; set; } public string Filename { get; set; } public ...

Issue when inserting new entity with relationships to existing entities (Entity Framework Core 1.1.0 )

I have encountered an issue when inserting (...Add... method of EF API) or updating (...Update... method of EF API) entities holding reference properties to existing entities (I call existing entity an entity that already exists in the database, and has its PK properly set)....The model consists in ...Place..., ...Person..., ...Address..., and ...S...

Entity Framework Core Include with Filter

I am trying to bring a list of objects that have a list of child objects as well from the database....Here is an example... public class User { public int Id { get; set; } public ICollection<Child> Childs { get; set; } } public class Child { public int Id { get; set; } public string UserId { get; set; } public User User {...

What SQL Server 2017 features are not supported in Entity Framework Core code first?

Our team is thinking of utilizing Entity Framework Core code-first to help model the database. We can have both DB projects and EF models, as per article here ...Database Projects vs. Entity Framework Database Migrations... utilizing schema compares, just trying to figure out what will be the source of truth?...Does Entity Framework support all fea...

Entity Framework Core: Global query filter not filtering correctly after data change

We implemented a soft deletion pattern with Entity Framework Core, very similar to ...this solution..., but with a nullable column "DeleteDate" instead of an IsDeleted flag. If the date is filled, the row is considered deleted and filtered out:...modelBuilder.Entity<TEntity>().HasQueryFilter(e => !EF.Property<DateTime?>(e, "SysDeletedOn").HasValue)...

Entity Framework Core 3.0 - Lambda expression used inside Include is not valid

Here below I am using lambda expression in LINQ Includes for 1 level, to fetch a list of customers using three entities, the main one is for all Customers and has only 2 properties Id and bool: IsCompany, the second one has only those that are companies, and the third one has only those that are individuals. The below code was working using .Net Co...

Include Filters for Entity Framework Core

I've been trying to find out information about filtering my calls to the database to reorder the data from the database and have found out their is no way yet to filter the ....Inclunde... or ....ThenInclude.... ...Below is what I have tried, is there a way of sorting a collection?...var workout = await context.Workouts /...

Entity Framework Core .Include() is filtering the query

I am using EF Core 3.1.3 and I am have these two queries:...var test = await _unitOfWork.Context.PersonEmail .OrderBy(e => e.EmailId) .Take(10) .Include(e => e.EmailRecord) .ToListAsync(); var test2 = await _unitOfWork.Context.PersonEmail .OrderBy(e => e.EmailId) .Take(10) .ToListAsync(); ...I was expecting both queries ...

Automapper Entity Framework Core Include Filter Mapping Issue

After a bit of research I am aware you cannot have an include filter on an entity framework core clause. My collection entity ...Skill... has a soft delete flag which I need to filter out from the collection sat inside of ...SkillGroup.... I have used a select to create the list I need however the automapper fails as the types are different. I coul...