Recently i have been creating a Generator. That extracts all the names of the tables from the database tables and generates the class file for each of the tables in the database. I have successfully extracted the names of database tables and their corresponding column names with thier data type and length of the datatype. Now i want to place columns as variable names in class file. That can be done but what about the datatype of the variable in class file.
I found an article on MSDN website that matches SQL Server Data Types and Their .NET Framework Equivalents at the following location http://msdn.microsoft.com/en-us/library/ms131092%28SQL.90%29.aspx.
I want to know, is it ok to replace the SQL Server Data Type with their .NET Framework Equivalents comfortably.
Is there any better method to that.