SELECT
'public '+
case
when systypes.name ='VARCHAR' or systypes.name ='CLOB' then 'string '
when systypes.name ='int'then 'int '
when systypes.name ='nvarchar'then 'string '
when systypes.name ='char'then 'string '
when systypes.name ='DATE'then 'DateTime '
when systypes.name ='text'then 'string '
when systypes.name ='datetime'then 'DateTime '
when systypes.name ='money'then 'Double '
end +' '+syscolumns.name+' '+'{ get; set; }' ,
syscolumns.name AS ColumnName,systypes.name AS Type, syscolumns.length,syscolumns.isnullable
FROM sysobjects
INNER JOIN syscolumns ON sysobjects.id = syscolumns.id
INNER JOIN systypes ON syscolumns.xtype = systypes.xtype
WHERE (sysobjects.xtype = 'U')
AND (sysobjects.name <> 'dtproperties')
AND (sysobjects.name = 'moot_class') --//表名
AND (systypes.name <> 'sysname')
AND (systypes.status <> 3) --//3是排除自定义的数据类型
GROUP BY syscolumns.name, sysobjects.name, syscolumns.xtype,systypes.name, syscolumns.length,syscolumns.isnullable