SQL Server ORM for Node JS like .net Entity Framework?

sqougxex 于 2023-03-17 发布在 .NET

关注(0)|答案(4)|浏览(153)

I am new in node JS, and try to implement CRUD using Node JS, Express JS , MS SQL, EJS. And I am already finished with CRUD.

But I am looking for some more reliable way to pass data or object from node to sql and vice versa.

I have to write an INSERT SQL query when I am going to insert record i.e creating entry in any table.

So, can any one know, is there any ORM which help me to deals with SQL query Like we deals in .net entity framework ?

Thank in advance.

sql-server

来源：https://stackoverflow.com/questions/30046280/orm-for-node-js-like-net-entity-framework

4条答案

按热度按时间

wfauudbj1#

You can use Sequelize ORM, it supports MSSQL: http://docs.sequelizejs.com/en/latest/docs/getting-started/

赞(0）回复(0）举报 2023-03-17

11dmarpk2#

Here are some ORM and their comparison Sequelize is one of the most downloaded and featured ORM for node.js

Visit for more detail

赞(0）回复(0）举报 2023-03-17

2mbi3lxu3#

TypeORM seems to be the best suited for Entity Framework nowdays

It allows to define entities very much like Entity Framework does with data annotations.

Plus it is totally TypeScript friendly. =)

import {Entity, PrimaryGeneratedColumn, Column} from "typeorm";

@Entity()
export class User {

    @PrimaryGeneratedColumn()
    id: string;

    @Column()
    firstName: string;

    @Column()
    lastName: string;

    @Column()
    isActive: boolean;

}

赞(0）回复(0）举报 2023-03-17

whlutmcx4#

My answer is maybe late but now You have option to use C#/EF in node http://tjanczuk.github.io/edge/#/

赞(0）回复(0）举报 2023-03-17