Easy Enum Generator

The one of reasons that I wrote this tool is saving my development time and all my team members use same enum types. I've seen problems that not knowing a team member already declared enums for lookup tables in db, other team member creates duplicate enum types in different location. And it ended up producing code not easily understandable.

With my passion for efficient way to solve problem, I come up with this tool. I hope it benefits someone out there.

I think if software architect or team leader enforces team members use this tool for a project, I am sure that this tool will save significant amount of development time by providing consistant sync up between enums and lookup tables.

If you have any question, send me an email to oh.csharp@gmail.com

Here is how to use this tool:

1. Download the msi and install it
2. Open/Create your c# project in VS 2010
3. Select a target project you want create enums
4. Go to Tools and click on "EnumGenFromDbAddIn" menu item.
5. You will see database connection popup and lookup table selection popup
6. In the lookup table selection popup do following:
   1. make sure to check a table tree node
   2. select a id column for enum value. Note that a column name must contains "ID".
   3. select a column for enum name. Note that that column name should not contain "ID".
   4. if your lookup table name is lkpClientType, this tool generates ClientType enum
   5. if  your lookup table name is ClientType, this tool generates ClientType enum
   6. your lookup table name is Client, this tool generates ClientType enum
   7. Sorry no error handling
   8. You can select multiple lookup tables for multiple enums
7. Upon clicking on OK, you will see your enum types in DbLookUpEnums.cs in your target porject
8. Share this tool with your team or friends
9. Send me your feedback at oh.csharp@gmail.com
10. Enjoy it!!!

I donot usually share my little toys with others. That 's not because of not wanting to share, but don't want to write instruction like this.

But at this moment, I would like to see if it's worthy to share with others.

Cheers!!!