How to connect to SQL Server database using Node.Js

-

Description

  • A quick overview on SQL Server configuration, in order to get connected through Node.Js
  • Using "mssql" npm package to connect to SQL Server using Node.Js
  • How to use "Connection" object to connect to SQL Server
  • How to use "Request" object to execute SELECT statement and fetch results
  • How to handle SQL Server Connection Errors (from Node Js)
  • How to handle SQL statement execution Errors (from Node Js)

Source Code:


var sql = require("mssql");

var dbConfig = {

    server: "localhost\\SQL2K14",
    database: "SampleDb",
    user: "sa",
    password: "sql2014",
    port: 1433
};

function getEmp() {
    var conn = new sql.Connection(dbConfig);
    conn.connect().then(function () {
        var req = new sql.Request(conn);
        req.query("SELECT * FROM emp").then(function (recordset) {
            console.log(recordset);
           conn.close();
        })
        .catch(function (err) {
            console.log(err);
            conn.close();
        });    
    })
    .catch(function (err) {
        console.log(err);
    });

 

    //--> another way

    //var req = new sql.Request(conn);

    //conn.connect(function (err) {

    //    if (err) {

    //        console.log(err);

    //        return;

   //    }

    //    req.query("SELECT * FROM emp", function (err, recordset) {

    //        if (err) {

    //            console.log(err);

    //        }

    //        else {

    //            console.log(recordset);

    //        }

    //        conn.close();

   //    });

    //});
}

getEmp();

Comments

Post a Comment

Popular posts from this blog

Form submit resulting in “InvalidDataException: Form value count limit 1024 exceeded.” In ASP.NET Core

-
You can change the default formvalue limit using the   FormOptions . If you are using MVC, then you can create a filter and decorate on action where you want to extend this limit and keep the default for rest of the actions. namespace Filter {     using System;     using Microsoft.AspNetCore.Http.Features;     using Microsoft.AspNetCore.Mvc.Filters;     /// <summary>     /// Request Form Size Limit Attribute     /// </summary>     /// <seealso cref="System.Attribute" />     /// <seealso cref="Microsoft.AspNetCore.Mvc.Filters.IAuthorizationFilter" />     /// <seealso cref="Microsoft.AspNetCore.Mvc.Filters.IOrderedFilter" />     [AttributeUsage(AttributeTargets.Class | AttributeTargets.Method, AllowMultiple = false, Inherited = true)]     public class RequestFormSizeLimitAttribute : Attri...
Read more

What is the importance of EDMX file in Entity Framework

-
Image
ADO.NET entity is an ORM (object relational mapping) which creates a higher abstract object model over ADO.NET components. So rather than getting into dataset, datatables, command, and connection objects as shown in the below code, you work on higher level domain objects like customers, suppliers, etc. DataTable table = adoDs.Tables[ 0 ]; for ( int j = 0 ; j < table.Rows.Count; j++) { DataRow row = table.Rows[j]; // Get the values of the fields string CustomerName = ( string )row[ " Customername" ]; string CustomerCode = ( string )row[ " CustomerCode" ]; }   Benefits of using EF The main and the only benefit of EF is it auto-generates code for the Model (middle layer), Data Access Layer, and mapping code, thus reducing a lot of development time. The importance of EDMX file in Entity Framework    EDMX (Entity Data Model XML) is an XML file which contains all the mapping details of how your objects map ...
Read more

Calculate Dynamic Current Calendar / Financial Year In C#

-
I need a financial / calendar year based on current or today's date time We need some time dynamically financial year or calendar year base on current date. Suppose any company or organization have calendar year like 1 st  Jan to 31 th  Dec, 1 st  Feb to 31 th  Jan, 1 st  Apr to 31 Mar, 1 st  Oct to 31 th  Sep etc...… So we need calculate current calendar year base on calendar start month of organization /company. Examples Suppose Today's date is 5 th  Feb 2017 and organization calendar start month is Jan(01) then current calendar year we will be 1 st  Jan 2017 to 31 th  Dec 2017. Suppose Today's date is 10 th  Mar 2017 and organization calendar start month is Apr(04) then current calendar year we will be 1 st  Apr 2016 to 31 th  Mar 2017. Suppose Today's date is 10 th  May 2018 and organization calendar start month is Apr(04) then current calendar year we will be 1 s t Apr 2018 to 31 th  Mar 2019...
Read more