Object-relational mapper
An object-relational mapper is software that maps between programming-language objects and operations and relational database structures and operations.
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.
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.
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
- Secure APIs
- Rust Web Development
- Simple Object-Oriented Design: Create clean, maintainable applications
- gRPC Microservices in Go
- .NET in Action, Second Edition
- Crack Any Codebase with AIIn early access (MEAP)
- Kafka Streams in Action, Second Edition
- ScyllaDB in Action
- React in Depth
- Grokking Web Application Security
- Functional Design and Architecture: Examples in Haskell
- Pro ASP.NET Core 7, Tenth Edition
What to know first
- SQLSQL is a standardized declarative language for defining, querying, and manipulating data in relational database systems.
- NoSQL databaseA NoSQL database is a database system organized primarily around nonrelational data models rather than the traditional relational table model.
- database tableA database table is a relational data structure that organizes records into rows whose values correspond to defined columns.
- entityAn entity is a distinct, identifiable object, concept, participant, or record represented in a system's model or data.
Related concepts
- Entity Framework Coreincludes · Entity Framework Core is a cross-platform object-relational mapper for .NET that enables applications to work with databases through .NET objects and queries.
- SQLuses · SQL is a standardized declarative language for defining, querying, and manipulating data in relational database systems.
- SQLAlchemyincludes · SQLAlchemy is a Python SQL toolkit and object-relational mapping library for connecting to and working with relational databases.
- object-relational impedance mismatchaddresses · Object-relational impedance mismatch is the structural and conceptual difficulty of representing object-oriented application models in relational database models, and vice versa.
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.








