Пример #1
0
        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));
                }
            }
        }
Пример #2
0
        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());
                }
            }
        }
Пример #3
0
        public static string GetTableCount(DatabaseInfo.SQLServerVersion version, DatabaseInfo.SQLServerEdition edition)
        {
            switch (version)
            {
            case DatabaseInfo.SQLServerVersion.SQLServer2000:
                return(GetTableCount2000());

            default:
                return(GetTableCount2005());
            }
        }
Пример #4
0
        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());
                }
            }
        }