Eager loading is a process where related entities are loaded along with the target entity. Eager loading does this by using the Include method. Entity Framework creates a join query, when it sees the Include method, thus bringing all the records in one single query.
Lazy loading is the process where the Entity Framework delays the loading of an entity or collection of entities until the time application actually needs it. In this tutorial let us find what is Lazy loading
Entity Framework starting from Version 6.0 allows us to log the commands & queries sent to the database. The Logging is done by using the DbContext.Database.Log property, which can be set to a delegate for any method that takes a string. All the actions performed by the Entity Framework is logged, which includes opening a connection, closing a connection, database initialization , Add, Edit, Insert & Select Queries, etc
In this tutorial let us look into how to use Join Query to load the data from two or more tables.
In this tutorial let us look into how to load the Related data. In the last tutorials so far we learned how to retrieve the data from the single table. In the tutorial let us look how to retrieve the data from the multiple related table.