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(); }
public IndexWriterTests() { _sb = new StringBuilder(); _idx = new IndexDefinition("table"); _idx.Name = "ix_bla"; _idx.Columns.AddColumns("name"); _iw = new SqlServerIndexWriter(_sb); }