by Frank Perez
August 23, 2012
Since my first ASP.NET MVC, I've always used the Data Annotation Model Binder to perform simple validations like the following:
- Range – validate whether the value of a property falls between a specified range of values.
- Regular Expression – validate whether the value of a property matches a specified regular expression pattern.
- Required – mark a property as required.
- String Length – specify a maximum length for a string property.

The problem is that if you like to design "Database First" like me, it can take a significant amount of time to build all of the classes later. Since I'm the kind of person who hates tedious work, I created my own utility for building the classes called MetaData Class Generator. MetaData Class Generator is a console application for generating Data Annotation classes based on an existing SQL Server Database.
If you would like a copy of this application, you can download the latest version using the link below. The following is a list of important notes:
- This application requires the Microsoft .NET Framework 4 Client Profile.
- This application has only been tested with SQL Server 2008 R2. Other versions may work, but there could be issues mapping newer data types.
- Be sure to read the README.TXT file for instructions on running the application.
- I'd love to hear any feedback. What do you like, what do you not like, what kind of features would you like to see in future versions?
Links:
Download MetaData Class Generator http://pfsolutions-mi.com/Product/MetaDataClassGenerator
Using Data Annotations for Model Validation http://www.asp.net/mvc/tutorials/mvc-music-store/mvc-music-store-part-6
Microsoft .NET Framework 4 Client Profile http://www.microsoft.com/downloads/en/details.aspx?FamilyID=5765d7a8-7722-4888-a970-ac39b33fd8ab
fbeaa73a-bb0f-4d7f-b305-4a4c8f291f69|1|5.0
Keywords:
Filed Under: .NET | MDG