public Schema() { Tables = new SchemaTablesCollection(this); Triggers = new SchemaTriggersCollection(this); Views = new SchemaViewsCollection(this); Routines = new SchemaRoutinesCollection(this); }
/// <summary> /// Convierte los desencadenadores /// </summary> private StructDocumentationModelCollection ConvertTriggers(StructDocumentationModel objParent, SchemaTriggersCollection objColTriggers) { StructDocumentationModelCollection objColStructs = new StructDocumentationModelCollection(); // Añade los desencadenadores foreach (SchemaTrigger objTrigger in objColTriggers) { StructDocumentationModel objStruct = CreateStruct(objParent, objTrigger, "Trigger"); // Añade los parámetros de la tabla objStruct.Parameters.Add("Table", objTrigger.Table); objStruct.Parameters.Add("UserName", objTrigger.UserName); objStruct.Parameters.Add("Category", objTrigger.Category); objStruct.Parameters.Add("IsExecuted", objTrigger.IsExecuted); objStruct.Parameters.Add("IsExecutionAnsiNullsOn", objTrigger.IsExecutionAnsiNullsOn); objStruct.Parameters.Add("IsExecutionQuotedIdentOn", objTrigger.IsExecutionQuotedIdentOn); objStruct.Parameters.Add("IsAnsiNullsOn", objTrigger.IsAnsiNullsOn); objStruct.Parameters.Add("IsQuotedIdentOn", objTrigger.IsQuotedIdentOn); objStruct.Parameters.Add("IsExecutionAfterTrigger", objTrigger.IsExecutionAfterTrigger); objStruct.Parameters.Add("IsExecutionDeleteTrigger", objTrigger.IsExecutionDeleteTrigger); objStruct.Parameters.Add("IsExecutionFirstDeleteTrigger", objTrigger.IsExecutionFirstDeleteTrigger); objStruct.Parameters.Add("IsExecutionFirstInsertTrigger", objTrigger.IsExecutionFirstInsertTrigger); objStruct.Parameters.Add("IsExecutionFirstUpdateTrigger", objTrigger.IsExecutionFirstUpdateTrigger); objStruct.Parameters.Add("IsExecutionInsertTrigger", objTrigger.IsExecutionInsertTrigger); objStruct.Parameters.Add("IsExecutionInsteadOfTrigger", objTrigger.IsExecutionInsteadOfTrigger); objStruct.Parameters.Add("IsExecutionLastDeleteTrigger", objTrigger.IsExecutionLastDeleteTrigger); objStruct.Parameters.Add("IsExecutionLastInsertTrigger", objTrigger.IsExecutionLastInsertTrigger); objStruct.Parameters.Add("IsExecutionLastUpdateTrigger", objTrigger.IsExecutionLastUpdateTrigger); objStruct.Parameters.Add("IsExecutionTriggerDisabled", objTrigger.IsExecutionTriggerDisabled); objStruct.Parameters.Add("IsExecutionUpdateTrigger", objTrigger.IsExecutionUpdateTrigger); objStruct.Parameters.Add("DateCreate", objTrigger.DateCreate); objStruct.Parameters.Add("DateReference", objTrigger.DateReference); objStruct.Parameters.Add("Prototype", objTrigger.Content); // Añade la estructura objColStructs.Add(objStruct); } // Devuelve la colección de estructuras return(objColStructs); }