title: How to create index in desc order in code first?
body: <p>Want to create index by <code>EmployeeCardNumber</code> (text) in descending order.</p>
  
  <p>So the sql script should be like:</p>
  
  <pre><code>ALTER TABLE dbo.Employees ADD CONSTRAINT
  IX_Employees_EmplyeeCardNumber UNIQUE CLUSTERED 
  (
      EmployeeCardNumber DESC
  )
  </code></pre>
  
  <p>In <code>IndexAttribute</code>, there is an <code>Order</code> property, which is an integer???</p>
  
  <p>Here is my fluent api:</p>
  
  <pre><code>        var indexAttr = new IndexAttribute("IX_Employees_EmplyeeCardNumber")
          {
              IsClustered = true,
              IsUnique = true,
              Order = 1 // probably should be removed since we are using a composite key.
          };
  
          Property(c =&gt; c.EmployeeCardNumber)
              .HasColumnAnnotation("Index", new IndexAnnotation(indexAttr))
              .HasMaxLength(8)
              .IsRequired();
  </code></pre>
  
  <p>So the question is, how to define "DESC" in this code first approach?</p>