Home   programming  

What is ORM (Object-Relational Mapping) technologies

ORM (Object-Relational Mapping) technologies are used to map objects in programming languages to database tables, allowing developers to interact with databases using the object-oriented paradigm. This simplifies database operations by abstracting the SQL queries and enabling CRUD (Create, Read, Update, Delete) operations through object methods. Here are examples of ORM technologies in Node.js and .NET.

Node.js ORM Technologies

1. Sequelize

Sequelize is a promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite, and Microsoft SQL Server. It supports many database systems and provides a powerful toolkit for interacting with databases using JavaScript.

2. TypeORM

TypeORM is an ORM that can run in Node.js, browsers, Cordova, PhoneGap, Ionic, React Native, NativeScript, Expo, and Electron platforms. It supports multiple databases and is written in TypeScript.

3. Prisma

Prisma is an ORM technology, specifically designed for modern database access in JavaScript and TypeScript applications. Prisma offers a type-safe and auto-generated query builder that makes database interactions more intuitive and less error-prone.

.NET ORM Technologies

1. Entity Framework Core

Entity Framework Core (EF Core) is a lightweight, extensible, open-source, and cross-platform version of the popular Entity Framework data access technology. EF Core can serve as an ORM to a wide variety of databases.

2. Dapper

Dapper is a simple object mapper for .NET that extends IDbConnection. It provides a balance between control over raw SQL and the simplicity of an ORM.

Published on: Jul 04, 2024, 11:37 AM  


Add your comment