@themost/mssql

Most Web Framework MSSQL Adapter

Install

npm install @themost/mssql

Usage

Register MSSQL adapter on app.json as follows:

"adapterTypes": [
    ...
    { "name":"MSSQL Data Adapter", "invariantName": "mssql", "type":"@themost/mssql" }
    ...
],
adapters: [
    ...
    { "name":"development", "invariantName":"mssql", "default":true,
        "options": {
          "server":"localhost",
          "user":"user",
          "password":"password",
          "database":"test"
        }
    }
    ...
]

If you are intended to use MSSQL data adapter as the default database adapter set the property "default" to true.

Transaction Isolation Level

Transaction isolation level controls the locking and row versioning behavior of Transact-SQL statements issued by a connection to SQL Server.

SET TRANSACTION ISOLATION LEVEL
    { READ UNCOMMITTED
    | READ COMMITTED
    | REPEATABLE READ
    | SNAPSHOT
    | SERIALIZABLE
    }

https://learn.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql?view=sql-server-ver16

Use options/transactionIsolationLevel and define transaction isolation level:

{
    "name":"development",
    "invariantName":"mssql",
    "default":true,
    "options": {
        "server":"localhost",
        "user":"user",
        "password":"password",
        "database":"test",
        "options": {
            "transactionIsolationLevel": "readCommitted"
        }
    }
}

The possible values are readUncommitted | readCommitted | repeatableRead | snapshot | serializable

Development

themost-mssql is a sub-module of Most Web Framework data adapters project

So, checkout parent project

git checkout (https://github.com/themost-framework/themost-adapters.git