Filter in child list LINQ Entity Framework

Entity Framework 6: Adding child object to parent's list vs. setting child's navigation property to parent

I have an existing database with two tables ...MailServers... and ...MailDomains... in it. ...MailDomains... has the foreign key column ...MailServerId... pointing to the ...Id... primary key column in ...MailServers.... So we have a one-to-many-relationship here....I followed ...this article... and created my Entity Framework POCOs via the "Code f...

Entity Framework - Updating entity with added/modified child and grandchild entities

I am not sure if I am doing this the right way or not, so need advice....I have an entity, this entity has a child collection, and each child entity has another child collection. Something like this (simplified example)...public MyEntity() { public long Id { get; set; } public ICollection<MyChild> Children { get; set; } } public MyChild() ...

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 include filter child collection

I was able to achieve this in EF Core. I'm pretty sure the same concept applies in EF6....Simplifying your example:...var item = ctx.Order.Include("Inner") .Where(x => x.Inner.Any(innerItem => innerItem.IsDeleted)) .FirstOrDefault();

Child Model List is Empty after DB Add in Entity Framework Core

I'm just transcribing the answer I was given, which was provided in the comments of the original post, so that it can easily be found by anyone reading the post....The issue was, quite simply, that EF Core does not yet support lazy loading. So when the Site entity is populated, it doesn't lazily load the list of dependent locations into the collect...

Filter linq query in entity framework core, many-to-many relationship

I'm using the ASP Net Core 2. I have a test model:...public class Player { public int Id { get; set; } public string Name { get; set; } public string Position { get; set; } public int Age { get; set; } [IgnoreDataMember] public ICollection<PlayerTeam> PlayerTeams { get; set; } public Player() { PlayerTeams =...

Entity Framework Core Linq query to filter related entity

@Slava answer looks correct. But I want to extend his answer. If you want to use ...like... in your query, you can use ...EF.Functions.Like...method. It is less expensive in terms of memory and handles complex expressions. You can use the same in your scenario also like the below code. On relational databases, this is usually directly translated to...

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 Parent Child items in the same model, children node returns null

I have a parent and child property inside one domain model....public class TestModel { public int ParentID { get; set; } public int ID{ get; set; } public string Name{ get; set; } public virtual TestModel parent { get; set; } public virtual List<TestModel> children { get; set; } } ...When I write ...OnModelCreating... event as b...

What is the syntax for a LINQ filter for List<string>?

I have a C# program using EF Core....I fetch my records like this:...List<MyEntity> candidateRecords = await myFilters.ToListAsync(); ...I build my filters like this:...IQueryable<MyEntity> myFilters = from m in context.MyEntity select m; if (!string.IsNullOrEmpty(criterion1)) myFilters = myFilters.Where(s => s.S...