public override bool Exists(System.Data.IDbConnection connection) { return 0 < connection.ExecuteScalarSql<int>(String.Format(@" SELECT COUNT (*) FROM sys.symmetric_keys WHERE name = '{0}'", Name.Object)); }
public override bool Exists(System.Data.IDbConnection connection) { return 0 < connection.ExecuteScalarSql<int>(String.Format(@" SELECT COUNT (*) FROM sys.views v JOIN sys.schemas s ON (v.schema_id = s.schema_id) WHERE s.name = '{0}' AND v.name = '{1}'", Name.Schema, Name.Table)); }
public override bool Exists(System.Data.IDbConnection connection) { return 0 < connection.ExecuteScalarSql<int>(String.Format(@" SELECT COUNT (*) FROM sys.triggers t JOIN sys.objects o ON (t.object_id = o.object_id) JOIN sys.schemas s ON (o.schema_id = s.schema_id) WHERE s.name = '{0}' AND t.name = '{1}'", Name.Schema, Name.Table)); }