const { Connection, Request } = require('tedious'); const config = { server: 'localhost', authentication: { type: 'default', options: { userName: 'sa', password: 'password', }, }, options: { database: 'mydatabase', instanceName: 'SQLEXPRESS', rowCollectionOnRequestCompletion: true, }, }; const connection = new Connection(config); connection.on('connect', (err) => { if (err) { console.error(err); return; } console.log('Connected to database'); const request = new Request('SELECT * FROM mytable', (err, rowCount) => { if (err) { console.error(err); return; } console.log(`Returned ${rowCount} rows`); connection.close(); }); connection.execSql(request); });
const { ConnectionPool, Request } = require('tedious'); const config = { server: 'localhost', authentication: { type: 'default', options: { userName: 'sa', password: 'password', }, }, options: { database: 'mydatabase', instanceName: 'SQLEXPRESS', rowCollectionOnRequestCompletion: true, }, }; const pool = new ConnectionPool(config); pool.on('error', (err) => { console.error(err); }); (async () => { const connection = await pool.acquire().promise; const request = new Request('SELECT * FROM mytable', (err, rowCount) => { if (err) { console.error(err); return; } console.log(`Returned ${rowCount} rows`); pool.release(connection); }); connection.execSql(request); })();In the first example, a single connection is used to execute a query. In the second example, a connection pool is used to manage multiple connections and the pool is acquired and released for each query. Based on the import statement `const { Connection, Request } = require('tedious');`, it is most likely that the package library name is "tedious".