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);
}
