Entity Framework Using a Where Clause on a Nested Entity

c# entity-framework entity-framework-6

Question

I'm trying to filter child objects on the retrieval using the following

var loanExtractExample = be.LoanCategoryMonitors
                .Where(lcm => lcm.LoanNumber == 5000435)
                .Include(l => l.Loan)
                .Include(le => le.LoanExtracts)
                .Select(le => le.LoanExtracts.Borrowers.Where(b => b.BorrowerNum == 1))
                .ToList();

but when I check the entity collection there are 2 borrowers. One with BorrowerNum 1 and one with BorrowerNum = 3.

What am I missing to be able to reduce the borrowers to the correct one?

1
4
6/7/2018 3:10:28 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

The Select for the borrowers I believe would returning the borrowers for loan category monitors where a monitor had a borrower with ID 1. I believe what you are looking for is:

var matchingBorrowers = be.LoanCategoryMonitors
                .Where(lcm => lcm.LoanNumber == 5000435)
                .SelectMany(le => le.LoanExtracts.Borrowers) // Borrowers for loan extracts against loan 5000435...
                .Where(b => b.BorrowerNum == 1)) // Of those borrowers, those with BorrowerNum = 1.
                .ToList();

Includes aren't needed since you're not retrieving a loan category monitor, but you might want to add any .Include() statements for child references of the borrowers that are returned. (after the .SelectMany())

0
6/7/2018 8:15:45 AM

Related Questions

Entity Framework 6 Batch Updates and AuditLog using Entity Framework Extended

You should enable the Auditor...var auditConfiguration = AuditConfiguration.Default; auditConfiguration.IncludeRelationships = true; auditConfiguration.LoadRelationships = true; auditConfiguration.DefaultAuditable = true; ...just add it to place where your app is initialized, Global.asax.cs for example...edited...Far as I know you can't get old val...
entity-framework entity-framework-5 entity-framework-6 entity-framework-extended
asked by Temaska

Entity Framework, Load multiple entities by primary key in a single query while still using caching

Not implicitly....Where()... will always query the database. To explicit query the cache you need to use ....Local...: ...dbContext.Entity.Local.Where(......This will not hit the database but it will only return entities that have been cached/loaded before....Good to know: to view the queries define a Log function like this: ...dbContext.Database.L...
.net c# entity-framework entity-framework-6
asked by Chris

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

I modified some code, please review it. ...In class ...DbRepository..., added another constructor, to make sure there is the same ...DbContext... in different ...DbRepository.......public DbRepository(MyContext myContext) { _context = myContext; } ...In class ...Person... added 2 properties, to ensure the relation between ...Person... and ...P...
c# entity-framework-core
asked by kcwu

Reattach modified entity with nested child entities

I´m trying same thing as you, i´m not sure to understand quite well your reasson thought, but probably this document will help you....https://msdn.microsoft.com/en-us/library/jj592676(v=vs.113).aspx...Also, i´m almost sure that you don´t need to execute .Add() in your example, that will result in new record most of the cases, or in "Unchanged" ...
c# dbcontext entity-framework entity-framework-6
asked by Yogurtu

Entity Framework Include Nest collection and nested properties

I have 4 classes...public class Customer { public string CustomerName { get; set; } public ICollection<Order> Orders{ get; set; } } public class Order { public string OrderNumber { get; set; } public ICollection<OrderLine> OrderLines { get; set; } public OrderType Type { get; set; } } public class OrderLine { public string...
c# entity-framework entity-framework-core
asked by user2859298

Entity Framework Core 2.0.1 Eager Loading on all nested related entities

I have a simple problem, but cant seem to find a way around it. I am using Entity Framework Core version 2.0.1 and want to eager load all my entities by default....Example:...public class Order { public int Id { get; set; } public string Name { get; set; } public int CustomerId { get; set; } public Customer Customer { get; set; } } ...
c# eager-loading entity-framework-core
asked by Jinish

Entity Framework Core: Fail to update Entity with nested value objects

I have an entity that has a value object and this value object has another value object. My issue is that when updating the entity along with the value objects, the entity with the parent value object get updated but the child value object didn't. note, i used latest version of Entity Framework Core 2.1.0-rc1-final this is the parent entity Employe...
c# entity-framework-core entity-framework-core-2.1 value-objects
asked by yo2011

How can I prepare WITH CLAUSE using Oracle .Net entity framework queries

If I understood the problem, it is that you can't use the ...WITH... factoring clause. If that's so, move the ...EVENTS... CTE into the ...FROM... clause:...select * from (select * from EVENTS_ATCS WHERE ROWNUM <10) A --> this is EVENTS LEFT JOIN ATCS_EVENT_MASTER B ON (A.TYPEID = B.EventId) AND ((A.BYTE1 >= B.GE_BYTE1 AND A.BYTE1 <= ...
common-table-expression entity-framework entity-framework-6 oracle
asked by Littlefoot

Entity Framework Core 3.1 is throwing "Include has been used on non entity queryable" exception

An observation, your domain models PropertyToList and Property both have virtual properties. On top of that you are using Include operator to select these properties. ...This is not necessary, when property is defined with virtual, then it will be lazy loaded. So an Include is not needed. Lazy loading is not the recommended way, using include is be...
.net-core .net-core-3.1 asp.net-core entity-framework entity-framework-core
asked by Joe Ipe

Create nested data from JSON using .net core Entity Framework

If you want to create Group without User create a GroupPost class....public class GroupPost { public GroupPost(){ Users = new List<UserPost>(); } public string Name { get; set; } public List<UserPost> Users { get; set; } } public class UserPost { public string Name { get; set; } } [HttpPost] [ProducesResponseType(typeo...
.net .net-core c# entity-framework entity-framework-core
asked by Onur Åžahin

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