var sql = require('mssql');

var config = {
    server: 'update me',
    database: 'update me',
    user: 'update me',
    password: 'update me ',
    port: 1433,
    encrypt:true
};
function loadEmployees() {

    console.log("Starting ExecuteQuery");
    console.time("ExecuteQuery");
    var dbConn = new sql.ConnectionPool(config);

    console.time("connection");
    dbConn.connect().then(function () {

        console.timeEnd("connection");
        var request = new sql.Request(dbConn);

        // console.time("Quering");
        request.query(`select * from employees`).then(function (recordSet) {
           // console.log(recordSet);
        //    console.timeEnd("Quering");
        //    console.time("Closing");
            dbConn.close();
            // console.timeEnd("Closing");
            console.timeEnd("ExecuteQuery");
            console.log("Completing ExecuteQuery");
        }).catch(function (err) {

            console.log(err);
            dbConn.close();
        });
    }).catch(function (err) {

        console.log(err);
    });
}

loadEmployees();