What is ORM(Object-Relational Mapping)?

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

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.

We have EF approaches :

1)ModelFirst
2) DbFirst
3)CodeFirst

What is Lazy Loading?

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.

What is Eager Loading?

Eager Loading moves only the desired part of the data into the ram space. It pulls data with less performance in a single query.

File in Data_Access

1-DbFirst_LinQ_To_Entity_Example
2-DbFirst_LinQ_To_Sql_Example
3-CodeFirst_PhoneDirectory_Example
4-CodeFirst_MyNorthwind_LazyLoading
5-Dapper_MicroORM