Environment variable setup SQL Server

npm install dotenv

create a file in root of your application name it .env and past bellow code

DB_HOST=’localhost’
DB_Database=Seneca
DB_USER=mehdi
DB_PASS=test#tests12345
DB_PORT=1433

Then in your db connection file or dbprovider file call it like bellow code:

const sql = require(‘mssql’);

const dotenv = require(‘dotenv’);

dotenv.config();

const config = {

    user: process.env.DB_USER,

    password: process.env.DB_PASS,

    server: process.env.DB_HOST, // You can use ‘localhost\\instance’ to connect to named instance

    database: process.env.DB_Database,

    port: process.env.DB_PORT,

  }

const poolPromise = new sql.ConnectionPool(config)

  .connect()

  .then(pool => {

    console.log(‘Connected to MSSQL’)

    return pool

  })

  .catch(err => console.log(‘Database Connection Failed! Bad Config: ‘, err))

module.exports = {

  sql, poolPromise

}