Geek asks and answers

Sort columns by name when using SchemaExport

I have a db heritage structure like

table t1
(
  c0 bigint, // pk
  c10 bigint,  // deleted flag
)

table t2
(
  c0 bigint, // pk
  c1 bigint, // fk to t1.c0
  c10 bigint,  // deleted flag
)

and classes

class Entity
{
    public virtual long Id { get; private set; }
    public virtual long Property { get; set; }
}

class Parent : Entity
{
    public virtual ICollection<Child> Childs { get; private set; }
}

class Child : Entity { }

After matching with MappingByCode or FNH, SchemaExport will create the columns in the wrong order.

table t2
(
  c0 bigint, // pk
  c10 bool,  // deleted flag
  c1 bigint, // fk to t1.c0
)

How can I make sure the columns are created in ascending order?

+3
source share
1 answer

after digging the source code I came up with this

configuration.BeforeBindMapping += (sender, e) =>
{
    // change to foreach if more than one classmapping per file
    var c = e.Mapping.RootClasses[0];
    c.Items = 
        // sort everything with a column (simple property, reference, ...)
        c.Items.OfType<IColumnsMapping>().OrderBy(cm => cm.Columns.First().name)
        // concat everything that has no column (collection, formula, ...)
        .Concat(c.Items.Where(o => !(o is IColumnsMapping))).ToArray();
};
+3
source

More articles:


All Articles