title: How to call stored procedure in Mssql using loopback 4?
body: <p>How to call stored procedure in Mssql using loopback 4 typescript</p>
  
  <p>How do i make query in datasource like calling stored procedure </p>
  
  <pre><code>import { DataSourceConstructor} from '@loopback/repository';
  
  export const db = new DataSourceConstructor({
    connector: 'mssql',
    host: '192.168.1.110',
    port: 1433,
    database: 'FastDryNew',
    password: 'sa$123',
    user: 'sa',
  });
  </code></pre>
  
  <p>currently i'm using Default Crud Repository with simple where condition</p>
  
  <pre><code>  @get('/Job/{CustomerID}')
    @param.path.number('CustomerID')
    async findJobByCustomerID(CustomerID: number): Promise&lt;Jobs[]&gt; {
      return await this.JobsRepo.find({ where: { CustomerID: CustomerID } });
    }
  </code></pre>
  
  <p>Thanks in advance.</p>