Automatically create an Enum based on values in a database lookup table?

by

I’m doing this exact thing, but you need to do some kind of code generation for this to work.

In my solution, I added a project “EnumeratedTypes”. This is a console application which gets all of the values from the database and constructs the enums from them. Then it saves all of the enums to an assembly.

The enum generation code is like this:

// Get the current application domain for the current thread
AppDomain currentDomain = AppDomain.CurrentDomain;

// Create a dynamic assembly in the current application domain,
// and allow it to be executed and saved to disk.
AssemblyName name = new AssemblyName("MyEnums");
AssemblyBuilder assemblyBuilder = currentDomain.DefineDynamicAssembly(name,
                                      AssemblyBuilderAccess.RunAndSave);

// Define a dynamic module in "MyEnums" assembly.
// For a single-module assembly, the module has the same name as the assembly.
ModuleBuilder moduleBuilder = assemblyBuilder.DefineDynamicModule(name.Name,
                                  name.Name + ".dll");

// Define a public enumeration with the name "MyEnum" and an underlying type of Integer.
EnumBuilder myEnum = moduleBuilder.DefineEnum("EnumeratedTypes.MyEnum",
                         TypeAttributes.Public, typeof(int));

// Get data from database
MyDataAdapter someAdapter = new MyDataAdapter();
MyDataSet.MyDataTable myData = myDataAdapter.GetMyData();

foreach (MyDataSet.MyDataRow row in myData.Rows)
{
    myEnum.DefineLiteral(row.Name, row.Key);
}

// Create the enum
myEnum.CreateType();

// Finally, save the assembly
assemblyBuilder.Save(name.Name + ".dll");

My other projects in the solution reference this generated assembly. As a result, I can then use the dynamic enums in code, complete with intellisense.

Then, I added a post-build event so that after this “EnumeratedTypes” project is built, it runs itself and generates the “MyEnums.dll” file.

By the way, it helps to change the build order of your project so that “EnumeratedTypes” is built first. Otherwise, once you start using your dynamically generated .dll, you won’t be able to do a build if the .dll ever gets deleted. (Chicken and egg kind of problem — your other projects in the solution need this .dll to build properly, and you can’t create the .dll until you build your solution…)

I got most of the above code from this msdn article.

Hope this helps!

More Related Contents:

  1. System.Linq.Expression.Compile error
  2. How to Get Server name and instance name in c# and show in combobox
  3. Getting attributes of Enum’s value
  4. C# Data Connections Best Practice?
  5. Insert 2 million rows into SQL Server quickly
  6. Most common C# bitwise operations on enums
  7. Enum type constraints in C# [duplicate]
  8. Deserialize XML To Object using Dynamic
  9. Get enum from enum attribute
  10. C# winforms combobox dynamic autocomplete
  11. How do I convert an enum to a list in C#? [duplicate]
  12. How do I create a HashCode in .net (c#) for a string that is safe to store in a database?
  13. How do I connect to an MDF database file?
  14. Call static method with reflection
  15. How to detect if a property exists on an ExpandoObject?
  16. How do I cast int to enum in C#?
  17. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  18. Why does a method invocation expression have type dynamic even when there is only one possible return type?
  19. C# with MySQL INSERT parameters
  20. When to use enums, and when to replace them with a class with static members?
  21. Creating an anonymous type dynamically? [duplicate]
  22. How to TryParse for Enum value?
  23. Working with C# Anonymous Types
  24. Validate Enum Values
  25. Accessing directly a Sql Server Database in Xamarin.Forms
  26. How to get next (or previous) enum value in C#
  27. How to compare only Date without Time in DateTime types?
  28. convert an enum to another type of enum
  29. How to insert an image into an Access OLE field via .NET
  30. Could not load file or assembly ‘MySql.Data, Version=6.2.2.0

Leave a Comment