public static string GetKeys(this SqlProductInfo productInfo)
{
if (productInfo.IsSql2005OrNewer)
{
return(Constants.SQL_GetKeys2005);
}
return(Constants.SQL_GetKeys);
}
public static string GetExtendedData(this SqlProductInfo productInfo)
{
if (productInfo.IsSql2005OrNewer)
{
return(Constants.SQL_GetExtendedData2005);
}
return(Constants.SQL_GetExtenedData);
}
public static string GetColumnConstraintsWhere(this SqlProductInfo productInfo)
{
if (productInfo.IsSql2005OrNewer)
{
return(" WHERE SCHEMA_NAME([t].[schema_id]) = @SchemaName AND [t].[name] = @TableName AND [c].[name] = @ColumnName");
}
return(" AND [stbl].[name] = @SchemaName AND [tbl].[name] = @TableName AND [clmns].[name] = @ColumnName");
}
public static string GetAllTableColumns(this SqlProductInfo productInfo)
{
if (productInfo.IsSql2005OrNewer)
{
return(Constants.SQL_GetAllTableColumns2005);
}
return(Constants.SQL_GetAllTableColumns);
}
public static string GetAllCommandParameters(this SqlProductInfo productInfo)
{
if (productInfo.IsSql2005OrNewer)
{
return(Constants.SQL_GetAllCommandParameters2005);
}
return(Constants.SQL_GetAllCommandParameters);
}
public static string GetIndexes(this SqlProductInfo productInfo)
{
if (productInfo.IsSqlAzure)
{
return(Constants.SQL_GetIndexesAzure);
}
if (productInfo.IsSql2005OrNewer)
{
return(Constants.SQL_GetIndexes2005);
}
return(Constants.SQL_GetIndexes);
}
public static string GetExtendedProperties(this SqlProductInfo productInfo)
{
return(Constants.SQL_GetExtendedProperties);
}