Enum Composer (64 bit)

Enumeration Composer allows to generate and update enum definitions in C# code using data from SQL Server, ODBC or OledDb sources. An enumeration is associated with a SQL SELECT statement which will define enumeration values. Connection to the data source can be defined either in *.config file or directly in the C#.

[EnumSqlSelect("SELECT ContactTypeID, Name, Name FROM Person.ContactType")]public enum ContactTypeEnum{
 [Description("Accounting Manager")] <-- values and descriptions are generated
 AccountingManager = 1, from SQL [Description("Assistant Sales Agent")] AssistantSalesAgent = 2,
 //[Description("Assistant Sales Representative")] <-- comments are preserved //AssistantSalesRepresentative = 3, 
}

To reduce pollution of the code with unnecessary definitions Enumeration Composer preserves commented options during updates. Look-up tables could be large, and values that are not used in the code at the moment can be commented out untill necessary.

See details: https://github.com/uriah65/EnumComposer/wiki