SQL Server Driver

Use this driver for Microsoft SQL Server deployments.

Install

npm

npm install @gradii/fedaco @gradii/fedaco-sqlserver-driver tedious

yarn

yarn add @gradii/fedaco @gradii/fedaco-sqlserver-driver tedious

pnpm

pnpm add @gradii/fedaco @gradii/fedaco-sqlserver-driver tedious

Configure Connection

import { DatabaseConfig } from '@gradii/fedaco';
import { sqlserverDriver } from '@gradii/fedaco-sqlserver-driver';

const db = new DatabaseConfig();

db.addConnection({
  driver: 'sqlserver',
  factory: sqlserverDriver(),
  host: '127.0.0.1',
  port: 1433,
  database: 'app',
  username: 'sa',
  password: 'StrongPassword123!',
});

db.bootFedaco();
db.setAsGlobal();

Connection URL Style

db.addConnection({
  driver: 'sqlserver',
  factory: sqlserverDriver(),
  url: 'sqlserver://sa:StrongPassword123!@127.0.0.1:1433/app',
});

Optional Pool

db.addConnection({
  driver: 'sqlserver',
  factory: sqlserverDriver(),
  host: '127.0.0.1',
  port: 1433,
  database: 'app',
  username: 'sa',
  password: 'StrongPassword123!',
  pool: { min: 2, max: 10 },
});