liveBook · Manning

Object-relational mapper

Also called ORM, object-relational mapping

An object-relational mapper is software that maps between programming-language objects and operations and relational database structures and operations.

How 9 Manning books explain it

Java Persistence with Spring Data and Hibernate epub

Object-relational mapping (ORM) is the technique of representing and synchronizing object-oriented domain models with relational database structures.

How it is used
Connects Java domain objects to relational tables while reducing repetitive persistence work.
How deep it goes
Explains mapping defaults, inheritance, associations, and navigation tradeoffs, with more complex association mappings treated separately.
Examples
Uses an auction domain model with users, billing details, items, bids, and hierarchical categories.
What you can do after
Apply ORM via Hibernate and Spring Data JPA while inspecting generated SQL and weighing fetch tradeoffs.

Read how Java Persistence with Spring Data and Hibernate epub explains object-relational mapper →

Django in Action

An object-relational mapper maps application objects and their operations to relational database records and queries.

How it is used
Connects Django views and web applications to relationally stored content through Python objects.
How deep it goes
Explains model-to-table and object-to-row mappings, relationships, reverse relationships, and CRUD operations without database implementation internals.
Examples
Illustrates books, authors, publishers, catalogs, articles, inventory, documents, and content-oriented websites.
What you can do after
Apply it via Django’s ORM to define models, store objects, query related content, and perform CRUD operations.

Read how Django in Action explains object-relational mapper →

Grokking Software Architecture

An object-relational mapper is a technique or software layer that represents relational database data as programming-language objects and translates operations between the two models.

How it is used
Uses ORMs as a data-access layer between object-oriented code and relational databases.
How deep it goes
Explains declarative querying and common performance leaks, including eager loading, projections, and untranslatable query logic.
Examples
Uses an active-user query, an orders-and-users N+1 scenario, and oversized profile images to illustrate ORM behavior.
What you can do after
Diagnoses common ORM query problems and selects eager loading, projections, or SQL-compatible logic as appropriate.

Read how Grokking Software Architecture explains object-relational mapper →

Building Web APIs with ASP.NET Core

An object-relational mapper is a software component that maps programming-language objects and operations to relational database structures and SQL operations.

How it is used
Provides standardized relational-data access for ASP.NET Core applications through C# rather than exclusively handwritten SQL.
How deep it goes
Explains object-schema mapping, ORM benefits, injection risks, context setup, entities, CRUD operations, and migrations.
Examples
Uses a user-notes update to contrast raw SQL, interpolated SQL, parameterized SQL, and an ORM-based C# update.
What you can do after
Operate/configure EF Core with a context, connection string, entity classes, CRUD operations, and migrations.

Read how Building Web APIs with ASP.NET Core explains object-relational mapper →

Build Financial Software with Generative AI (From Scratch)

An object-relational mapper is software that maps programming-language objects to relational database tables and operations.

How it is used
Positions an ORM as a possible replacement for handwritten SQL in an ACH file application.
How deep it goes
Defines ORM mapping and discusses its learning curve, while deferring integration.
Examples
Contrasts a Pydantic ACH file model and handwritten SQL wrapper with possible ORM adoption.
What you can do after
Evaluate whether an ORM could replace handwritten SQL after practicing database queries.

Read how Build Financial Software with Generative AI (From Scratch) explains object-relational mapper →

ASP.NET Core in Action, 3e

An object-relational mapper is a software abstraction that maps object-oriented program types and operations to database concepts such as tables, columns, and queries.

How it is used
Speeds application development by replacing much routine database plumbing with object-oriented data access.
How deep it goes
Explains mapping, generated SQL, change tracking, providers, and schema alignment, while warning that abstraction can hide inefficient queries.
Examples
Uses an e-commerce product lookup to contrast low-level database access with LINQ-based loading and tracked updates.
What you can do after
Apply it via EF Core to query relational data as POCO entities and persist tracked changes through a DbContext.

Read how ASP.NET Core in Action, 3e explains object-relational mapper →

The Quick Python Book, Fourth Edition

Object-relational mapping is a technique for representing relational database tables and rows as programming-language objects and attributes.

How it is used
Reduces boilerplate database work by exposing relational data through Python objects while preserving optional SQL access.
How deep it goes
Demonstrates setup, schema mapping, insertion, selection, filtering, updating, object mutation, and deletion, but not advanced relationships.
Examples
Uses a SQLite people table with Bob, Jill, Joe, and Jane to demonstrate creation, queries, filtering, updates, insertion, and deletion.
What you can do after
Apply it via SQLAlchemy to create mapped tables, persist Python objects, query records, update values, and delete rows.

Read how The Quick Python Book, Fourth Edition explains object-relational mapper →

AI-Powered Developer: Build software with ChatGPT and Copilot

Object-relational mapping is a technique that represents relational database records as objects and translates between object operations and database operations.

How it is used
Models an asset-management database as application classes so domain code can work with assets, funding details, and depreciation strategies.
How deep it goes
Defines table, column, primary-key, foreign-key, and model-method mappings, but does not show complete persistence operations.
Examples
Uses assets, funding details, depreciation strategies, typed columns, and an assets-to-funding-details foreign key.
What you can do after
Build it from scratch by declaring application models that correspond to relational tables and their key relationships.

Read how AI-Powered Developer: Build software with ChatGPT and Copilot explains object-relational mapper →

Spring Start Here, Second Edition

An ORM framework provides software for mapping application objects to relational database records and relationships.

How it is used
Maps relational tables and their relationships to application objects when implementing persistence.
How deep it goes
Defines object-relational mapping and notes potential benefits and risks, but does not detail mapping mechanics or configuration.
Examples
Contrasts direct JDBC queries and a proposed Hibernate migration with a completed JdbcTemplate rewrite.
What you can do after
Evaluate whether an ORM fits a persistence change by weighing shorter, more intuitive code against performance and bug risks.

Read how Spring Start Here, Second Edition explains object-relational mapper →

Also covered in

What to know first

Related concepts

Questions about object-relational mapper

What is object-relational mapper?

An object-relational mapper is software that maps between programming-language objects and operations and relational database structures and operations.

Which Manning books explain object-relational mapper?

Java Persistence with Spring Data and Hibernate epub, Django in Action, Grokking Software Architecture, Building Web APIs with ASP.NET Core, Build Financial Software with Generative AI (From Scratch), ASP.NET Core in Action, 3e, The Quick Python Book, Fourth Edition, AI-Powered Developer: Build software with ChatGPT and Copilot and 1 more.

What should I know before learning object-relational mapper?

Manning books that teach object-relational mapper usually introduce SQL, NoSQL database, database table and entity first.

What kinds of object-relational mapper are there?

Kinds of object-relational mapper include Entity Framework Core, SQLAlchemy, Prisma and Diesel.

What is object-relational mapper also called?

Object-relational mapper is also called ORM or object-relational mapping.

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.