ORM (Object Relational Mapping) is a programming concept of a mapping between Object Oriented Programming and Relational Database. It’s the technique to frame the components of Relational Database to Object Oriented Programming, to do CRUD operations. It creates an object oriented representation of a relational database, so that developers can push or pop data to database as an object.
 

  Databases are designed on the basis of Mathematical principle where as programming languages like Java, C++, C# are based on Object Oriented Programming principle. Objects have behavior and attribute, it’s good on business modeling where on the other hand database is only deals with large amount of data. Now due to this conceptual deference, in real life scenario, database transactions become unmanageable, when we are dealing with large amount of data transaction. So to bridge this difference, ORM is introduced. It’s the process of mapping tables to class objects, so that data transactions could be easier.


Pros:

1. Create classes replicating database tables, in programming language side, so that programs can interacts with objects not direct tables.
2. Provides APIs for normal CRUD (Create Read Update Delete) operations, so no need to write queries for that.
3. Some provides query language which is database independent.
4. Provision to interact with multiple databases.
5. Helps to manage business logic easily when dealing with big amount of data, and lots of database transaction.

Corns:

1. No need to use when your application doesn't involve much database interaction.
2. Little bit heavier than native database connectivity.

Framework:

A framework is a basic conceptual and reusable structure which provides generic functionality, used to solve or address complex issues.

A software framework provides basic architecture, application programming interfaces (APIs) and tools for building application and provides required infrastructure.

Library v/s Framework:

Library: Library or code library is a collection of behavior written is a specific language, which can be used to execute some function. You use it the way you want.

Framework: It controls you. You can’t deviate from the framework rules and create application.