Consider following entity model: public class Parent { public virtual FirstChild FirstChild { get; set; } public virtual SecondChild SecondChild { get; set; } } In my code, I have loaded Paren...

I have a table of restaurants that have many reservations. Now I would like to query all restaurants and in case they have reservations for 2 people it should preload these associations. In case th...

I use Entity framework 6. I have a Transaction object with several navigation properties. It is easy to implement eager loading using multiple Include. var aa = db.Transactions.Include(p => p.A...

My application uses Entity Framework 7 and the repository pattern. The GetById method on the repository supports eager loading of child entities: public virtual TEntity GetById(int id, params Expre...

I will try to simplify the problem as much as I can. I want to disable a relation load from a trait on a resource that happens at the retrieved event. There is a model we will name Post that uses a...

I'm trying to select only certain columns using eager_load, but I'm facing the problem that it cancels my 'select'. Model: class Timeline < ActiveRecord::Base belongs_to :timeline_category, f...

I've got a Hibernate object which's properties are all loaded lazy. Most of these properties are other Hibernate objects or PersistentSets. Now I want to force Hibernate to eager load these proper...

What laravel says: $books = App\Book::with('author.contacts')->get(); What I need is something like this $books = App\Book::with('author[contacts,publishers]')->get(); where we eager lo...

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 { pu...

The Include() method works quite well for Lists on objects. But what if I need to go two levels deep? For example, the method below will return ApplicationServers with the included properties shown...

Laravel Version: 5.5 PHP Version: 7+ Database Driver & Version: mysql 5.7+ Scenario: I have a SaaS application that has flexible database structure, so its fields are bound to change, espec...

I have the model that has relation to itself like this public function children() { return $this->hasMany(AppointmentPart::class,'parent_id'); } I want to eager loading for queries for this ...

Using Symfony 3.2 and Doctrine 2.5, I have trouble to understand how fetch "EAGER" should work in many-to-many and many-to-one relationship. Lets say we have two entities, User and Site, and a man...

class Taak : [Key] public int TaakId { get; set; } public int Pid { get; private set; } [Required] [Range(0,23.5)] public double Uur { get; private set; } [Required] public Functie Funct...

I have some models like those below: public class Mutant { public long Id { get; set; } ... // Relations public long OriginalCodeId { get; set; } public virtual OriginalCode OriginalCode { g...

I have the following models in my application: User.php <?php namespace App\Models; use Illuminate\Database\Eloquent\Model; class User extends Model { public function customer_details() { ...

When querying a DbContext with eager loading, it is required to Include("Navigation") in order to populate Navigation Properties. However on some occasions I would like to simply Include all naviga...

i have four model Tehsil, Ilr, Patwar, and Villages. and their association is Tehsil -> 1:m -> Ilr -> 1:m -> Patwar -> 1:m -> Villages i want to to apply order by on all four of my models. Query...

I have a Notifications model that belongs to a User. I want to load the user when a collection of notifications is selected and only load the model with names and emails. However, when using the se...

I have Banks table and separate table with services $bank = Banks::find(1); echo $bank->service(1); // print bank with that service (serviceId 1) It is posible to eager load all banks with s...

Class User < ActiveRecord::Base has_many :posts, dependent: :destroy end Class Post < ActiveRecord::Base belongs_to :user end When a User having N posts is destroyed, N+1 queries are run ...

I want to scale separately some subparts of my rails app and avoid loading the whole codebase. For the sake of example, let's consider an APIv1 vs an APIv2, but I'd also want to extend this any cl...

I have two entities Dept and Emp (real case changed and minimized). There is 1:n association between them, i.e. properties Dept.empList and Emp.dept exist with respective annotations. I want to get...

It seems to me that fragment caching and eager loading are -- at least sometimes -- somewhat at odds with each other. Let's say I have a User who has many posts which each has many comments which i...

We have a few apps that are currently using an EF model that has lazy-loading enabled. When I turn off the lazy-loading (to avoid implicit loads and most of our N+1 selects), I'd much rather have a...