StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to create a Generic Repository a 'deep include'?
text
Body
copied!<p>I have created a Generic repository with some methods on top of EF Codefirst, which works great. The Get method looks like this (this has include for one level)</p> <pre><code>public virtual IEnumerable<T> Get( Expression<Func<T, bool>> filter = null, Func<IQueryable<T>, IOrderedQueryable<T>> orderBy = null, string includeProperties = "") { IQueryable<T> query = _dDbSet; if (filter != null) query = query.Where(filter); query = includeProperties.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Aggregate(query, (current, includeProperty) => current.Include(includeProperty)); return orderBy != null ? orderBy(query).ToList() : query.ToList(); } </code></pre> <p>But I stumble on a problem when I need the generic repository to return a 'deeper' include</p> <p>An example: A Hotel object have a relation to a list of rooms and each room have a relation to person.</p> <p>I want my method to return a Hotel object with a list of rooms with the person of those rooms related.</p> <p>How can I solve this by using a GenericRepository?</p> <p>I do not want to use the solution:</p> <pre><code> var hotel = _hotelRepository.Context.Hotels.Where(p => p.HotelId == HotelId).Include(p => p.RoomList.Select(b => b.Person)).First(); </code></pre> <p>in my bussinesclass because I want to seperate out the data access to the genericRepository and be able to Mock out the method in my test project.</p> <p>Is there a good solution for this, or do I have to use the context with a Select as mentioned above?</p> <p>Thanks!</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload