0.1.16 • Published 7 years ago
most-data-mssql v0.1.16
most-data-mssql
Most Web Framework MSSQL Adapter
Install
$ npm install most-data-mssql
Usage
Register MSSQL adapter on app.json as follows:
"adapterTypes": [
...
{ "name":"MSSQL Data Adapter", "invariantName": "mssql", "type":"most-data-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.
Connect to Azure SQL Databases
If you are going to use adapter against Azure SQL databases you must always enable encrypt option in your connection settings:
adapters: [
...
{ "name":"development", "invariantName":"mssql", "default":true,
"options": {
"server":"localhost",
"user":"user",
"password":"password",
"database":"test",
"options": {
"encrypt": true
}
}
}
...
]