internal static string CreateCountDatabasesBasedOnFileNameScript(string databaseFileName, bool useDeprecatedSystemTable)
{
var builder = new SqlDdlBuilder();
builder.AppendSql("SELECT Count(*) FROM ");
if (useDeprecatedSystemTable)
{
builder.AppendSql("sysdatabases");
}
if (!useDeprecatedSystemTable)
{
builder.AppendSql("sys.master_files");
}
builder.AppendSql(" WHERE [");
if (useDeprecatedSystemTable)
{
builder.AppendSql("filename");
}
else
{
builder.AppendSql("physical_name");
}
builder.AppendSql("]=");
builder.AppendStringLiteral(databaseFileName);
return(builder.unencodedStringBuilder.ToString());
}
internal static string CreateDatabaseExistsScript(string databaseName, bool useDeprecatedSystemTable)
{
var builder = new SqlDdlBuilder();
builder.AppendSql("SELECT Count(*) FROM ");
AppendSysDatabases(builder, useDeprecatedSystemTable);
builder.AppendSql(" WHERE [name]=");
builder.AppendStringLiteral(databaseName);
return(builder.unencodedStringBuilder.ToString());
}
internal static string CreateGetDatabaseNamesBasedOnFileNameScript(string databaseFileName, bool useDeprecatedSystemTable)
{
var builder = new SqlDdlBuilder();
builder.AppendSql("SELECT [d].[name] FROM ");
AppendSysDatabases(builder, useDeprecatedSystemTable);
builder.AppendSql(" AS [d] ");
if (!useDeprecatedSystemTable)
{
builder.AppendSql("INNER JOIN sys.master_files AS [f] ON [f].[database_id] = [d].[database_id]");
}
builder.AppendSql(" WHERE [");
if (useDeprecatedSystemTable)
{
builder.AppendSql("filename");
}
else
{
builder.AppendSql("f].[physical_name");
}
builder.AppendSql("]=");
builder.AppendStringLiteral(databaseFileName);
return(builder.unencodedStringBuilder.ToString());
}