private static string CreateTableRowCountUnionSql(IDbConnection db, string schema)
{
var sb = StringBuilderCache.Allocate();
var dialect = db.GetDialectProvider();
var tableNames = GetTableNames(db, schema);
var schemaName = dialect.NamingStrategy.GetSchemaName(schema);
foreach (var tableName in tableNames)
{
if (sb.Length > 0)
{
sb.Append(" UNION ");
}
// retain *real* table names and skip using naming strategy
sb.AppendLine($"SELECT {OrmLiteUtils.QuotedLiteral(tableName)}, COUNT(*) FROM {dialect.GetQuotedTableName(tableName, schemaName, useStrategy:false)}");
}
var sql = StringBuilderCache.ReturnAndFree(sb);
return(sql);
}
