How to use MS SQL without ORM in NestJS?

Question

Node.js

Hello.
There was a need to use NestJS. In the documentation for the framework, ORM is used everywhere to work with the DBMS, but this does not suit me, because. it is necessary to use an existing database with access to data organized through stored procedures and functions.
I can’t find anywhere how to use just the mssql nmp module, otherwise, as I described it myself, unfortunately, it doesn’t want to work.
I tried to make a DatabaseModule module that uses the provider, but when using this provider in other modules, the error "ConnectionError: Connection is closed."
The project code is here https://github.com/zakharoffam/sia .
Tell me how to make such a provider so that it works from other modules?

Answer 1

Node.js Driver for SQL Server .