Editing Dapper

<strong>Example:</strong>
<pre>var dbConn = dbContext.Database.GetDbConnection();
if (dbConn.State != ConnectionState.Open)
{
  await dbConn.OpenAsync();
}
return await dbConn.QueryAsync<FooDTO>(@"
  SELECT
    f.foo_id AS FooId,
    f.name AS Name
  FROM dbo.Foo f
  WHERE f.foo_id = @fooId
  ",
  new
  {
    fooId,
  });</pre>
<strong>Do not hard code</strong> the database name. In the service class that extends BaseService, you can call GetDatabase("id") to get the tenant database.
<strong>Stored procedure example:</strong>
return await dbConn.QuerySingleAsync<ShlSequenceDTO>(
  "usp_GetSequence",
  new
  {
    seed,
  },
  commandType: CommandType.StoredProcedure
  );