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));
		}
Esempio n. 2
0
		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));
		}