Filter navigation property EF core

c# entity-framework-core linq

Question

In my repository I try to filter the products with the variants active but I do not know how because is first time. I should return all products with or without variants active

public async Task<IEnumerable<Articolo>> GetArticoliByDivisioneAsync(string divisione)
{
    return await _ctx.Articoli
                     .Where(a => a.Divisione == divisione
                                 && a.Category!= "001")
                     .Include(i => i.Varianti)
                     .Include(i => i.FotoArticoli)               
                     .ToListAsync();
}

The field I want to filter on is in Varianti.

How can do .Where(v => v.Active == 1) ?

1
1
3/18/2019 8:18:28 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Just add your filter to where Method

public async Task<IEnumerable<Articolo>> GetArticoliByDivisioneAsync(string divisione)
{
    return await _ctx.Articoli
        .Where(a => a.Divisione == divisione
                  && a.Category!= "001"
                  && a.Varianti.Any(v=>v.Active == 1))
        .Include(i => i.Varianti)
        .Include(i => i.FotoArticoli)               
        .ToListAsync();
}

if you don't need the value of Varianti you can remove include part

public async Task<IEnumerable<Articolo>> GetArticoliByDivisioneAsync(string divisione)
{
    return await _ctx.Articoli
        .Where(a => a.Divisione == divisione
                  && a.Category!= "001"
                  && a.Varianti.Any(v=>v.Active == 1))
        .Include(i => i.FotoArticoli)               
        .ToListAsync();
}
1
3/16/2019 6:59:33 PM

Related Questions

Determine if property is a Navigation Property in EF Core

I'm building a simple change tracker to capture all the edits to a Sql Azure database (unfortunately, Sql Azure doesn't support this natively, so far as I can tell)....I'm walking the list of modified entries returned by ChangeTracker():...foreach( EntityEntry entry in _context.ChangeTracker.Entries() .Where( e => e.State == EntityState.Modifie...
c# entity-framework-core
asked by Mark Olbert

Include all navigation properties using Reflection in generic repository using EF Core

I'm working on creating a generic repository for an EF Core project to avoid having to write CRUD for all models. A major roadblock I've hit is navigation properties not being loaded since Core doesn't yet support lazy loading and the generic class obviously can't define .Include statements for class specific properties....I'm trying to do somethin...
c# entity-framework-core system.reflection
asked by Valuator

EF Core 2.0 - filtering IQueryable navigation property collection empty

Tech:...EF Core 2.0.0...Asp.Net Core Mvc 2.0.0...When i execute this method it throws ..."InvalidOperationException: Sequence contains no matching element"... on evaluating CurrentGrade. Why does it throw and how can I fix it?...I have a search method filtering on quite a lot of properties on a large dataset (10 000 users with thousands of related ...
asp.net-mvc entity-framework entity-framework-core
asked by Lindeberg

Filtering data by Navigation Property in EF Core

I have this small model:...class User { public int Id { get; set; } public Community { get; set; } } class Community { public int Id { get; set; } public Country { get; set; } } class Country { public int Id { get; set; } public string Name { get; set; } } ...The ...DbContext... is this:...public class SmallDbContext : DbC...
.net entity-framework entity-framework-core
asked by SuperJMN

EF core: cannot insert object with foreign key using ID properties (only navigation properties work)

I'm using Entity Framework Core to create my (code first) database model.... In the model I have these classes:...[Table("groups")] public class Group { public int? Id { get; set; } [JsonIgnore] public virtual ICollection<Membership> Members { get; set; } } [Table("identities")] public class Identity { public int? Id { get; set; } ...
c# entity-framework-core
asked by Paolo Tedesco

EF Core - Removing a related entity from collection navigation property does not update database

I am trying to understand this sentence:...By default, for required relationships, a cascade delete behavior is configured and the child/dependent entity will be deleted from the database....found in the "Removing relationships" paragraph in this Microsoft documentation of EF Core: ...https://docs.microsoft.com/en-us/ef/core/saving/related-data#rem...
asp.net-core c# entity-framework entity-framework-core
asked by Ray Roy

EF Core 2 - Relationship with only 1 navigation property/relationship knowledge?

I am using ASP.NET Core 2.2 with EF Core 2.2 and SQL server....I am currently working on a feature where I have the following classes:...TABLE Foo ------------------------------------------------------------- Column Type Remark -------------------------------------------------------------- Id ...
c# database ef-fluent-api entity-framework entity-framework-core
asked by S. ten Brinke

EF Core Navigation Property Include uses Left Join instead of Inner Join

In my API project, I have ...public class Team { [Key] public long Id { set; get; } [Required] public TeamSettings TeamSettings { get; set; } } public class TeamSettings { [Key] [Required] [Column("TeamSettingsId")] public long Id { set; get; } [Required] [ForeignKey("TeamId")] public long TeamId { get; ...
.net-core asp.net-core c# entity-framework-core sql-server
asked by Zion Hai

Setup EF core to not create Database Foreign Key for specific Navigation Property

Consider entities ...Company... and ...Product...:...public class Company { prop Guid Id {get; set;} } public class Product { prop Guid CompanyId {get; set;} prop Company Company {get; set;} } ...When creating migrations, I want the relationship from ...Product... to ...Company... not to create a foreign key constraint in the database....
c# ef-migrations entity-framework entity-framework-core
asked by Alireza

EF Core using navigation property when querying parent and child separatedly

I'm currently developing something with EF Core and I'm not yet fluent in linq-to-Entity or in linq for that matter....I have two entities that I need to query, one is the customer and the other are the invoices. But I need to retrieve only his/her latest invoice, and I only need customers that have been active (aka made a purchase) in the last x d...
c# entity-framework-core
asked by gris

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow