Ejemplo n.º 1
0
        public virtual void Write(IndexDefinition index)
        {
            _index = index;

            if (Index.IsRedefinedFor(Engine))
            {
                Builder.AppendLine(index.GetDefinition(Engine));
                return;
            }

            index.Options.Use(Engine);

            Builder.Append("CREATE");

            WriteIndexType();

            Builder.AppendFormat(" INDEX ");
            WriteIndexName();
            Builder.Append(" ON ");
            WriteTableName();
            Builder.Append(" (");
            foreach (var idx in index.Columns)
            {
                WriteColumn(idx);
                Builder.Append(",");
            }
            Builder.RemoveLast();
            Builder.Append(")");
            WriteEndOptions();
        }
Ejemplo n.º 2
0
 public IndexWriterTests()
 {
     _sb = new StringBuilder();
     _idx = new IndexDefinition("table");
     _idx.Name = "ix_bla";
     _idx.Columns.AddColumns("name");
     _iw = new SqlServerIndexWriter(_sb);
 }