document.write('') document.write('
\n \n \n \n \n\n
\n
\n \n \n \n 
/* ----------------------------------------------------------------------------<\/span><\/div>
Simple tsql C# vo class generator<\/span><\/div>
 <\/div>
Pass in the name of the table to create a class for, and the name for your<\/span><\/div>
resulting class<\/span><\/div>
 <\/div>
Assumptions : <\/span><\/div>
- This script dumps a C# class representation of a sql database table<\/span><\/div>
 <\/div>
- MS tsql datatypes were used for C# converstion<\/span><\/div>
see : http://msdn.microsoft.com/en-us/library/ms131092.aspx<\/span><\/div>
 <\/div>
Usage :<\/span><\/div>
1.Run it<\/span><\/div>
	EXECUTE generateTableVoClass 'YourTableName', 'yourtableclass'<\/span><\/div>
 <\/div>
2.Copy generated rows into your .cs class file<\/span><\/div>
 <\/div>
---------------------------------------------------------------------------- */<\/span><\/div>
 <\/div>
-- Drop stored procedure if it already exists<\/span><\/div>
IF<\/span> EXISTS<\/span> (<\/span><\/div>
  SELECT<\/span> *<\/span> <\/div>
    FROM<\/span> INFORMATION_SCHEMA<\/span>.<\/span>ROUTINES<\/span> <\/div>
   WHERE<\/span> SPECIFIC_SCHEMA<\/span> =<\/span> N<\/span>'dbo'<\/span><\/div>
     AND<\/span> SPECIFIC_NAME<\/span> =<\/span> N<\/span>'generateTableVoClass'<\/span> <\/div>
)<\/span><\/div>
   DROP<\/span> PROCEDURE<\/span> generateTableVoClass<\/span><\/div>
GO<\/span><\/div>
 <\/div>
CREATE<\/span> PROCEDURE<\/span> generateTableVoClass<\/span><\/div>
	(<\/span><\/div>
		@<\/span>tbl_name<\/span> varchar<\/span>(<\/span>100<\/span>),<\/span> <\/div>
		@<\/span>class_name<\/span> varchar<\/span>(<\/span> 100<\/span> )<\/span><\/div>
	)<\/span><\/div>
AS<\/span><\/div>
 <\/div>
-------------------------------------------------------------------------------<\/span><\/div>
 <\/div>
	---------<\/span><\/div>
 <\/div>
	SELECT<\/span>	'public class '<\/span> +<\/span> @<\/span>class_name<\/span> AS<\/span> 'copy all rows to your CS class file'<\/span><\/div>
 <\/div>
	---------<\/span><\/div>
	UNION<\/span> ALL<\/span> <\/div>
 <\/div>
	SELECT<\/span>	'{'<\/span><\/div>
 <\/div>
	---------<\/span><\/div>
	UNION<\/span> ALL<\/span> <\/div>
 <\/div>
	SELECT<\/span>	char<\/span>(<\/span>10<\/span>)<\/span> +<\/span> char<\/span>(<\/span>10<\/span>)<\/span> +<\/span> char<\/span>(<\/span>10<\/span>)<\/span> +<\/span> char<\/span>(<\/span>10<\/span>)<\/span> +<\/span> <\/div>
			'public '<\/span><\/div>
			+<\/span><\/div>
			CASE<\/span> DATA_TYPE<\/span><\/div>
				WHEN<\/span> 'bigint'<\/span> THEN<\/span> 'Int64'<\/span><\/div>
				WHEN<\/span> 'bit'<\/span> THEN<\/span> 'Boolean'<\/span><\/div>
				WHEN<\/span> 'char'<\/span> THEN<\/span> 'string'<\/span><\/div>
				WHEN<\/span> 'date'<\/span> THEN<\/span> 'DateTime'<\/span><\/div>
				WHEN<\/span> 'datetime'<\/span> THEN<\/span> 'DateTime'<\/span><\/div>
				WHEN<\/span> 'decimal'<\/span> THEN<\/span> 'Decimal'<\/span><\/div>
				WHEN<\/span> 'float'<\/span> THEN<\/span> 'Double'<\/span><\/div>
				WHEN<\/span> 'int'<\/span> THEN<\/span> 'Int32'<\/span><\/div>
				WHEN<\/span> 'money'<\/span> THEN<\/span> 'Decimal'<\/span><\/div>
				WHEN<\/span> 'nchar'<\/span> THEN<\/span> 'string'<\/span><\/div>
				WHEN<\/span> 'ntext'<\/span> THEN<\/span> 'string'<\/span><\/div>
				WHEN<\/span> 'numeric'<\/span> THEN<\/span> 'Decimal'<\/span><\/div>
				WHEN<\/span> 'real'<\/span> THEN<\/span> 'Single'<\/span><\/div>
				WHEN<\/span> 'rowversion'<\/span> THEN<\/span> 'Byte[]'<\/span><\/div>
				WHEN<\/span> 'smallint'<\/span> THEN<\/span> 'Int16'<\/span><\/div>
				WHEN<\/span> 'smallmoney'<\/span> THEN<\/span> 'Decimal'<\/span><\/div>
				WHEN<\/span> 'sql_variant'<\/span> THEN<\/span> 'Object'<\/span><\/div>
				WHEN<\/span> 'text'<\/span> THEN<\/span> 'string'<\/span><\/div>
				WHEN<\/span> 'time'<\/span> THEN<\/span> 'DateTime'<\/span><\/div>
				WHEN<\/span> 'timestamp'<\/span> THEN<\/span> 'DateTime'<\/span><\/div>
				WHEN<\/span> 'tinyint'<\/span> THEN<\/span> 'Byte'<\/span><\/div>
				WHEN<\/span> 'uniqueidentifier'<\/span> THEN<\/span> 'Guid'<\/span><\/div>
				WHEN<\/span> 'varbinary '<\/span> THEN<\/span> 'Byte[]'<\/span><\/div>
				WHEN<\/span> 'varchar'<\/span> THEN<\/span> 'string'<\/span><\/div>
 <\/div>
				ELSE<\/span> DATA_TYPE<\/span><\/div>
 <\/div>
			END<\/span><\/div>
			+<\/span> ' '<\/span> +<\/span><\/div>
			COLUMN_NAME<\/span><\/div>
			+<\/span> ' '<\/span> +<\/span><\/div>
			CASE<\/span> DATA_TYPE<\/span><\/div>
				WHEN<\/span> 'bigint'<\/span> THEN<\/span> ' = 0;'<\/span><\/div>
				WHEN<\/span> 'bit'<\/span> THEN<\/span> ' = new Boolean();'<\/span><\/div>
				WHEN<\/span> 'char'<\/span> THEN<\/span> ' = string.Empty;'<\/span><\/div>
				WHEN<\/span> 'date'<\/span> THEN<\/span> ' = new DateTime();'<\/span><\/div>
				WHEN<\/span> 'datetime'<\/span> THEN<\/span> ' = new DateTime();'<\/span><\/div>
				WHEN<\/span> 'decimal'<\/span> THEN<\/span> ' = 0.0;'<\/span><\/div>
				WHEN<\/span> 'float'<\/span> THEN<\/span> ' = 0.0;'<\/span><\/div>
				WHEN<\/span> 'int'<\/span> THEN<\/span> ' = 0;'<\/span><\/div>
				WHEN<\/span> 'money'<\/span> THEN<\/span> ' = 0.0;'<\/span><\/div>
				WHEN<\/span> 'nchar'<\/span> THEN<\/span> ' = string.Empty;'<\/span><\/div>
				WHEN<\/span> 'ntext'<\/span> THEN<\/span> ' = string.Empty;'<\/span><\/div>
				WHEN<\/span> 'numeric'<\/span> THEN<\/span> ' = 0;'<\/span><\/div>
				WHEN<\/span> 'real'<\/span> THEN<\/span> ' = 0;'<\/span><\/div>
				WHEN<\/span> 'rowversion'<\/span> THEN<\/span> ' = new Byte();'<\/span><\/div>
				WHEN<\/span> 'smallint'<\/span> THEN<\/span> ' = 0;'<\/span><\/div>
				WHEN<\/span> 'smallmoney'<\/span> THEN<\/span> ' = 0.0;'<\/span><\/div>
				WHEN<\/span> 'sql_variant'<\/span> THEN<\/span> ' = new Object();'<\/span><\/div>
				WHEN<\/span> 'text'<\/span> THEN<\/span> ' = string.Empty;'<\/span><\/div>
				WHEN<\/span> 'time'<\/span> THEN<\/span> ' = new DateTime();'<\/span><\/div>
				WHEN<\/span> 'timestamp'<\/span> THEN<\/span> ' = new DateTime();'<\/span><\/div>
				WHEN<\/span> 'tinyint'<\/span> THEN<\/span> ' = new Byte();'<\/span><\/div>
				WHEN<\/span> 'uniqueidentifier'<\/span> THEN<\/span> ' = new Guid();'<\/span><\/div>
				WHEN<\/span> 'varbinary '<\/span> THEN<\/span> ' = new Byte();'<\/span><\/div>
				WHEN<\/span> 'varchar'<\/span> THEN<\/span> ' = string.Empty;'<\/span><\/div>
 <\/div>
				ELSE<\/span> ' = string.Empty;'<\/span><\/div>
 <\/div>
			END<\/span><\/div>
 <\/div>
 <\/div>
	FROM<\/span>	INFORMATION_SCHEMA<\/span>.<\/span>COLUMNS<\/span><\/div>
 <\/div>
	WHERE<\/span>	TABLE_NAME<\/span> =<\/span> @<\/span>tbl_name<\/span><\/div>
 <\/div>
	---------<\/span><\/div>
	UNION<\/span> ALL<\/span> <\/div>
 <\/div>
 <\/div>
	SELECT<\/span> '}'<\/span><\/div>
 <\/div>
 <\/div>
-------------------------------------------------------------------------------<\/span><\/div>
 <\/div>
GO<\/span><\/div>
 <\/div>
-- sample usage<\/span><\/div>
-- EXECUTE generateTableVoClass 'DevTable', 'devtable'<\/span><\/div><\/pre><\/div>\n          \n        <\/div>\n\n        
\n          view raw<\/a>\n          generateTableVoClass.sql<\/a>\n          This Gist<\/a> brought to you by GitHub<\/a>.\n        <\/div>\n      <\/div>\n    \n  \n<\/div>\n')