C# ISchemaBase类代码示例

        public static string FormatAlter(string ObjectType, string body, ISchemaBase item, Boolean quitSchemaBinding)
        {
            string prevText = null;
            try
            {
                prevText = (string)body.Clone();
                SearchItem sitem = FindCreate(ObjectType, item, prevText);
                Regex regAlter = new Regex("CREATE");

                if (!quitSchemaBinding)
                    return regAlter.Replace(sitem.Body, "ALTER", 1, sitem.FindPosition);
                    //return prevText.Substring(0, iFind) + "ALTER " + sitem.ObjectType + " " + prevText.Substring(iFind + sitem.ObjectType.Length + 7, prevText.Length - (iFind + sitem.ObjectType.Length + 7)).TrimStart();
                else
                {
                    string text = regAlter.Replace(sitem.Body, "ALTER", 1, sitem.FindPosition);
                    Regex regex = new Regex("WITH SCHEMABINDING", RegexOptions.IgnoreCase);
                    return regex.Replace(text, "");
                }
                //return "";
            }
            catch
            {
                return prevText;
            }
        }

 public CLRFunction(ISchemaBase parent)
     : base(parent, Enums.ObjectType.CLRFunction, Enums.ScripActionType.AddFunction, Enums.ScripActionType.DropFunction)
 {
     parameters = new List<Parameter>();
     returnType = new Parameter();
     isAggrFunc = false;
 }

 public override ISchemaBase Clone(ISchemaBase parent)
 {
     Index index = new Index(parent)
                       {
                           AllowPageLocks = this.AllowPageLocks,
                           AllowRowLocks = this.AllowRowLocks,
                           Columns = this.Columns.Clone(),
                           FillFactor = this.FillFactor,
                           FileGroup = this.FileGroup,
                           Id = this.Id,
                           IgnoreDupKey = this.IgnoreDupKey,
                           IsAutoStatistics = this.IsAutoStatistics,
                           IsDisabled = this.IsDisabled,
                           IsPadded = this.IsPadded,
                           IsPrimaryKey = this.IsPrimaryKey,
                           IsUniqueKey = this.IsUniqueKey,
                           Name = this.Name,
                           SortInTempDb = this.SortInTempDb,
                           Status = this.Status,
                           Type = this.Type,
                           Owner = this.Owner,
                           FilterDefintion = this.FilterDefintion
                       };
     ExtendedProperties.ForEach(item => index.ExtendedProperties.Add(item));
     return index;
 }

 public AssemblyFile(ISchemaBase parent, AssemblyFile assemblyFile, Enums.ObjectStatusType status)
     : base(parent, Enums.ObjectType.AssemblyFile)
 {
     this.Name = assemblyFile.Name;
     this.content = assemblyFile.content;
     this.Status = status;
 }

 public View(ISchemaBase parent)
     : base(parent, Enums.ObjectType.View, Enums.ScripActionType.AddView, Enums.ScripActionType.DropView)
 {
     Indexes = new SchemaList<Index, View>(this, ((Database)parent).AllObjects);
     Triggers = new SchemaList<Trigger, View>(this, ((Database)parent).AllObjects);
     CLRTriggers = new SchemaList<CLRTrigger, View>(this, ((Database)parent).AllObjects);
 }

 public UserDataType(ISchemaBase parent)
     : base(parent, Enums.ObjectType.UserDataType)
 {
     Default = new Default(this);
     Rule = new Rule(this);
     Dependencys = new List<ObjectDependency>();
 }

 /// <summary>
 /// Clona el objeto en una nueva instancia.
 /// </summary>
 public override ISchemaBase Clone(ISchemaBase parent)
 {
     TableOption option = new TableOption(parent);
     option.Name = this.Name;
     option.Status = this.Status;
     option.Value = this.Value;
     return option;
 }

 public new Default Clone(ISchemaBase parent)
 {
     Default item = new Default(parent);
     item.Id = this.Id;
     item.Name = this.Name;
     item.Owner = this.Owner;
     item.Value = this.Value;
     return item;
 }

 public override ISchemaBase Clone(ISchemaBase parent)
 {
     Synonym item = new Synonym(parent);
     item.Id = this.Id;
     item.Name = this.Name;
     item.Owner = this.Owner;
     item.Value = this.Value;
     item.Guid = this.Guid;
     return item;
 }

 public Rule Clone(ISchemaBase parent)
 {
     Rule item = new Rule(parent);
     item.Id = this.Id;
     item.Name = this.Name;
     item.Owner = this.Owner;
     item.Text = this.Text;
     item.Guid = this.Guid;
     return item;
 }

 public SqlAction(ISchemaBase item)
 {
     if ((item.ObjectType == Enums.ObjectType.Column) || (item.ObjectType == Enums.ObjectType.Index) || (item.ObjectType == Enums.ObjectType.Constraint))
         this.name = item.Name;
     else
         this.name = item.FullName;
     this.action = item.Status;
     this.type = item.ObjectType;
     childs = new List<SqlAction>();
 }

 /// <summary>
 /// Clona el objeto en una nueva instancia.
 /// </summary>
 public override ISchemaBase Clone(ISchemaBase parent)
 {
     StoreProcedure item = new StoreProcedure(parent);
     item.Text = this.Text;
     item.Status = this.Status;
     item.Name = this.Name;
     item.Id = this.Id;
     item.Owner = this.Owner;
     item.Guid = this.Guid;
     return item;
 }

 public override ISchemaBase Clone(ISchemaBase parent)
 {
     FileGroup file = new FileGroup(parent);
     file.IsDefaultFileGroup = this.IsDefaultFileGroup;
     file.IsReadOnly = this.IsReadOnly;
     file.Name = this.Name;
     file.Id = this.Id;
     file.Files = this.Files.Clone(file);
     file.Guid = this.Guid;
     file.IsFileStream = this.IsFileStream;
     return file;
 }

 /// <summary>
 /// Clona el objeto en una nueva instancia.
 /// </summary>
 public new XMLSchema Clone(ISchemaBase parent)
 {
     XMLSchema item = new XMLSchema(parent);
     item.Text = this.Text;
     item.Status = this.Status;
     item.Name = this.Name;
     item.Id = this.Id;
     item.Owner = this.Owner;
     item.Guid = this.Guid;
     item.Dependencys = this.Dependencys;
     return item;
 }

 public new PartitionFunction Clone(ISchemaBase parent)
 {
     PartitionFunction item = new PartitionFunction(parent);
     item.Id = this.Id;
     item.IsBoundaryRight = this.IsBoundaryRight;
     item.Name = this.Name;
     item.Precision = this.Precision;
     item.Scale = this.Scale;
     item.Size = this.Size;
     item.Type = this.Type;
     this.Values.ForEach(value => { item.Values.Add(value); });
     return item;
 }