public static void DropLinkView(DbConnection connection, ContentToContentDAL item)
{
var dbType = GetDbType(connection);
var spName = dbType == DatabaseType.SqlServer ? "qp_drop_link_view" : "qp_link_view_drop";
var sql = SqlQuerySyntaxHelper.SpCall(dbType, spName, item.LinkId.ToString(CultureInfo.InvariantCulture));
ExecuteSql(connection, sql);
}
public static void DropLinkTables(DbConnection connection, ContentToContentDAL item)
{
var dbType = GetDbType(connection);
var tableName = $@"{DbSchemaName(dbType)}.item_link_{item.LinkId}";
var revTableName = $@"{DbSchemaName(dbType)}.item_link_{item.LinkId}_rev";
var asyncTableName = $@"{DbSchemaName(dbType)}.item_link_{item.LinkId}_async";
var asyncRevTableName = $@"{DbSchemaName(dbType)}.item_link_{item.LinkId}_async_rev";
var sql = $@"DROP TABLE {{0}}";
ExecuteSql(connection, String.Format(sql, tableName));
ExecuteSql(connection, String.Format(sql, revTableName));
ExecuteSql(connection, String.Format(sql, asyncTableName));
ExecuteSql(connection, String.Format(sql, asyncRevTableName));
}
public static void CreateLinkTables(DbConnection connection, ContentToContentDAL item)
{
var dbType = GetDbType(connection);
var tableName = $@"{DbSchemaName(dbType)}.item_link_{item.LinkId}";
var revTableName = $@"{DbSchemaName(dbType)}.item_link_{item.LinkId}_rev";
var asyncTableName = $@"{DbSchemaName(dbType)}.item_link_{item.LinkId}_async";
var asyncRevTableName = $@"{DbSchemaName(dbType)}.item_link_{item.LinkId}_async_rev";
var sql = $@"CREATE TABLE {{0}} (id int NOT NULL, linked_id int NOT NULL, PRIMARY KEY (id, linked_id))";
ExecuteSql(connection, String.Format(sql, tableName));
ExecuteSql(connection, String.Format(sql, revTableName));
ExecuteSql(connection, String.Format(sql, asyncTableName));
ExecuteSql(connection, String.Format(sql, asyncRevTableName));
}
