public static string GetTableDetail(DatabaseInfo.SQLServerVersion version, DatabaseInfo.SQLServerEdition edition)
{
switch (version)
{
case DatabaseInfo.SQLServerVersion.SQLServer2000:
return(GetTableDetail2000());
case DatabaseInfo.SQLServerVersion.SQLServer2005:
return(GetTableDetail2005());
case DatabaseInfo.SQLServerVersion.SQLServer2008:
case DatabaseInfo.SQLServerVersion.SQLServer2008R2:
return(GetTableDetail2008());
case DatabaseInfo.SQLServerVersion.SQLServerAzure10:
return(GetTableDetailAzure());
default:
if (edition == DatabaseInfo.SQLServerEdition.Azure)
{
return(GetTableDetailAzure());
}
else
{
return(GetTableDetail2008());
}
}
}
public static string Get(DatabaseInfo.SQLServerVersion version, DatabaseInfo.SQLServerEdition edition, Database databaseSchema)
{
switch (version)
{
case DatabaseInfo.SQLServerVersion.SQLServer2005:
return(Get2005(databaseSchema));
case DatabaseInfo.SQLServerVersion.SQLServer2008:
return(Get2008(databaseSchema));
case DatabaseInfo.SQLServerVersion.SQLServer2008R2:
return(Get2008R2(databaseSchema));
case DatabaseInfo.SQLServerVersion.SQLServerAzure10:
return(GetAzure(databaseSchema));
default:
if (edition == DatabaseInfo.SQLServerEdition.Azure)
{
return(GetAzure(databaseSchema));
}
else
{
return(Get2008R2(databaseSchema));
}
}
}
public static string GetCheck(DatabaseInfo.SQLServerVersion version)
{
if (version == DatabaseInfo.SQLServerVersion.SQLServer2005)
{
return(GetCheck2005());
}
//Fall back to highest compatible version
return(GetCheck2008());
}
public static string Get(DatabaseInfo.SQLServerVersion version)
{
switch (version)
{
case DatabaseInfo.SQLServerVersion.SQLServer2005:
return(Get2005());
default:
return(Get2008());
}
}
public static string GetTableCount(DatabaseInfo.SQLServerVersion version, DatabaseInfo.SQLServerEdition edition)
{
switch (version)
{
case DatabaseInfo.SQLServerVersion.SQLServer2000:
return(GetTableCount2000());
default:
return(GetTableCount2005());
}
}
private static string GetSQL(DatabaseInfo.SQLServerVersion version)
{
if (version == DatabaseInfo.SQLServerVersion.SQLServerAzure10)
{
return(SQLQueries.SQLQueryFactory.Get("GetProcedures", DatabaseInfo.SQLServerVersion.SQLServerAzure10));
}
else
{
return(SQLQueries.SQLQueryFactory.Get("GetProcedures"));
}
}
private static string GetSQL(DatabaseInfo.SQLServerVersion version, SqlOption options)
{
if (version == DatabaseInfo.SQLServerVersion.SQLServerAzure10)
{
return(SQLQueries.SQLQueryFactory.Get("GetTriggers", version));
}
else
{
return(SQLQueries.SQLQueryFactory.Get("GetTriggers"));
}
}
public static string GetPrimaryKey(DatabaseInfo.SQLServerVersion version, Table table)
{
switch (version)
{
case DatabaseInfo.SQLServerVersion.SQLServer2000:
return(GetPrimaryKey2000(table));
case DatabaseInfo.SQLServerVersion.SQLServer2005:
return(GetPrimaryKey2005());
case DatabaseInfo.SQLServerVersion.SQLServerAzure10:
return(GetPrimaryKeyAzure());
default:
return(GetPrimaryKey2008());
}
}
public static string GetUniqueKey(DatabaseInfo.SQLServerVersion version, DatabaseInfo.SQLServerEdition edition)
{
switch (version)
{
case DatabaseInfo.SQLServerVersion.SQLServer2005:
return(GetUniqueKey2005());
case DatabaseInfo.SQLServerVersion.SQLServerAzure10:
return(GetUniqueKeyAzure());
default:
if (edition == DatabaseInfo.SQLServerEdition.Azure)
{
return(GetUniqueKeyAzure());
}
else
{
return(GetUniqueKey2008());
}
}
}
