ORM for Node JS like .net Entity Framework?

sql-server node.js entity-framework express ejs
gaurav bhavsar picture gaurav bhavsar · May 5, 2015 · Viewed 21.1k times · Source

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.

Answer

Kevin picture Kevin · May 5, 2015

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

Related questions

Node.js MSSQL tedius ConnectionError: Failed to connect to localhost:1433 - connect ECONNREFUSED

I am trying to connect to MSSQL 2012 using NodeJS with the mssql connection interface. When attempting to connect I get the following error: { [ConnectionError: Failed to connect to localhost:1433 - connect ECONNREFUSED] name: 'ConnectionError', message: 'Failed to conncet to localhost:1433 …

Read More
Node.js and Microsoft SQL Server

Is there any way I can get my Node.js app to communicate with Microsoft SQL? I haven't seen any MS SQL drivers out there in the wild? I'm putting a very simple app together and need to be able …

Read More
How can I use a single mssql connection pool across several routes in an Express 4 web application?

I want to use node-mssql as a MSSQL database connector in a Node JS Express 4 web application. Route handler logic is handled in separate files. How do I create a single/global connection pool and use it across several files …

Read More