internal static DatabaseInfo.VersionNumber GetVersionNumber(SqlConnection connection)
{
//Default to 2000
DatabaseInfo.VersionNumber version = DatabaseInfo.VersionNumber.SQLServer2000;
if (connection.State == System.Data.ConnectionState.Open)
{
string[] versionNumbers = connection.ServerVersion.Split('.');
version = (DatabaseInfo.VersionNumber)Convert.ToInt32(versionNumbers[0]);
}
return(version);
}
public static string Get(DatabaseInfo.VersionNumber version)
{
if (version == DatabaseInfo.VersionNumber.SQLServer2000)
{
return(Get2000());
}
if (version == DatabaseInfo.VersionNumber.SQLServer2005)
{
return(Get2005());
}
if (version == DatabaseInfo.VersionNumber.SQLServer2008)
{
return(Get2008());
}
return("");
}
public static string GetFilesInFileGroup(DatabaseInfo.VersionNumber version, FileGroup filegroup)
{
if (version == DatabaseInfo.VersionNumber.SQLServer2000)
{
return(GetFilesInFileGroup2000(filegroup));
}
if (version == DatabaseInfo.VersionNumber.SQLServer2005)
{
return(GetFilesInFileGroup2005(filegroup));
}
if (version == DatabaseInfo.VersionNumber.SQLServer2008)
{
return(GetFilesInFileGroup2008(filegroup));
}
return("");
}
public static string GetPrimaryKey(DatabaseInfo.VersionNumber version, Table table)
{
if (version == DatabaseInfo.VersionNumber.SQLServer2000)
{
return(GetPrimaryKey2000(/*table*/));
}
if (version == DatabaseInfo.VersionNumber.SQLServer2005)
{
return(GetPrimaryKey2005());
}
if (version == DatabaseInfo.VersionNumber.SQLServer2008)
{
return(GetPrimaryKey2008());
}
return("");
}
public static string GetDatabaseProperties(DatabaseInfo.VersionNumber version, Database databaseSchema)
{
switch (version)
{
case DatabaseInfo.VersionNumber.SQLServer2000:
case DatabaseInfo.VersionNumber.SQLServer2005:
case DatabaseInfo.VersionNumber.SQLServer2008:
return(string.Format("SELECT DATABASEPROPERTYEX('{0}','IsFulltextEnabled') AS IsFullTextEnabled, DATABASEPROPERTYEX('{0}','Collation') AS Collation, cmptlevel AS CompatibilityLevel from master..sysdatabases where name='{0}'", databaseSchema.Name));
break;
default:
return(string.Empty);
break;
}
}
public static string GetDatabases(DatabaseInfo.VersionNumber version)
{
switch (version)
{
case DatabaseInfo.VersionNumber.SQLServer2000:
return("SELECT name, dbid,cmptlevel FROM master.dbo.sysdatabases ORDER BY Name");
break;
case DatabaseInfo.VersionNumber.SQLServer2005:
case DatabaseInfo.VersionNumber.SQLServer2008:
return("SELECT name, database_id,compatibility_level FROM sys.databases ORDER BY Name");
break;
default:
return(string.Empty);
}
}
private static void FillColumnsDependencies(DatabaseInfo.VersionNumber DatabaseVersion, SchemaList <UserDataType, Database> types, string connectionString)
{
if (types == null)
{
throw new ArgumentNullException("types");
}
using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand((DatabaseVersion == DatabaseInfo.VersionNumber.SQLServer2000?GetSQLColumnsDependencis2000(): GetSQLColumnsDependencis()), conn))
{
conn.Open();
command.CommandTimeout = 0;
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
types[reader["TypeName"].ToString()].Dependencys.Add(new ObjectDependency(reader["TableName"].ToString(), reader["ColumnName"].ToString(), ConvertType.GetObjectType(reader["Type"].ToString())));
}
}
}
}
}
