public override SQLScriptList ToSqlDiff()
{
SQLScriptList list = new SQLScriptList();
if (Status != Enums.ObjectStatusType.OriginalStatus)
{
RootParent.ActionMessage[Parent.FullName].Add(this);
}
if (HasState(Enums.ObjectStatusType.DropStatus))
{
list.Add(Drop());
}
if (HasState(Enums.ObjectStatusType.CreateStatus))
{
list.Add(Create());
}
if (HasState(Enums.ObjectStatusType.AlterStatus))
{
list.Add(Drop());
list.Add(Create());
}
if (Status == Enums.ObjectStatusType.DisabledStatus)
{
list.Add(ToSqlEnabled(), Parent.DependenciesCount, Enums.ScripActionType.AlterIndex);
}
/*if (this.Status == StatusEnum.ObjectStatusType.ChangeFileGroup)
* {
* listDiff.Add(this.ToSQLDrop(this.FileGroup), ((Table)Parent).DependenciesCount, StatusEnum.ScripActionType.DropIndex);
* listDiff.Add(this.ToSQLAdd(), ((Table)Parent).DependenciesCount, StatusEnum.ScripActionType.AddIndex);
* }*/
list.AddRange(ExtendedProperties.ToSqlDiff());
return(list);
}
public override SQLScriptList ToSqlDiff(System.Collections.Generic.ICollection <ISchemaBase> schemas)
{
SQLScriptList list = new SQLScriptList();
if (Status != ObjectStatus.Original)
{
var actionMessage = RootParent.ActionMessage[Parent.FullName];
if (actionMessage != null)
{
actionMessage.Add(this);
}
}
if (HasState(ObjectStatus.Drop))
{
list.Add(Drop());
}
if (HasState(ObjectStatus.Create))
{
list.Add(Create());
}
if (HasState(ObjectStatus.Alter))
{
list.Add(Drop());
list.Add(Create());
}
if (Status == ObjectStatus.Disabled)
{
list.Add(ToSqlEnabled(), Parent.DependenciesCount, ScriptAction.AlterIndex);
}
/*if (this.Status == StatusEnum.ObjectStatusType.ChangeFileGroup)
* {
* listDiff.Add(this.ToSQLDrop(this.FileGroup), ((Table)Parent).DependenciesCount, StatusEnum.ScripActionType.DropIndex);
* listDiff.Add(this.ToSQLAdd(), ((Table)Parent).DependenciesCount, StatusEnum.ScripActionType.AddIndex);
* }*/
list.AddRange(ExtendedProperties.ToSqlDiff());
return(list);
}