Dapper

Example:

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,
  });

Do not hard code the database name. In the service class that extends BaseService, you can call GetDatabase("id") to get the tenant database. Stored procedure example: return await dbConn.QuerySingleAsync<ShlSequenceDTO>(

 "usp_GetSequence",
 new
 {
   seed,
 },
 commandType: CommandType.StoredProcedure
 );