public string SqlStatement() { string result = DatabaseTriggers.SqlStatement(); return(result); // TODO: add assertions to method DatabaseTriggersTest.SqlStatement() }
public DatabaseTriggers Constructor( string triggerName, string triggerOwner, string tableSchema, string tableName, int update, int delete, int insert, int after, int insteadOf, int disabled ) { DatabaseTriggers target = new DatabaseTriggers (triggerName, triggerOwner, tableSchema, tableName, update, delete, insert, after, insteadOf, disabled); return(target); // TODO: add assertions to method DatabaseTriggersTest.Constructor(String, String, String, String, Int32, Int32, Int32, Int32, Int32, Int32) }
/// <summary> /// Gets the database triggers. /// </summary> /// <param name="database">The database.</param> /// <returns>the database triggers</returns> public List <DatabaseTriggers> GetDatabaseTriggers(string database) { this.ExecuteUseDatabase(database); List <DatabaseTriggers> results = new List <DatabaseTriggers>(); DatabaseTriggers resultrow; string sqlString = DatabaseTriggers.SqlStatement(); sqlString = string.Format("EXEC sp_executesql @statement = N'{0}'", sqlString.Replace("'", "''")); using (SqlConnection connection = new SqlConnection(this.ConnectionString)) using (SqlCommand command = new SqlCommand(sqlString, connection)) { connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { resultrow = new DatabaseTriggers( reader.GetString(reader.GetOrdinal("TriggerName")), reader.GetString(reader.GetOrdinal("TriggerOwner")), reader.GetString(reader.GetOrdinal("TableSchema")), reader.GetString(reader.GetOrdinal("TableName")), reader.GetInt32(reader.GetOrdinal("IsUpdate")), reader.GetInt32(reader.GetOrdinal("IsDelete")), reader.GetInt32(reader.GetOrdinal("IsInsert")), reader.GetInt32(reader.GetOrdinal("IsAfter")), reader.GetInt32(reader.GetOrdinal("IsInsteadOf")), reader.GetInt32(reader.GetOrdinal("Disabled"))); results.Add(resultrow); } } connection.Close(); } return(results); }