class kysely.MssqlDialect
implements Dialect
import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.3/mod.ts";
const { MssqlDialect } = kysely;
MS SQL Server dialect that uses the tedious library.
The constructor takes an instance of MssqlDialectConfig.
import * as Tedious from 'tedious'
import * as Tarn from 'tarn'
const dialect = new MssqlDialect({
tarn: {
...Tarn,
options: {
min: 0,
max: 10,
},
},
tedious: {
...Tedious,
connectionFactory: () => new Tedious.Connection({
authentication: {
options: {
password: 'password',
userName: 'username',
},
type: 'default',
},
options: {
database: 'some_db',
port: 1433,
trustServerCertificate: true,
},
server: 'localhost',
}),
},
})
Constructors
new
MssqlDialect(config: MssqlDialectConfig)Methods
createIntrospector(db: Kysely<any>): DatabaseIntrospector
Creates a database introspector that can be used to get database metadata such as the table names and column names of those tables.
db
never has any plugins installed. It's created using
{@link Kysely.withoutPlugins}.