ORM acts as a bridge between software and database. We can query, read and make changes to our data.Object-relational-mapping is the idea of being able to write queries , as well as much more complicated ones, using the object-oriented paradigm of your preferred programming language.
Entity Framework is a tool for Object Relational Mapping.It is like a bridge between OOP and Relational Data Base.Entity Frame Work works as an assistans by getting data and bound your database object.Entity Framework works with Ado.Net.
1)ModelFirst
2) DbFirst
3)CodeFirst
Lazy Loading moves the entire data to the heap area of the ram. According to the need, the data is taken from the heap area.
Eager Loading moves only the desired part of the data into the ram space. It pulls data with less performance in a single query.
1-DbFirst_LinQ_To_Entity_Example
2-DbFirst_LinQ_To_Sql_Example
3-CodeFirst_PhoneDirectory_Example
4-CodeFirst_MyNorthwind_LazyLoading
5-Dapper_MicroORM