blocks|key|694570|text|只要您的表包含两列，并且名称类似于'tblPeople‘，就可以了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|694571|您可以随时编写自己的SQL包装器。实际上我更喜欢这样做，我讨厌以任何方式生成代码。|694572|可以创建一个DAL类，并有一个名为GetPerson(int+id)的方法，该方法在数据库中查询那个person，然后根据结果集创建Person对象。|offset|length|style|CODE|694573|entityMap^0|0|0|6|3|H|H|1U|6|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@$F|O|G|P|H|I]|$F|Q|G|R|H|I]|$F|S|G|T|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|K|$]]

You just did, as long as your table contains two columns and is called something like 'tblPeople'.

You can always write your own SQL wrappers. I actually prefer to do it that way, I HATE generated code, in any fashion.

Maybe create a <code>DAL</code> class, and have a method called <code>GetPerson(int id)</code>, that queries the database for that person, and then creates your <code>Person</code> object from the result set.

blocks|key|694652|text|将@TableName设置为您的表名。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|694653|declare+@TableName+sysname+=+'TableName'
declare+@Result+varchar(max)+=+'public+class+'+%2B+@TableName+%2B+'
{'

select+@Result+=+@Result+%2B+'
++++public+'+%2B+ColumnType+%2B+NullableSign+%2B+'+'+%2B+ColumnName+%2B+'+{+get;+set;+}
'
from
(
++++select+
++++++++replace(col.name,+'+',+'_')+ColumnName,
++++++++column_id+ColumnId,
++++++++case+typ.name+
++++++++++++when+'bigint'+then+'long'
++++++++++++when+'binary'+then+'byte[]'
++++++++++++when+'bit'+then+'bool'
++++++++++++when+'char'+then+'string'
++++++++++++when+'date'+then+'DateTime'
++++++++++++when+'datetime'+then+'DateTime'
++++++++++++when+'datetime2'+then+'DateTime'
++++++++++++when+'datetimeoffset'+then+'DateTimeOffset'
++++++++++++when+'decimal'+then+'decimal'
++++++++++++when+'float'+then+'double'
++++++++++++when+'image'+then+'byte[]'
++++++++++++when+'int'+then+'int'
++++++++++++when+'money'+then+'decimal'
++++++++++++when+'nchar'+then+'string'
++++++++++++when+'ntext'+then+'string'
++++++++++++when+'numeric'+then+'decimal'
++++++++++++when+'nvarchar'+then+'string'
++++++++++++when+'real'+then+'float'
++++++++++++when+'smalldatetime'+then+'DateTime'
++++++++++++when+'smallint'+then+'short'
++++++++++++when+'smallmoney'+then+'decimal'
++++++++++++when+'text'+then+'string'
++++++++++++when+'time'+then+'TimeSpan'
++++++++++++when+'timestamp'+then+'long'
++++++++++++when+'tinyint'+then+'byte'
++++++++++++when+'uniqueidentifier'+then+'Guid'
++++++++++++when+'varbinary'+then+'byte[]'
++++++++++++when+'varchar'+then+'string'
++++++++++++else+'UNKNOWN_'+%2B+typ.name
++++++++end+ColumnType,
++++++++case+
++++++++++++when+col.is_nullable+=+1+and+typ.name+in+('bigint',+'bit',+'date',+'datetime',+'datetime2',+'datetimeoffset',+'decimal',+'float',+'int',+'money',+'numeric',+'real',+'smalldatetime',+'smallint',+'smallmoney',+'time',+'tinyint',+'uniqueidentifier')+
++++++++++++then+'?'+
++++++++++++else+''+
++++++++end+NullableSign
++++from+sys.columns+col
++++++++join+sys.types+typ+on
++++++++++++col.system_type_id+=+typ.system_type_id+AND+col.user_type_id+=+typ.user_type_id
++++where+object_id+=+object_id(@TableName)
)+t
order+by+ColumnId

set+@Result+=+@Result++%2B+'
}'

print+@Result|code-block|syntax|javascript|694654|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Set @TableName to the name of your table.
<pre><code>declare @TableName sysname = 'TableName'
declare @Result varchar(max) = 'public class ' + @TableName + '
{'

select @Result = @Result + '
 public ' + ColumnType + NullableSign + ' ' + ColumnName + ' { get; set; }
'
from
(
 select 
 replace(col.name, ' ', '_') ColumnName,
 column_id ColumnId,
 case typ.name 
 when 'bigint' then 'long'
 when 'binary' then 'byte[]'
 when 'bit' then 'bool'
 when 'char' then 'string'
 when 'date' then 'DateTime'
 when 'datetime' then 'DateTime'
 when 'datetime2' then 'DateTime'
 when 'datetimeoffset' then 'DateTimeOffset'
 when 'decimal' then 'decimal'
 when 'float' then 'double'
 when 'image' then 'byte[]'
 when 'int' then 'int'
 when 'money' then 'decimal'
 when 'nchar' then 'string'
 when 'ntext' then 'string'
 when 'numeric' then 'decimal'
 when 'nvarchar' then 'string'
 when 'real' then 'float'
 when 'smalldatetime' then 'DateTime'
 when 'smallint' then 'short'
 when 'smallmoney' then 'decimal'
 when 'text' then 'string'
 when 'time' then 'TimeSpan'
 when 'timestamp' then 'long'
 when 'tinyint' then 'byte'
 when 'uniqueidentifier' then 'Guid'
 when 'varbinary' then 'byte[]'
 when 'varchar' then 'string'
 else 'UNKNOWN_' + typ.name
 end ColumnType,
 case 
 when col.is_nullable = 1 and typ.name in ('bigint', 'bit', 'date', 'datetime', 'datetime2', 'datetimeoffset', 'decimal', 'float', 'int', 'money', 'numeric', 'real', 'smalldatetime', 'smallint', 'smallmoney', 'time', 'tinyint', 'uniqueidentifier') 
 then '?' 
 else '' 
 end NullableSign
 from sys.columns col
 join sys.types typ on
 col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id
 where object_id = object_id(@TableName)
) t
order by ColumnId

set @Result = @Result + '
}'

print @Result
</code></pre>

blocks|key|694673|text|商业化，但CodeSmith生成器做到了：http://www.codesmithtools.com/product/generator|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|694674|entityMap|0|LINK|mutability|MUTABLE|url|http://www.codesmithtools.com/product/generator^0|L|1B|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Commercial, but CodeSmith Generator does that: <a href="http://www.codesmithtools.com/product/generator" rel="nofollow">http://www.codesmithtools.com/product/generator</a>

blocks|key|910794|text|VB版本|type|unstyled|depth|inlineStyleRanges|entityRanges|data|910795|declare+@TableName+sysname+=+'myTableName'
declare+@prop+varchar(max)
PRINT+'Public+Class+'+%2B+@TableName
declare+props+cursor+for
select+distinct+'+public+property+'+%2B+ColumnName+%2B+'+AS+'+%2B+ColumnType+AS+prop
from+(+
++++select++
++++++++replace(col.name,+'+',+'_')+ColumnName,++column_id,+
++++++++case+typ.name++
++++++++++++when+'bigint'+then+'long'+
++++++++++++when+'binary'+then+'byte[]'+
++++++++++++when+'bit'+then+'boolean'+
++++++++++++when+'char'+then+'string'+
++++++++++++when+'date'+then+'DateTime'+
++++++++++++when+'datetime'+then+'DateTime'+
++++++++++++when+'datetime2'+then+'DateTime'+
++++++++++++when+'datetimeoffset'+then+'DateTimeOffset'+
++++++++++++when+'decimal'+then+'decimal'+
++++++++++++when+'float'+then+'float'+
++++++++++++when+'image'+then+'byte[]'+
++++++++++++when+'int'+then+'integer'+
++++++++++++when+'money'+then+'decimal'+
++++++++++++when+'nchar'+then+'char'+
++++++++++++when+'ntext'+then+'string'+
++++++++++++when+'numeric'+then+'decimal'+
++++++++++++when+'nvarchar'+then+'string'+
++++++++++++when+'real'+then+'double'+
++++++++++++when+'smalldatetime'+then+'DateTime'+
++++++++++++when+'smallint'+then+'short'+
++++++++++++when+'smallmoney'+then+'decimal'+
++++++++++++when+'text'+then+'string'+
++++++++++++when+'time'+then+'TimeSpan'+
++++++++++++when+'timestamp'+then+'DateTime'+
++++++++++++when+'tinyint'+then+'byte'+
++++++++++++when+'uniqueidentifier'+then+'Guid'+
++++++++++++when+'varbinary'+then+'byte[]'+
++++++++++++when+'varchar'+then+'string'+
++++++++end+ColumnType+
++++from+sys.columns+col+join+sys.types+typ+on+col.system_type_id+=+typ.system_type_id+
++++where+object_id+=+object_id(@TableName)+
)+t+
order+by+prop
open+props
FETCH+NEXT+FROM+props+INTO+@prop
WHILE+@@FETCH_STATUS+=+0
BEGIN
++++print+@prop
++++FETCH+NEXT+FROM+props+INTO+@prop
END
close+props
DEALLOCATE+props
PRINT+'End+Class'|code-block|syntax|javascript|910796|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

VB version

<pre><code>declare @TableName sysname = 'myTableName'
declare @prop varchar(max)
PRINT 'Public Class ' + @TableName
declare props cursor for
select distinct ' public property ' + ColumnName + ' AS ' + ColumnType AS prop
from ( 
 select 
 replace(col.name, ' ', '_') ColumnName, column_id, 
 case typ.name 
 when 'bigint' then 'long' 
 when 'binary' then 'byte[]' 
 when 'bit' then 'boolean' 
 when 'char' then 'string' 
 when 'date' then 'DateTime' 
 when 'datetime' then 'DateTime' 
 when 'datetime2' then 'DateTime' 
 when 'datetimeoffset' then 'DateTimeOffset' 
 when 'decimal' then 'decimal' 
 when 'float' then 'float' 
 when 'image' then 'byte[]' 
 when 'int' then 'integer' 
 when 'money' then 'decimal' 
 when 'nchar' then 'char' 
 when 'ntext' then 'string' 
 when 'numeric' then 'decimal' 
 when 'nvarchar' then 'string' 
 when 'real' then 'double' 
 when 'smalldatetime' then 'DateTime' 
 when 'smallint' then 'short' 
 when 'smallmoney' then 'decimal' 
 when 'text' then 'string' 
 when 'time' then 'TimeSpan' 
 when 'timestamp' then 'DateTime' 
 when 'tinyint' then 'byte' 
 when 'uniqueidentifier' then 'Guid' 
 when 'varbinary' then 'byte[]' 
 when 'varchar' then 'string' 
 end ColumnType 
 from sys.columns col join sys.types typ on col.system_type_id = typ.system_type_id 
 where object_id = object_id(@TableName) 
) t 
order by prop
open props
FETCH NEXT FROM props INTO @prop
WHILE @@FETCH_STATUS = 0
BEGIN
 print @prop
 FETCH NEXT FROM props INTO @prop
END
close props
DEALLOCATE props
PRINT 'End Class'
</code></pre>

blocks|key|694788|text|要打印出NULLABLE属性，请使用此命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|694789|它对Alex+Aza的CASE语句块的脚本进行了轻微的修改。|offset|length|style|CODE|694790|declare+@TableName+sysname+=+'TableName'
declare+@result+varchar(max)+=+'public+class+'+%2B+@TableName+%2B+'
{'

select+@result+=+@result+%2B+'
++++public+'+%2B+ColumnType+%2B+'+'+%2B+ColumnName+%2B+'+{+get;+set;+}
'
from
(
++++select+
++++++++replace(col.name,+'+',+'_')+ColumnName,
++++++++column_id,
++++++++case+typ.name+
++++++++++++when+'bigint'+then+'long'
++++++++++++when+'binary'+then+'byte[]'
++++++++++++when+'bit'+then+'bool'
++++++++++++when+'char'+then+'string'
++++++++++++when+'date'+then+'DateTime'
++++++++++++when+'datetime'+then+'DateTime'
++++++++++++when+'datetime2'+then+'DateTime'
++++++++++++when+'datetimeoffset'+then+'DateTimeOffset'
++++++++++++when+'decimal'+then+'decimal'
++++++++++++when+'float'+then+'float'
++++++++++++when+'image'+then+'byte[]'
++++++++++++when+'int'+then+'int'
++++++++++++when+'money'+then+'decimal'
++++++++++++when+'nchar'+then+'char'
++++++++++++when+'ntext'+then+'string'
++++++++++++when+'numeric'+then+'decimal'
++++++++++++when+'nvarchar'+then+'string'
++++++++++++when+'real'+then+'double'
++++++++++++when+'smalldatetime'+then+'DateTime'
++++++++++++when+'smallint'+then+'short'
++++++++++++when+'smallmoney'+then+'decimal'
++++++++++++when+'text'+then+'string'
++++++++++++when+'time'+then+'TimeSpan'
++++++++++++when+'timestamp'+then+'DateTime'
++++++++++++when+'tinyint'+then+'byte'
++++++++++++when+'uniqueidentifier'+then+'Guid'
++++++++++++when+'varbinary'+then+'byte[]'
++++++++++++when+'varchar'+then+'string'
++++++++++++else+'UNKNOWN_'+%2B+typ.name
++++++++end+%2B+
++++++++CASE
++++++++++++WHEN+col.is_nullable=1+AND
+++++++++++++++++typ.name+NOT+IN+(
+++++++++++++++++++++'binary',+'varbinary',+'image',
+++++++++++++++++++++'text',+'ntext',
+++++++++++++++++++++'varchar',+'nvarchar',+'char',+'nchar')
++++++++++++THEN+'?'
++++++++++++ELSE+''+END+AS+[ColumnType]
++++from+sys.columns+col
++++++++join+sys.types+typ+on
++++++++++++col.system_type_id+=+typ.system_type_id+AND+col.user_type_id+=+typ.user_type_id+
++++where+object_id+=+object_id(@TableName)
)+t
order+by+column_id

set+@result+=+@result++%2B+'
}'

print+@result|code-block|syntax|javascript|694791|entityMap^0|0|B|4|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|S|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

To print out NULLABLE properties, use this. 
It adds a slight modification to Alex Aza's script for the <code>CASE</code> statement block.

<pre><code>declare @TableName sysname = 'TableName'
declare @result varchar(max) = 'public class ' + @TableName + '
{'

select @result = @result + '
 public ' + ColumnType + ' ' + ColumnName + ' { get; set; }
'
from
(
 select 
 replace(col.name, ' ', '_') ColumnName,
 column_id,
 case typ.name 
 when 'bigint' then 'long'
 when 'binary' then 'byte[]'
 when 'bit' then 'bool'
 when 'char' then 'string'
 when 'date' then 'DateTime'
 when 'datetime' then 'DateTime'
 when 'datetime2' then 'DateTime'
 when 'datetimeoffset' then 'DateTimeOffset'
 when 'decimal' then 'decimal'
 when 'float' then 'float'
 when 'image' then 'byte[]'
 when 'int' then 'int'
 when 'money' then 'decimal'
 when 'nchar' then 'char'
 when 'ntext' then 'string'
 when 'numeric' then 'decimal'
 when 'nvarchar' then 'string'
 when 'real' then 'double'
 when 'smalldatetime' then 'DateTime'
 when 'smallint' then 'short'
 when 'smallmoney' then 'decimal'
 when 'text' then 'string'
 when 'time' then 'TimeSpan'
 when 'timestamp' then 'DateTime'
 when 'tinyint' then 'byte'
 when 'uniqueidentifier' then 'Guid'
 when 'varbinary' then 'byte[]'
 when 'varchar' then 'string'
 else 'UNKNOWN_' + typ.name
 end + 
 CASE
 WHEN col.is_nullable=1 AND
 typ.name NOT IN (
 'binary', 'varbinary', 'image',
 'text', 'ntext',
 'varchar', 'nvarchar', 'char', 'nchar')
 THEN '?'
 ELSE '' END AS [ColumnType]
 from sys.columns col
 join sys.types typ on
 col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id 
 where object_id = object_id(@TableName)
) t
order by column_id

set @result = @result + '
}'

print @result
</code></pre>

blocks|key|910922|text|我试着使用上面的建议，并在这个过程中改进了本文中的解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|910923|假设您使用了一个实现PropertyChanged事件的基类(本例中为ObservableObject)，您可以这样做。有一天我可能会在我的博客sqljana.wordpress.com上写一篇博文|910924|请将前三个变量的值替换为：|910925|++++--These+three+things+have+to+be+substituted+(when+called+from+Powershell,+they+are+replaced+before+execution)
DECLARE+@Schema+VARCHAR(MAX)+=+N'&Schema'
DECLARE+@TableName+VARCHAR(MAX)+=+N'&TableName'
DECLARE+@Namespace+VARCHAR(MAX)+=+N'&Namespace'

DECLARE+@CRLF+VARCHAR(2)+=+CHAR(13)+%2B+CHAR(10);
DECLARE+@result+VARCHAR(max)+=+'+'

DECLARE+@PrivateProp+VARCHAR(100)+=+@CRLF+%2B+
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'private+<ColumnType>+_<ColumnName>;';
DECLARE+@PublicProp+VARCHAR(255)+=+@CRLF+%2B+
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'public+<ColumnType>+<ColumnName>+'++%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'{+'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'+++get+{+return+_<ColumnName>;+}+'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'+++set+'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'+++{+'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'+++++++_<ColumnName>+=+value;'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'+++++++base.RaisePropertyChanged();'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'+++}+'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'}'+%2B+@CRLF;

DECLARE+@RPCProc+VARCHAR(MAX)+=+@CRLF+%2B+++++++++
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'public+event+PropertyChangedEventHandler+PropertyChanged;+'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'private+void+RaisePropertyChanged(+'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'+++++++[CallerMemberName]+string+caller+=+""+)+'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'{++'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'+++if+(PropertyChanged+!=+null)++'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'+++{+'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'+++++++PropertyChanged(+this,+new+PropertyChangedEventArgs(+caller+)+);++'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'+++}+'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'}';

DECLARE+@PropChanged+VARCHAR(200)+=++@CRLF+%2B++++++++++++
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'protected+override+void+AfterPropertyChanged(string+propertyName)+'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'{+'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'+++System.Diagnostics.Debug.WriteLine("'+%2B+@TableName+%2B+'+property+changed:+"+%2B+propertyName);+'+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+CHAR(9)+%2B+'}';

SET+@result+=+'using+System;'+%2B+@CRLF+%2B+@CRLF+%2B
++++++++++++++++'using+MyCompany.Business;'+%2B+@CRLF+%2B+@CRLF+%2B
++++++++++++++++'namespace+'+%2B+@Namespace++%2B+@CRLF+%2B+'{'+%2B+@CRLF+%2B
++++++++++++++++'+++public+class+'+%2B+@TableName+%2B+'+:+ObservableObject'+%2B+@CRLF+%2B+
++++++++++++++++'+++{'+%2B+@CRLF+%2B
++++++++++++++++'+++#region+Instance+Properties'+%2B+@CRLF+

SELECT+@result+=+@result
+++++++++++++++++%2B+
++++++++++++++++REPLACE(
++++++++++++++++++++++++++++REPLACE(@PrivateProp
++++++++++++++++++++++++++++,+'<ColumnName>',+ColumnName)
++++++++++++++++++++++++,+'<ColumnType>',+ColumnType)
++++++++++++++++%2B+++++++++++++++++++++++++++
++++++++++++++++REPLACE(
++++++++++++++++++++++++++++REPLACE(@PublicProp
++++++++++++++++++++++++++++,+'<ColumnName>',+ColumnName)
++++++++++++++++++++++++,+'<ColumnType>',+ColumnType)+++++++++++++++++++
FROM
(
++++SELECT++c.COLUMN_NAME+++AS+ColumnName+
++++++++,+CASE+c.DATA_TYPE+++
++++++++++++WHEN+'bigint'+THEN
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'Int64?'+ELSE+'Int64'+END
++++++++++++WHEN+'binary'+THEN+'Byte[]'
++++++++++++WHEN+'bit'+THEN+
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'Boolean?'+ELSE+'Boolean'+END++++++++++++
++++++++++++WHEN+'char'+THEN+'String'
++++++++++++WHEN+'date'+THEN
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'DateTime?'+ELSE+'DateTime'+END++++++++++++++++++++++++
++++++++++++WHEN+'datetime'+THEN
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'DateTime?'+ELSE+'DateTime'+END++++++++++++++++++++++++
++++++++++++WHEN+'datetime2'+THEN++
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'DateTime?'+ELSE+'DateTime'+END++++++++++++++++++++++++
++++++++++++WHEN+'datetimeoffset'+THEN+
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'DateTimeOffset?'+ELSE+'DateTimeOffset'+END++++++++++++++++++++++++++++++++++++
++++++++++++WHEN+'decimal'+THEN++
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'Decimal?'+ELSE+'Decimal'+END++++++++++++++++++++++++++++++++++++
++++++++++++WHEN+'float'+THEN+
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'Single?'+ELSE+'Single'+END++++++++++++++++++++++++++++++++++++
++++++++++++WHEN+'image'+THEN+'Byte[]'
++++++++++++WHEN+'int'+THEN++
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'Int32?'+ELSE+'Int32'+END
++++++++++++WHEN+'money'+THEN
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'Decimal?'+ELSE+'Decimal'+END++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++WHEN+'nchar'+THEN+'String'
++++++++++++WHEN+'ntext'+THEN+'String'
++++++++++++WHEN+'numeric'+THEN
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'Decimal?'+ELSE+'Decimal'+END++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++WHEN+'nvarchar'+THEN+'String'
++++++++++++WHEN+'real'+THEN+
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'Double?'+ELSE+'Double'+END++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++WHEN+'smalldatetime'+THEN+
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'DateTime?'+ELSE+'DateTime'+END++++++++++++++++++++++++++++++++++++
++++++++++++WHEN+'smallint'+THEN+
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'Int16?'+ELSE+'Int16'END++++++++++++
++++++++++++WHEN+'smallmoney'+THEN++
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'Decimal?'+ELSE+'Decimal'+END++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++WHEN+'text'+THEN+'String'
++++++++++++WHEN+'time'+THEN+
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'TimeSpan?'+ELSE+'TimeSpan'+END++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++WHEN+'timestamp'+THEN+
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'DateTime?'+ELSE+'DateTime'+END++++++++++++++++++++++++++++++++++++
++++++++++++WHEN+'tinyint'+THEN+
++++++++++++++++CASE+C.IS_NULLABLE
++++++++++++++++++++WHEN+'YES'+THEN+'Byte?'+ELSE+'Byte'+END++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++WHEN+'uniqueidentifier'+THEN+'Guid'
++++++++++++WHEN+'varbinary'+THEN+'Byte[]'
++++++++++++WHEN+'varchar'+THEN+'String'
++++++++++++ELSE+'Object'
++++++++END+AS+ColumnType
++++++++,+c.ORDINAL_POSITION+
FROM++++INFORMATION_SCHEMA.COLUMNS+c
WHERE+++c.TABLE_NAME+=+@TableName+
++++AND+ISNULL(@Schema,+c.TABLE_SCHEMA)+=+c.TABLE_SCHEMA++
)+t
ORDER+BY+t.ORDINAL_POSITION

SELECT+@result+=+@result+%2B+@CRLF+%2B+
++++++++++++++++CHAR(9)+%2B+'#endregion+Instance+Properties'+%2B+@CRLF+%2B
++++++++++++++++--CHAR(9)+%2B+@RPCProc+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+@PropChanged+%2B+@CRLF+%2B
++++++++++++++++CHAR(9)+%2B+'}'+%2B+@CRLF+%2B
++++++++++++++++@CRLF+%2B+'}'+
--SELECT+@result
PRINT+@result|code-block|syntax|javascript|910926|这个基类基于Josh+Smith在http://joshsmithonwpf.wordpress.com/2007/08/29/a-base-class-which-implements-inotifypropertychanged/上的文章|offset|length|910927|我确实将该类重命名为ObservableObject，并使用CallerMemberName属性利用了c#+5的一个特性|910928|//From+http://joshsmithonwpf.wordpress.com/2007/08/29/a-base-class-which-implements-inotifypropertychanged/
//
//Jana's+change:+Used+c#+5+feature+to+bypass+passing+in+the+property+name+using+[CallerMemberName]+
//++protected+void+RaisePropertyChanged([CallerMemberName]+string+propertyName+=+"")

using+System;
using+System.Collections.Generic;
using+System.ComponentModel;
using+System.Diagnostics;
using+System.Reflection;
using+System.Runtime.CompilerServices;

namespace+MyCompany.Business
{

++++///+<summary>
++++///+Implements+the+INotifyPropertyChanged+interface+and+
++++///+exposes+a+RaisePropertyChanged+method+for+derived+
++++///+classes+to+raise+the+PropertyChange+event.++The+event+
++++///+arguments+created+by+this+class+are+cached+to+prevent+
++++///+managed+heap+fragmentation.
++++///+</summary>
++++[Serializable]
++++public+abstract+class+ObservableObject+:+INotifyPropertyChanged
++++{
++++++++#region+Data

++++++++private+static+readonly+Dictionary<string,+PropertyChangedEventArgs>+eventArgCache;
++++++++private+const+string+ERROR_MSG+=+"{0}+is+not+a+public+property+of+{1}";

++++++++#endregion+//+Data

++++++++#region+Constructors

++++++++static+ObservableObject()
++++++++{
++++++++++++eventArgCache+=+new+Dictionary<string,+PropertyChangedEventArgs>();
++++++++}

++++++++protected+ObservableObject()
++++++++{
++++++++}

++++++++#endregion+//+Constructors

++++++++#region+Public+Members

++++++++///+<summary>
++++++++///+Raised+when+a+public+property+of+this+object+is+set.
++++++++///+</summary>
++++++++[field:+NonSerialized]
++++++++public+event+PropertyChangedEventHandler+PropertyChanged;

++++++++///+<summary>
++++++++///+Returns+an+instance+of+PropertyChangedEventArgs+for+
++++++++///+the+specified+property+name.
++++++++///+</summary>
++++++++///+<param+name="propertyName">
++++++++///+The+name+of+the+property+to+create+event+args+for.
++++++++///+</param>++++++++
++++++++public+static+PropertyChangedEventArgs
++++++++++++GetPropertyChangedEventArgs(string+propertyName)
++++++++{
++++++++++++if+(String.IsNullOrEmpty(propertyName))
++++++++++++++++throw+new+ArgumentException(
++++++++++++++++++++"propertyName+cannot+be+null+or+empty.");

++++++++++++PropertyChangedEventArgs+args;

++++++++++++//+Get+the+event+args+from+the+cache,+creating+them
++++++++++++//+and+adding+to+the+cache+if+necessary.
++++++++++++lock+(typeof(ObservableObject))
++++++++++++{
++++++++++++++++bool+isCached+=+eventArgCache.ContainsKey(propertyName);
++++++++++++++++if+(!isCached)
++++++++++++++++{
++++++++++++++++++++eventArgCache.Add(
++++++++++++++++++++++++propertyName,
++++++++++++++++++++++++new+PropertyChangedEventArgs(propertyName));
++++++++++++++++}

++++++++++++++++args+=+eventArgCache[propertyName];
++++++++++++}

++++++++++++return+args;
++++++++}

++++++++#endregion+//+Public+Members

++++++++#region+Protected+Members

++++++++///+<summary>
++++++++///+Derived+classes+can+override+this+method+to
++++++++///+execute+logic+after+a+property+is+set.+The+
++++++++///+base+implementation+does+nothing.
++++++++///+</summary>
++++++++///+<param+name="propertyName">
++++++++///+The+property+which+was+changed.
++++++++///+</param>
++++++++protected+virtual+void+AfterPropertyChanged(string+propertyName)
++++++++{
++++++++}

++++++++///+<summary>
++++++++///+Attempts+to+raise+the+PropertyChanged+event,+and+
++++++++///+invokes+the+virtual+AfterPropertyChanged+method,+
++++++++///+regardless+of+whether+the+event+was+raised+or+not.
++++++++///+</summary>
++++++++///+<param+name="propertyName">
++++++++///+The+property+which+was+changed.
++++++++///+</param>
++++++++protected+void+RaisePropertyChanged([CallerMemberName]+string+propertyName+=+"")
++++++++{
++++++++++++this.VerifyProperty(propertyName);

++++++++++++PropertyChangedEventHandler+handler+=+this.PropertyChanged;
++++++++++++if+(handler+!=+null)
++++++++++++{
++++++++++++++++//+Get+the+cached+event+args.
++++++++++++++++PropertyChangedEventArgs+args+=
++++++++++++++++++++GetPropertyChangedEventArgs(propertyName);

++++++++++++++++//+Raise+the+PropertyChanged+event.
++++++++++++++++handler(this,+args);
++++++++++++}

++++++++++++this.AfterPropertyChanged(propertyName);
++++++++}

++++++++#endregion+//+Protected+Members

++++++++#region+Private+Helpers

++++++++[Conditional("DEBUG")]
++++++++private+void+VerifyProperty(string+propertyName)
++++++++{
++++++++++++Type+type+=+this.GetType();

++++++++++++//+Look+for+a+public+property+with+the+specified+name.
++++++++++++PropertyInfo+propInfo+=+type.GetProperty(propertyName);

++++++++++++if+(propInfo+==+null)
++++++++++++{
++++++++++++++++//+The+property+could+not+be+found,
++++++++++++++++//+so+alert+the+developer+of+the+problem.

++++++++++++++++string+msg+=+string.Format(
++++++++++++++++++++ERROR_MSG,
++++++++++++++++++++propertyName,
++++++++++++++++++++type.FullName);

++++++++++++++++Debug.Fail(msg);
++++++++++++}
++++++++}

++++++++#endregion+//+Private+Helpers
++++}
}|910929|这是你们会更喜欢的部分。我构建了一个Powershell脚本来为SQL数据库中的所有表生成数据。它基于名为查德·米勒的Invoke-SQLCmd2cmdlet的Powershell大师，可以从以下位置下载：http://gallery.technet.microsoft.com/ScriptCenter/7985b7ef-ed89-4dfd-b02a-433cc4e30894/|910930|有了这个cmdlet之后，为所有表生成的Powershell脚本就变得很简单(一定要用您的特定值替换变量)。|910931|.+C:\MyScripts\Invoke-Sqlcmd2.ps1

$serverInstance+=+"MySQLInstance"
$databaseName+=+"MyDb"
$generatorSQLFile+=+"C:\MyScripts\ModelGen.sql"+
$tableListSQL+=+"SELECT+name+FROM+$databaseName.sys.tables"
$outputFolder+=+"C:\MyScripts\Output\"
$namespace+=+"MyCompany.Business"

$placeHolderSchema+=+"&Schema"
$placeHolderTableName+=+"&TableName"
$placeHolderNamespace+=+"&Namespace"

#Get+the+list+of+tables+in+the+database+to+generate+c#+models+for
$tables+=+Invoke-Sqlcmd2+-ServerInstance+$serverInstance+-Database+$databaseName+-Query+$tableListSQL+-As+DataRow+-Verbose

foreach+($table+in+$tables)
{
++++$table1+=+$table[0]
++++$outputFile+=+"$outputFolder\$table1.cs"


++++#Replace+variables+with+values+(returns+an+array+that+we+convert+to+a+string+to+use+as+query)
++++$generatorSQLFileWSubstitutions+=+(Get-Content+$generatorSQLFile).
++++++++++++++++++++++++++++++++++++++++++++Replace($placeHolderSchema,"dbo").
++++++++++++++++++++++++++++++++++++++++++++Replace($placeHolderTableName,+$table1).
++++++++++++++++++++++++++++++++++++++++++++Replace($placeHolderNamespace,+$namespace)+%7C+Out-String

++++"Ouputing+for+$table1+to+$outputFile"

++++#The+command+generates+.cs+file+content+for+model+using+"PRINT"+statements+which+then+gets+written+to+verbose+output+(stream+4)
++++#+...capture+the+verbose+output+and+redirect+to+a+file
++++(Invoke-Sqlcmd2+-ServerInstance+$serverInstance+-Database+$databaseName+-Query+$generatorSQLFileWSubstitutions+-Verbose)+4>+$outputFile

}|910932|entityMap|0|LINK|mutability|MUTABLE|url|http://joshsmithonwpf.wordpress.com/2007/08/29/a-base-class-which-implements-inotifypropertychanged/|1|http://gallery.technet.microsoft.com/ScriptCenter/7985b7ef-ed89-4dfd-b02a-433cc4e30894/^0|0|0|0|0|H|2S|0|0|0|0|2V|2F|1|0|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|19|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1A|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|1B|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|1C|8|@]|9|@$M|1D|N|1E|1|1F]]|A|$]]|$1|O|3|P|5|6|7|1G|8|@]|9|@]|A|$]]|$1|Q|3|R|5|H|7|1H|8|@]|9|@]|A|$I|J]]|$1|S|3|T|5|6|7|1I|8|@]|9|@$M|1J|N|1K|1|1L]]|A|$]]|$1|U|3|V|5|6|7|1M|8|@]|9|@]|A|$]]|$1|W|3|X|5|H|7|1N|8|@]|9|@]|A|$I|J]]|$1|Y|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]]|Z|$10|$5|11|12|13|A|$14|15]]|16|$5|11|12|13|A|$14|17]]]]

I tried to use the suggestions above and in the process improved upon the solutions in this thread.

Let us say you use a base class (ObservableObject in this case) that implements the PropertyChanged Event, you would do something like this. I will probably write a blog post one day in my blog 
sqljana.wordpress.com

Please do substitute the values for the first three variables:

<pre><code> --These three things have to be substituted (when called from Powershell, they are replaced before execution)
DECLARE @Schema VARCHAR(MAX) = N'&amp;Schema'
DECLARE @TableName VARCHAR(MAX) = N'&amp;TableName'
DECLARE @Namespace VARCHAR(MAX) = N'&amp;Namespace'

DECLARE @CRLF VARCHAR(2) = CHAR(13) + CHAR(10);
DECLARE @result VARCHAR(max) = ' '

DECLARE @PrivateProp VARCHAR(100) = @CRLF + 
 CHAR(9) + CHAR(9) + 'private &lt;ColumnType&gt; _&lt;ColumnName&gt;;';
DECLARE @PublicProp VARCHAR(255) = @CRLF + 
 CHAR(9) + CHAR(9) + 'public &lt;ColumnType&gt; &lt;ColumnName&gt; ' + @CRLF +
 CHAR(9) + CHAR(9) + '{ ' + @CRLF +
 CHAR(9) + CHAR(9) + ' get { return _&lt;ColumnName&gt;; } ' + @CRLF +
 CHAR(9) + CHAR(9) + ' set ' + @CRLF +
 CHAR(9) + CHAR(9) + ' { ' + @CRLF +
 CHAR(9) + CHAR(9) + ' _&lt;ColumnName&gt; = value;' + @CRLF +
 CHAR(9) + CHAR(9) + ' base.RaisePropertyChanged();' + @CRLF +
 CHAR(9) + CHAR(9) + ' } ' + @CRLF +
 CHAR(9) + CHAR(9) + '}' + @CRLF;

DECLARE @RPCProc VARCHAR(MAX) = @CRLF + 
 CHAR(9) + CHAR(9) + 'public event PropertyChangedEventHandler PropertyChanged; ' + @CRLF +
 CHAR(9) + CHAR(9) + 'private void RaisePropertyChanged( ' + @CRLF +
 CHAR(9) + CHAR(9) + ' [CallerMemberName] string caller = "" ) ' + @CRLF +
 CHAR(9) + CHAR(9) + '{ ' + @CRLF +
 CHAR(9) + CHAR(9) + ' if (PropertyChanged != null) ' + @CRLF +
 CHAR(9) + CHAR(9) + ' { ' + @CRLF +
 CHAR(9) + CHAR(9) + ' PropertyChanged( this, new PropertyChangedEventArgs( caller ) ); ' + @CRLF +
 CHAR(9) + CHAR(9) + ' } ' + @CRLF +
 CHAR(9) + CHAR(9) + '}';

DECLARE @PropChanged VARCHAR(200) = @CRLF + 
 CHAR(9) + CHAR(9) + 'protected override void AfterPropertyChanged(string propertyName) ' + @CRLF +
 CHAR(9) + CHAR(9) + '{ ' + @CRLF +
 CHAR(9) + CHAR(9) + ' System.Diagnostics.Debug.WriteLine("' + @TableName + ' property changed: " + propertyName); ' + @CRLF +
 CHAR(9) + CHAR(9) + '}';

SET @result = 'using System;' + @CRLF + @CRLF +
 'using MyCompany.Business;' + @CRLF + @CRLF +
 'namespace ' + @Namespace + @CRLF + '{' + @CRLF +
 ' public class ' + @TableName + ' : ObservableObject' + @CRLF + 
 ' {' + @CRLF +
 ' #region Instance Properties' + @CRLF 

SELECT @result = @result
 + 
 REPLACE(
 REPLACE(@PrivateProp
 , '&lt;ColumnName&gt;', ColumnName)
 , '&lt;ColumnType&gt;', ColumnType)
 + 
 REPLACE(
 REPLACE(@PublicProp
 , '&lt;ColumnName&gt;', ColumnName)
 , '&lt;ColumnType&gt;', ColumnType) 
FROM
(
 SELECT c.COLUMN_NAME AS ColumnName 
 , CASE c.DATA_TYPE 
 WHEN 'bigint' THEN
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'Int64?' ELSE 'Int64' END
 WHEN 'binary' THEN 'Byte[]'
 WHEN 'bit' THEN 
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'Boolean?' ELSE 'Boolean' END 
 WHEN 'char' THEN 'String'
 WHEN 'date' THEN
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END 
 WHEN 'datetime' THEN
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END 
 WHEN 'datetime2' THEN 
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END 
 WHEN 'datetimeoffset' THEN 
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'DateTimeOffset?' ELSE 'DateTimeOffset' END 
 WHEN 'decimal' THEN 
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'Decimal?' ELSE 'Decimal' END 
 WHEN 'float' THEN 
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'Single?' ELSE 'Single' END 
 WHEN 'image' THEN 'Byte[]'
 WHEN 'int' THEN 
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'Int32?' ELSE 'Int32' END
 WHEN 'money' THEN
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'Decimal?' ELSE 'Decimal' END 
 WHEN 'nchar' THEN 'String'
 WHEN 'ntext' THEN 'String'
 WHEN 'numeric' THEN
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'Decimal?' ELSE 'Decimal' END 
 WHEN 'nvarchar' THEN 'String'
 WHEN 'real' THEN 
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'Double?' ELSE 'Double' END 
 WHEN 'smalldatetime' THEN 
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END 
 WHEN 'smallint' THEN 
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'Int16?' ELSE 'Int16'END 
 WHEN 'smallmoney' THEN 
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'Decimal?' ELSE 'Decimal' END 
 WHEN 'text' THEN 'String'
 WHEN 'time' THEN 
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'TimeSpan?' ELSE 'TimeSpan' END 
 WHEN 'timestamp' THEN 
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END 
 WHEN 'tinyint' THEN 
 CASE C.IS_NULLABLE
 WHEN 'YES' THEN 'Byte?' ELSE 'Byte' END 
 WHEN 'uniqueidentifier' THEN 'Guid'
 WHEN 'varbinary' THEN 'Byte[]'
 WHEN 'varchar' THEN 'String'
 ELSE 'Object'
 END AS ColumnType
 , c.ORDINAL_POSITION 
FROM INFORMATION_SCHEMA.COLUMNS c
WHERE c.TABLE_NAME = @TableName 
 AND ISNULL(@Schema, c.TABLE_SCHEMA) = c.TABLE_SCHEMA 
) t
ORDER BY t.ORDINAL_POSITION

SELECT @result = @result + @CRLF + 
 CHAR(9) + '#endregion Instance Properties' + @CRLF +
 --CHAR(9) + @RPCProc + @CRLF +
 CHAR(9) + @PropChanged + @CRLF +
 CHAR(9) + '}' + @CRLF +
 @CRLF + '}' 
--SELECT @result
PRINT @result
</code></pre>

The base class is based on Josh Smith's article here
From <a href="http://joshsmithonwpf.wordpress.com/2007/08/29/a-base-class-which-implements-inotifypropertychanged/" rel="nofollow">http://joshsmithonwpf.wordpress.com/2007/08/29/a-base-class-which-implements-inotifypropertychanged/</a>

I did rename the class to be called ObservableObject and also took advantage of a c# 5 feature using the CallerMemberName attribute

<pre><code>//From http://joshsmithonwpf.wordpress.com/2007/08/29/a-base-class-which-implements-inotifypropertychanged/
//
//Jana's change: Used c# 5 feature to bypass passing in the property name using [CallerMemberName] 
// protected void RaisePropertyChanged([CallerMemberName] string propertyName = "")

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Diagnostics;
using System.Reflection;
using System.Runtime.CompilerServices;

namespace MyCompany.Business
{

 /// &lt;summary&gt;
 /// Implements the INotifyPropertyChanged interface and 
 /// exposes a RaisePropertyChanged method for derived 
 /// classes to raise the PropertyChange event. The event 
 /// arguments created by this class are cached to prevent 
 /// managed heap fragmentation.
 /// &lt;/summary&gt;
 [Serializable]
 public abstract class ObservableObject : INotifyPropertyChanged
 {
 #region Data

 private static readonly Dictionary&lt;string, PropertyChangedEventArgs&gt; eventArgCache;
 private const string ERROR_MSG = "{0} is not a public property of {1}";

 #endregion // Data

 #region Constructors

 static ObservableObject()
 {
 eventArgCache = new Dictionary&lt;string, PropertyChangedEventArgs&gt;();
 }

 protected ObservableObject()
 {
 }

 #endregion // Constructors

 #region Public Members

 /// &lt;summary&gt;
 /// Raised when a public property of this object is set.
 /// &lt;/summary&gt;
 [field: NonSerialized]
 public event PropertyChangedEventHandler PropertyChanged;

 /// &lt;summary&gt;
 /// Returns an instance of PropertyChangedEventArgs for 
 /// the specified property name.
 /// &lt;/summary&gt;
 /// &lt;param name="propertyName"&gt;
 /// The name of the property to create event args for.
 /// &lt;/param&gt; 
 public static PropertyChangedEventArgs
 GetPropertyChangedEventArgs(string propertyName)
 {
 if (String.IsNullOrEmpty(propertyName))
 throw new ArgumentException(
 "propertyName cannot be null or empty.");

 PropertyChangedEventArgs args;

 // Get the event args from the cache, creating them
 // and adding to the cache if necessary.
 lock (typeof(ObservableObject))
 {
 bool isCached = eventArgCache.ContainsKey(propertyName);
 if (!isCached)
 {
 eventArgCache.Add(
 propertyName,
 new PropertyChangedEventArgs(propertyName));
 }

 args = eventArgCache[propertyName];
 }

 return args;
 }

 #endregion // Public Members

 #region Protected Members

 /// &lt;summary&gt;
 /// Derived classes can override this method to
 /// execute logic after a property is set. The 
 /// base implementation does nothing.
 /// &lt;/summary&gt;
 /// &lt;param name="propertyName"&gt;
 /// The property which was changed.
 /// &lt;/param&gt;
 protected virtual void AfterPropertyChanged(string propertyName)
 {
 }

 /// &lt;summary&gt;
 /// Attempts to raise the PropertyChanged event, and 
 /// invokes the virtual AfterPropertyChanged method, 
 /// regardless of whether the event was raised or not.
 /// &lt;/summary&gt;
 /// &lt;param name="propertyName"&gt;
 /// The property which was changed.
 /// &lt;/param&gt;
 protected void RaisePropertyChanged([CallerMemberName] string propertyName = "")
 {
 this.VerifyProperty(propertyName);

 PropertyChangedEventHandler handler = this.PropertyChanged;
 if (handler != null)
 {
 // Get the cached event args.
 PropertyChangedEventArgs args =
 GetPropertyChangedEventArgs(propertyName);

 // Raise the PropertyChanged event.
 handler(this, args);
 }

 this.AfterPropertyChanged(propertyName);
 }

 #endregion // Protected Members

 #region Private Helpers

 [Conditional("DEBUG")]
 private void VerifyProperty(string propertyName)
 {
 Type type = this.GetType();

 // Look for a public property with the specified name.
 PropertyInfo propInfo = type.GetProperty(propertyName);

 if (propInfo == null)
 {
 // The property could not be found,
 // so alert the developer of the problem.

 string msg = string.Format(
 ERROR_MSG,
 propertyName,
 type.FullName);

 Debug.Fail(msg);
 }
 }

 #endregion // Private Helpers
 }
}
</code></pre>

Here is the part that you guys are going to like some more. I built a Powershell script to generate for all the tables in a SQL database. It is based on a Powershell guru named Chad Miller's Invoke-SQLCmd2 cmdlet which can be downloaded from here:
<a href="http://gallery.technet.microsoft.com/ScriptCenter/7985b7ef-ed89-4dfd-b02a-433cc4e30894/" rel="nofollow">http://gallery.technet.microsoft.com/ScriptCenter/7985b7ef-ed89-4dfd-b02a-433cc4e30894/</a>

Once you have that cmdlet, the Powershell script to generate for all tables becomes simple (do substitute the variables with your specific values).

<pre><code>. C:\MyScripts\Invoke-Sqlcmd2.ps1

$serverInstance = "MySQLInstance"
$databaseName = "MyDb"
$generatorSQLFile = "C:\MyScripts\ModelGen.sql" 
$tableListSQL = "SELECT name FROM $databaseName.sys.tables"
$outputFolder = "C:\MyScripts\Output\"
$namespace = "MyCompany.Business"

$placeHolderSchema = "&amp;Schema"
$placeHolderTableName = "&amp;TableName"
$placeHolderNamespace = "&amp;Namespace"

#Get the list of tables in the database to generate c# models for
$tables = Invoke-Sqlcmd2 -ServerInstance $serverInstance -Database $databaseName -Query $tableListSQL -As DataRow -Verbose

foreach ($table in $tables)
{
 $table1 = $table[0]
 $outputFile = "$outputFolder\$table1.cs"


 #Replace variables with values (returns an array that we convert to a string to use as query)
 $generatorSQLFileWSubstitutions = (Get-Content $generatorSQLFile).
 Replace($placeHolderSchema,"dbo").
 Replace($placeHolderTableName, $table1).
 Replace($placeHolderNamespace, $namespace) | Out-String

 "Ouputing for $table1 to $outputFile"

 #The command generates .cs file content for model using "PRINT" statements which then gets written to verbose output (stream 4)
 # ...capture the verbose output and redirect to a file
 (Invoke-Sqlcmd2 -ServerInstance $serverInstance -Database $databaseName -Query $generatorSQLFileWSubstitutions -Verbose) 4&gt; $outputFile

}
</code></pre>

blocks|key|694893|text|最简单的方法是EF，反向工程。http://msdn.microsoft.com/en-US/data/jj593170|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|694894|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-US/data/jj593170^0|F|19|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

The simplest way is EF, Reverse Engineer. <a href="http://msdn.microsoft.com/en-US/data/jj593170" rel="nofollow">http://msdn.microsoft.com/en-US/data/jj593170</a>

blocks|key|911030|text|我喜欢用私有的本地成员和公共访问器/变更器来设置我的类。所以我已经修改了Alex上面的脚本，以便对任何感兴趣的人也这样做。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|911031|declare+@TableName+sysname+=+'TABLE_NAME'
declare+@result+varchar(max)+=+'public+class+'+%2B+@TableName+%2B+'
{'

SET+@result+=+@result+%2B+
'
++++public+'+%2B+@TableName+%2B+'()
++++{}
';

select+@result+=+@result+%2B+'
++++private+'+%2B+ColumnType+%2B+'+'+%2B+'+m_'+%2B+stuff(replace(ColumnName,+'_',+''),+1,+1,+lower(left(ColumnName,+1)))+%2B+';'
from
(
++++select+
++++++++replace(col.name,+'+',+'_')+ColumnName,
++++++++column_id,
++++++++case+typ.name+
++++++++++++when+'bigint'+then+'long'
++++++++++++when+'binary'+then+'byte[]'
++++++++++++when+'bit'+then+'bool'
++++++++++++when+'char'+then+'string'
++++++++++++when+'date'+then+'DateTime'
++++++++++++when+'datetime'+then+'DateTime'
++++++++++++when+'datetime2'+then+'DateTime'
++++++++++++when+'datetimeoffset'+then+'DateTimeOffset'
++++++++++++when+'decimal'+then+'decimal'
++++++++++++when+'float'+then+'float'
++++++++++++when+'image'+then+'byte[]'
++++++++++++when+'int'+then+'int'
++++++++++++when+'money'+then+'decimal'
++++++++++++when+'nchar'+then+'char'
++++++++++++when+'ntext'+then+'string'
++++++++++++when+'numeric'+then+'decimal'
++++++++++++when+'nvarchar'+then+'string'
++++++++++++when+'real'+then+'double'
++++++++++++when+'smalldatetime'+then+'DateTime'
++++++++++++when+'smallint'+then+'short'
++++++++++++when+'smallmoney'+then+'decimal'
++++++++++++when+'text'+then+'string'
++++++++++++when+'time'+then+'TimeSpan'
++++++++++++when+'timestamp'+then+'DateTime'
++++++++++++when+'tinyint'+then+'byte'
++++++++++++when+'uniqueidentifier'+then+'Guid'
++++++++++++when+'varbinary'+then+'byte[]'
++++++++++++when+'varchar'+then+'string'
++++++++++++else+'UNKNOWN_'+%2B+typ.name
++++++++end+ColumnType
++++from+sys.columns+col
++++++++join+sys.types+typ+on
++++++++++++col.system_type_id+=+typ.system_type_id+AND+col.user_type_id+=+typ.user_type_id
++++where+object_id+=+object_id(@TableName)
)+t
order+by+column_id

SET+@result+=+@result+%2B+'
'

select+@result+=+@result+%2B+'
++++public+'+%2B+ColumnType+%2B+'+'+%2B+ColumnName+%2B+'+{+get+{+return+m_'+%2B+stuff(replace(ColumnName,+'_',+''),+1,+1,+lower(left(ColumnName,+1)))+%2B+';}+set+{m_'+%2B+stuff(replace(ColumnName,+'_',+''),+1,+1,+lower(left(ColumnName,+1)))+%2B+'+=+value;}+}'+from
(
++++select+
++++++++replace(col.name,+'+',+'_')+ColumnName,
++++++++column_id,
++++++++case+typ.name+
++++++++++++when+'bigint'+then+'long'
++++++++++++when+'binary'+then+'byte[]'
++++++++++++when+'bit'+then+'bool'
++++++++++++when+'char'+then+'string'
++++++++++++when+'date'+then+'DateTime'
++++++++++++when+'datetime'+then+'DateTime'
++++++++++++when+'datetime2'+then+'DateTime'
++++++++++++when+'datetimeoffset'+then+'DateTimeOffset'
++++++++++++when+'decimal'+then+'decimal'
++++++++++++when+'float'+then+'float'
++++++++++++when+'image'+then+'byte[]'
++++++++++++when+'int'+then+'int'
++++++++++++when+'money'+then+'decimal'
++++++++++++when+'nchar'+then+'char'
++++++++++++when+'ntext'+then+'string'
++++++++++++when+'numeric'+then+'decimal'
++++++++++++when+'nvarchar'+then+'string'
++++++++++++when+'real'+then+'double'
++++++++++++when+'smalldatetime'+then+'DateTime'
++++++++++++when+'smallint'+then+'short'
++++++++++++when+'smallmoney'+then+'decimal'
++++++++++++when+'text'+then+'string'
++++++++++++when+'time'+then+'TimeSpan'
++++++++++++when+'timestamp'+then+'DateTime'
++++++++++++when+'tinyint'+then+'byte'
++++++++++++when+'uniqueidentifier'+then+'Guid'
++++++++++++when+'varbinary'+then+'byte[]'
++++++++++++when+'varchar'+then+'string'
++++++++++++else+'UNKNOWN_'+%2B+typ.name
++++++++end+ColumnType
++++from+sys.columns+col
++++++++join+sys.types+typ+on
++++++++++++col.system_type_id+=+typ.system_type_id+AND+col.user_type_id+=+typ.user_type_id
++++where+object_id+=+object_id(@TableName)
)+t
order+by+column_id

set+@result+=+@result++%2B+'
}'

print+@result|code-block|syntax|javascript|911032|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I like to setup my classes with private local members and public accessors / mutators.
So I've modified Alex's script above to do that as well for anyone that is intersted.

<pre><code>declare @TableName sysname = 'TABLE_NAME'
declare @result varchar(max) = 'public class ' + @TableName + '
{'

SET @result = @result + 
'
 public ' + @TableName + '()
 {}
';

select @result = @result + '
 private ' + ColumnType + ' ' + ' m_' + stuff(replace(ColumnName, '_', ''), 1, 1, lower(left(ColumnName, 1))) + ';'
from
(
 select 
 replace(col.name, ' ', '_') ColumnName,
 column_id,
 case typ.name 
 when 'bigint' then 'long'
 when 'binary' then 'byte[]'
 when 'bit' then 'bool'
 when 'char' then 'string'
 when 'date' then 'DateTime'
 when 'datetime' then 'DateTime'
 when 'datetime2' then 'DateTime'
 when 'datetimeoffset' then 'DateTimeOffset'
 when 'decimal' then 'decimal'
 when 'float' then 'float'
 when 'image' then 'byte[]'
 when 'int' then 'int'
 when 'money' then 'decimal'
 when 'nchar' then 'char'
 when 'ntext' then 'string'
 when 'numeric' then 'decimal'
 when 'nvarchar' then 'string'
 when 'real' then 'double'
 when 'smalldatetime' then 'DateTime'
 when 'smallint' then 'short'
 when 'smallmoney' then 'decimal'
 when 'text' then 'string'
 when 'time' then 'TimeSpan'
 when 'timestamp' then 'DateTime'
 when 'tinyint' then 'byte'
 when 'uniqueidentifier' then 'Guid'
 when 'varbinary' then 'byte[]'
 when 'varchar' then 'string'
 else 'UNKNOWN_' + typ.name
 end ColumnType
 from sys.columns col
 join sys.types typ on
 col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id
 where object_id = object_id(@TableName)
) t
order by column_id

SET @result = @result + '
'

select @result = @result + '
 public ' + ColumnType + ' ' + ColumnName + ' { get { return m_' + stuff(replace(ColumnName, '_', ''), 1, 1, lower(left(ColumnName, 1))) + ';} set {m_' + stuff(replace(ColumnName, '_', ''), 1, 1, lower(left(ColumnName, 1))) + ' = value;} }' from
(
 select 
 replace(col.name, ' ', '_') ColumnName,
 column_id,
 case typ.name 
 when 'bigint' then 'long'
 when 'binary' then 'byte[]'
 when 'bit' then 'bool'
 when 'char' then 'string'
 when 'date' then 'DateTime'
 when 'datetime' then 'DateTime'
 when 'datetime2' then 'DateTime'
 when 'datetimeoffset' then 'DateTimeOffset'
 when 'decimal' then 'decimal'
 when 'float' then 'float'
 when 'image' then 'byte[]'
 when 'int' then 'int'
 when 'money' then 'decimal'
 when 'nchar' then 'char'
 when 'ntext' then 'string'
 when 'numeric' then 'decimal'
 when 'nvarchar' then 'string'
 when 'real' then 'double'
 when 'smalldatetime' then 'DateTime'
 when 'smallint' then 'short'
 when 'smallmoney' then 'decimal'
 when 'text' then 'string'
 when 'time' then 'TimeSpan'
 when 'timestamp' then 'DateTime'
 when 'tinyint' then 'byte'
 when 'uniqueidentifier' then 'Guid'
 when 'varbinary' then 'byte[]'
 when 'varchar' then 'string'
 else 'UNKNOWN_' + typ.name
 end ColumnType
 from sys.columns col
 join sys.types typ on
 col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id
 where object_id = object_id(@TableName)
) t
order by column_id

set @result = @result + '
}'

print @result
</code></pre>

blocks|key|694984|text|对前面的解决方案做一点补充:只有在使用默认模式时，object_id(@TableName)才能工作。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|694985|(Select+id+from+sysobjects+where+name+=+@TableName)|code-block|syntax|javascript|694986|适用于任何架构，只要@tableName是唯一的。|694987|entityMap^0|P|L|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

A small addition to the solutions before:
<code>object_id(@TableName)</code> works only if you are in the default schema.

<pre><code>(Select id from sysobjects where name = @TableName)
</code></pre>

works in any schema provided @tableName is unique.

blocks|key|695040|text|要打印带有注释(摘要)的NULLABLE属性，请使用此命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|695041|这是对第一个答案的轻微修改|695042|declare+@TableName+sysname+=+'TableName'
declare+@result+varchar(max)+=+'public+class+'+%2B+@TableName+%2B+'
{'
select+@result+=+@result+
%2B+CASE+WHEN+ColumnDesc+IS+NOT+NULL+THEN+'
++++///+<summary>
++++///+'+%2B+ColumnDesc+%2B+'
++++///+</summary>'+ELSE+''+END
%2B+'
++++public+'+%2B+ColumnType+%2B+'+'+%2B+ColumnName+%2B+'+{+get;+set;+}'
from
(
++++select+
++++++++replace(col.name,+'+',+'_')+ColumnName,
++++++++column_id,
++++++++case+typ.name+
++++++++++++when+'bigint'+then+'long'
++++++++++++when+'binary'+then+'byte[]'
++++++++++++when+'bit'+then+'bool'
++++++++++++when+'char'+then+'String'
++++++++++++when+'date'+then+'DateTime'
++++++++++++when+'datetime'+then+'DateTime'
++++++++++++when+'datetime2'+then+'DateTime'
++++++++++++when+'datetimeoffset'+then+'DateTimeOffset'
++++++++++++when+'decimal'+then+'decimal'
++++++++++++when+'float'+then+'float'
++++++++++++when+'image'+then+'byte[]'
++++++++++++when+'int'+then+'int'
++++++++++++when+'money'+then+'decimal'
++++++++++++when+'nchar'+then+'char'
++++++++++++when+'ntext'+then+'string'
++++++++++++when+'numeric'+then+'decimal'
++++++++++++when+'nvarchar'+then+'String'
++++++++++++when+'real'+then+'double'
++++++++++++when+'smalldatetime'+then+'DateTime'
++++++++++++when+'smallint'+then+'short'
++++++++++++when+'smallmoney'+then+'decimal'
++++++++++++when+'text'+then+'String'
++++++++++++when+'time'+then+'TimeSpan'
++++++++++++when+'timestamp'+then+'DateTime'
++++++++++++when+'tinyint'+then+'byte'
++++++++++++when+'uniqueidentifier'+then+'Guid'
++++++++++++when+'varbinary'+then+'byte[]'
++++++++++++when+'varchar'+then+'string'
++++++++++++else+'UNKNOWN_'+%2B+typ.name
++++++++END+%2B+CASE+WHEN+col.is_nullable=1+AND+typ.name+NOT+IN+('binary',+'varbinary',+'image',+'text',+'ntext',+'varchar',+'nvarchar',+'char',+'nchar')+THEN+'?'+ELSE+''+END+ColumnType,
++++++++colDesc.colDesc+AS+ColumnDesc
++++from+sys.columns+col
++++++++join+sys.types+typ+on
++++++++++++col.system_type_id+=+typ.system_type_id+AND+col.user_type_id+=+typ.user_type_id
++++OUTER+APPLY+(
++++SELECT+TOP+1+CAST(value+AS+NVARCHAR(max))+AS+colDesc
++++FROM
+++++++sys.extended_properties
++++WHERE
+++++++major_id+=+col.object_id
+++++++AND
+++++++minor_id+=+COLUMNPROPERTY(major_id,+col.name,+'ColumnId')
++++)+colDesc++++++++++++
++++where+object_id+=+object_id(@TableName)
)+t
order+by+column_id

set+@result+=+@result++%2B+'
}'

print+@result|code-block|syntax|javascript|695043|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

To print out NULLABLE properties WITH COMMENTS (Summary), use this. 
It is a slight modification of first answer

<pre><code>declare @TableName sysname = 'TableName'
declare @result varchar(max) = 'public class ' + @TableName + '
{'
select @result = @result 
+ CASE WHEN ColumnDesc IS NOT NULL THEN '
 /// &lt;summary&gt;
 /// ' + ColumnDesc + '
 /// &lt;/summary&gt;' ELSE '' END
+ '
 public ' + ColumnType + ' ' + ColumnName + ' { get; set; }'
from
(
 select 
 replace(col.name, ' ', '_') ColumnName,
 column_id,
 case typ.name 
 when 'bigint' then 'long'
 when 'binary' then 'byte[]'
 when 'bit' then 'bool'
 when 'char' then 'String'
 when 'date' then 'DateTime'
 when 'datetime' then 'DateTime'
 when 'datetime2' then 'DateTime'
 when 'datetimeoffset' then 'DateTimeOffset'
 when 'decimal' then 'decimal'
 when 'float' then 'float'
 when 'image' then 'byte[]'
 when 'int' then 'int'
 when 'money' then 'decimal'
 when 'nchar' then 'char'
 when 'ntext' then 'string'
 when 'numeric' then 'decimal'
 when 'nvarchar' then 'String'
 when 'real' then 'double'
 when 'smalldatetime' then 'DateTime'
 when 'smallint' then 'short'
 when 'smallmoney' then 'decimal'
 when 'text' then 'String'
 when 'time' then 'TimeSpan'
 when 'timestamp' then 'DateTime'
 when 'tinyint' then 'byte'
 when 'uniqueidentifier' then 'Guid'
 when 'varbinary' then 'byte[]'
 when 'varchar' then 'string'
 else 'UNKNOWN_' + typ.name
 END + CASE WHEN col.is_nullable=1 AND typ.name NOT IN ('binary', 'varbinary', 'image', 'text', 'ntext', 'varchar', 'nvarchar', 'char', 'nchar') THEN '?' ELSE '' END ColumnType,
 colDesc.colDesc AS ColumnDesc
 from sys.columns col
 join sys.types typ on
 col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id
 OUTER APPLY (
 SELECT TOP 1 CAST(value AS NVARCHAR(max)) AS colDesc
 FROM
 sys.extended_properties
 WHERE
 major_id = col.object_id
 AND
 minor_id = COLUMNPROPERTY(major_id, col.name, 'ColumnId')
 ) colDesc 
 where object_id = object_id(@TableName)
) t
order by column_id

set @result = @result + '
}'

print @result
</code></pre>

blocks|key|695104|text|Visual+Studio杂志发表了这篇文章：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|695105|Generating+.NET+POCO+Classes+for+SQL+Query+Results|offset|length|695106|它有一个可下载的项目，你可以构建它，给它你的SQL信息，它会为你创建这个类。|695107|现在，如果该工具刚刚创建了用于SELECT、INSERT和UPDATE的SQL命令...|695108|entityMap|0|LINK|mutability|MUTABLE|url|https://visualstudiomagazine.com/articles/2012/12/11/sqlqueryresults-code-generation.aspx^0|0|0|1E|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

Visual Studio Magazine published this:

<a href="https://visualstudiomagazine.com/articles/2012/12/11/sqlqueryresults-code-generation.aspx" rel="nofollow">Generating .NET POCO Classes for SQL Query Results</a>

It has a downloadable project that you can build, give it your SQL info, and it will crank out the class for you.

Now if that tool just created the SQL Commands for SELECT, INSERT, and UPDATE....

blocks|key|695181|text|Grab+QueryFirst，从SQL查询生成包装类的visual+studio扩展。你不仅会得到..。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|695182|public+class+MyClass{
++++public+string+MyProp{get;set;}
++++public+int+MyNumberProp{get;set;}
++++...
}|code-block|syntax|javascript|695183|作为额外的奖励，它会投入..。|695184|public+class+MyQuery{
++++public+static+IEnumerable<MyClass>Execute(){}
++++public+static+MyClass+GetOne(){}
++++...
}|695185|您确定要将类直接基于表吗？表是一种静态的、规范化的数据存储概念，属于数据库。类是动态的、流动的、可处理的、特定于上下文的，也许是非规范化的。为什么不为操作所需的数据编写真正的查询，并让QueryFirst从中生成类呢？|695186|entityMap|0|LINK|mutability|MUTABLE|url|https://visualstudiogallery.msdn.microsoft.com/eaf390af-afc1-4994-a442-ec95923dafcb^0|5|A|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|11|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|12|8|@]|9|@]|C|$G|H]]|$1|M|3|N|5|6|7|13|8|@]|9|@]|C|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]]]

Grab <a href="https://visualstudiogallery.msdn.microsoft.com/eaf390af-afc1-4994-a442-ec95923dafcb" rel="nofollow">QueryFirst</a>, visual studio extension that generates wrapper classes from SQL queries. You not only get...

<pre><code>public class MyClass{
 public string MyProp{get;set;}
 public int MyNumberProp{get;set;}
 ...
}
</code></pre>

And as a bonus, it'll throw in...

<pre><code>public class MyQuery{
 public static IEnumerable&lt;MyClass&gt;Execute(){}
 public static MyClass GetOne(){}
 ...
}
</code></pre>

Are you sure you want to base your classes directly on your tables? Tables are a static, normalized data storage notion that belongs in the DB. Classes are dynamic, fluid, disposable, context-specific, perhaps denormalized. Why not write real queries for the data you want for an operation, and let QueryFirst generate the classes from that.

blocks|key|695286|text|这篇文章救了我好几次。我只想补充我的两点意见。对于那些不喜欢使用ORM，而是编写自己的DAL类的人来说，当一个表中有20列，40个不同的表以及它们各自的CRUD操作时，这是痛苦和浪费时间的。我重复了上面的代码，用于根据表实体和属性生成CRUD方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|695287|+declare+@TableName+sysname+=+'Tablename'
declare+@Result+varchar(max)+=+'public+class+'+%2B+@TableName+%2B+'
{'

select+@Result+=+@Result+%2B+'
++++public+'+%2B+ColumnType+%2B+NullableSign+%2B+'+'+%2B+ColumnName+%2B+'+{+get;+set;+}
'
from
(
++++select+
++++++++replace(col.name,+'+',+'_')+ColumnName,
++++++++column_id+ColumnId,
++++++++case+typ.name+
++++++++++++when+'bigint'+then+'long'
++++++++++++when+'binary'+then+'byte[]'
++++++++++++when+'bit'+then+'bool'
++++++++++++when+'char'+then+'string'
++++++++++++when+'date'+then+'DateTime'
++++++++++++when+'datetime'+then+'DateTime'
++++++++++++when+'datetime2'+then+'DateTime'
++++++++++++when+'datetimeoffset'+then+'DateTimeOffset'
++++++++++++when+'decimal'+then+'decimal'
++++++++++++when+'float'+then+'float'
++++++++++++when+'image'+then+'byte[]'
++++++++++++when+'int'+then+'int'
++++++++++++when+'money'+then+'decimal'
++++++++++++when+'nchar'+then+'char'
++++++++++++when+'ntext'+then+'string'
++++++++++++when+'numeric'+then+'decimal'
++++++++++++when+'nvarchar'+then+'string'
++++++++++++when+'real'+then+'double'
++++++++++++when+'smalldatetime'+then+'DateTime'
++++++++++++when+'smallint'+then+'short'
++++++++++++when+'smallmoney'+then+'decimal'
++++++++++++when+'text'+then+'string'
++++++++++++when+'time'+then+'TimeSpan'
++++++++++++when+'timestamp'+then+'DateTime'
++++++++++++when+'tinyint'+then+'byte'
++++++++++++when+'uniqueidentifier'+then+'Guid'
++++++++++++when+'varbinary'+then+'byte[]'
++++++++++++when+'varchar'+then+'string'
++++++++++++else+'UNKNOWN_'+%2B+typ.name
++++++++end+ColumnType,
++++++++case+
++++++++++++when+col.is_nullable+=+1+and+typ.name+in+('bigint',+'bit',+'date',+'datetime',+'datetime2',+'datetimeoffset',+'decimal',+'float',+'int',+'money',+'numeric',+'real',+'smalldatetime',+'smallint',+'smallmoney',+'time',+'tinyint',+'uniqueidentifier')+
++++++++++++then+'?'+
++++++++++++else+''+
++++++++end+NullableSign
++++from+sys.columns+col
++++++++join+sys.types+typ+on
++++++++++++col.system_type_id+=+typ.system_type_id+AND+col.user_type_id+=+typ.user_type_id
++++where+object_id+=+object_id(@TableName)
)+t
order+by+ColumnId

set+@Result+=+@Result++%2B+'
}'

print+@Result

declare+@InitDataAccess+varchar(max)+=+'public+class+'%2B+@TableName+%2B'DataAccess+
{+'

declare+@ListStatement+varchar(max)+='public+List<'%2B@TableName%2B'>+Get'%2B@TableName%2B'List()
{
+String+conn+=+ConfigurationManager.ConnectionStrings["ConnectionNameInWeb.config"].ConnectionString;
+var+itemList+=+new+List<'%2B@TableName%2B'>();
++++++++++try
++++++++++++{
++++++++++++++++using+(var+sqlCon+=+new+SqlConnection(conn))
++++++++++++++++{
++++++++++++++++++++sqlCon.Open();
++++++++++++++++++++var+cmd+=+new+SqlCommand
++++++++++++++++++++{
++++++++++++++++++++++++Connection+=+sqlCon,
++++++++++++++++++++++++CommandType+=+CommandType.StoredProcedure,
++++++++++++++++++++++++CommandText+=+"StoredProcedureSelectAll"
++++++++++++++++++++};
++++++++++++++++++++SqlDataReader+reader+=+cmd.ExecuteReader();
++++++++++++++++++++while+(reader.Read())
++++++++++++++++++++{
++++++++++++++++++++++var+item+=+new+'%2B@TableName%2B'();
'+
select+@ListStatement+=+@ListStatement+%2B+'
item.'%2B+ColumnName+%2B+'=+('%2B+ColumnType+%2B+NullableSign++%2B')reader["'%2BColumnName%2B'"];
'
from
(
++++select+
++++++++replace(col.name,+'+',+'_')+ColumnName,
++++++++column_id+ColumnId,
++++++++case+typ.name+
++++++++++++when+'bigint'+then+'long'
++++++++++++when+'binary'+then+'byte[]'
++++++++++++when+'bit'+then+'bool'
++++++++++++when+'char'+then+'string'
++++++++++++when+'date'+then+'DateTime'
++++++++++++when+'datetime'+then+'DateTime'
++++++++++++when+'datetime2'+then+'DateTime'
++++++++++++when+'datetimeoffset'+then+'DateTimeOffset'
++++++++++++when+'decimal'+then+'decimal'
++++++++++++when+'float'+then+'float'
++++++++++++when+'image'+then+'byte[]'
++++++++++++when+'int'+then+'int'
++++++++++++when+'money'+then+'decimal'
++++++++++++when+'nchar'+then+'char'
++++++++++++when+'ntext'+then+'string'
++++++++++++when+'numeric'+then+'decimal'
++++++++++++when+'nvarchar'+then+'string'
++++++++++++when+'real'+then+'double'
++++++++++++when+'smalldatetime'+then+'DateTime'
++++++++++++when+'smallint'+then+'short'
++++++++++++when+'smallmoney'+then+'decimal'
++++++++++++when+'text'+then+'string'
++++++++++++when+'time'+then+'TimeSpan'
++++++++++++when+'timestamp'+then+'DateTime'
++++++++++++when+'tinyint'+then+'byte'
++++++++++++when+'uniqueidentifier'+then+'Guid'
++++++++++++when+'varbinary'+then+'byte[]'
++++++++++++when+'varchar'+then+'string'
++++++++++++else+'UNKNOWN_'+%2B+typ.name
++++++++end+ColumnType,
++++++++case+
++++++++++++when+col.is_nullable+=+1+and+typ.name+in+('bigint',+'bit',+'date',+'datetime',+'datetime2',+'datetimeoffset',+'decimal',+'float',+'int',+'money',+'numeric',+'real',+'smalldatetime',+'smallint',+'smallmoney',+'time',+'tinyint',+'uniqueidentifier')+
++++++++++++then+'?'+
++++++++++++else+''+
++++++++end+NullableSign
++++from+sys.columns+col
++++++++join+sys.types+typ+on
++++++++++++col.system_type_id+=+typ.system_type_id+AND+col.user_type_id+=+typ.user_type_id
++++where+object_id+=+object_id(@TableName)
)+t
order+by+ColumnId

select+@ListStatement+=+@ListStatement+%2B'
++++++++++++++++++++++++itemList.Add(item);
++++++++++++++++++++}

++++++++++++++++}
++++++++++++}
++++++++++++catch+(Exception+ex)
++++++++++++{
++++++++++++++++throw+new+Exception(ex.Message);
++++++++++++}
++++++++++++return+itemList;
++++++++}'

declare+@GetIndividual+varchar(max)+=++
'public+'%2B@TableName%2B'+Get'%2B@TableName%2B'()
{
+String+conn+=+ConfigurationManager.ConnectionStrings["ConnectionNameInWeb.config"].ConnectionString;
+var+item+=+new+'%2B@TableName%2B'();
++++++++++try
++++++++++++{
++++++++++++++++using+(var+sqlCon+=+new+SqlConnection(conn))
++++++++++++++++{
++++++++++++++++++++sqlCon.Open();
++++++++++++++++++++var+cmd+=+new+SqlCommand
++++++++++++++++++++{
++++++++++++++++++++++++Connection+=+sqlCon,
++++++++++++++++++++++++CommandType+=+CommandType.StoredProcedure,
++++++++++++++++++++++++CommandText+=+"StoredProcedureSelectIndividual"
++++++++++++++++++++};
+++++++++++++++++++++cmd.Parameters.AddWithValue("@ItemCriteria",+item.id);
++++++++++++++++++++SqlDataReader+reader+=+cmd.ExecuteReader();
++++++++++++++++++++if+(reader.Read())
++++++++++++++++++++{'+
select+@GetIndividual+=+@GetIndividual+%2B+'
item.'%2B+ColumnName+%2B+'=+('%2B+ColumnType+%2B+NullableSign++%2B')reader["'%2BColumnName%2B'"];
'
from
(
++++select+
++++++++replace(col.name,+'+',+'_')+ColumnName,
++++++++column_id+ColumnId,
++++++++case+typ.name+
++++++++++++when+'bigint'+then+'long'
++++++++++++when+'binary'+then+'byte[]'
++++++++++++when+'bit'+then+'bool'
++++++++++++when+'char'+then+'string'
++++++++++++when+'date'+then+'DateTime'
++++++++++++when+'datetime'+then+'DateTime'
++++++++++++when+'datetime2'+then+'DateTime'
++++++++++++when+'datetimeoffset'+then+'DateTimeOffset'
++++++++++++when+'decimal'+then+'decimal'
++++++++++++when+'float'+then+'float'
++++++++++++when+'image'+then+'byte[]'
++++++++++++when+'int'+then+'int'
++++++++++++when+'money'+then+'decimal'
++++++++++++when+'nchar'+then+'char'
++++++++++++when+'ntext'+then+'string'
++++++++++++when+'numeric'+then+'decimal'
++++++++++++when+'nvarchar'+then+'string'
++++++++++++when+'real'+then+'double'
++++++++++++when+'smalldatetime'+then+'DateTime'
++++++++++++when+'smallint'+then+'short'
++++++++++++when+'smallmoney'+then+'decimal'
++++++++++++when+'text'+then+'string'
++++++++++++when+'time'+then+'TimeSpan'
++++++++++++when+'timestamp'+then+'DateTime'
++++++++++++when+'tinyint'+then+'byte'
++++++++++++when+'uniqueidentifier'+then+'Guid'
++++++++++++when+'varbinary'+then+'byte[]'
++++++++++++when+'varchar'+then+'string'
++++++++++++else+'UNKNOWN_'+%2B+typ.name
++++++++end+ColumnType,
++++++++case+
++++++++++++when+col.is_nullable+=+1+and+typ.name+in+('bigint',+'bit',+'date',+'datetime',+'datetime2',+'datetimeoffset',+'decimal',+'float',+'int',+'money',+'numeric',+'real',+'smalldatetime',+'smallint',+'smallmoney',+'time',+'tinyint',+'uniqueidentifier')+
++++++++++++then+'?'+
++++++++++++else+''+
++++++++end+NullableSign
++++from+sys.columns+col
++++++++join+sys.types+typ+on
++++++++++++col.system_type_id+=+typ.system_type_id+AND+col.user_type_id+=+typ.user_type_id
++++where+object_id+=+object_id(@TableName)
)+t
order+by+ColumnId

select+@GetIndividual+=+@GetIndividual+%2B'

++++++++++++++++++++}

++++++++++++++++}
++++++++++++}
++++++++++++catch+(Exception+ex)
++++++++++++{
++++++++++++++++throw+new+Exception(ex.Message);
++++++++++++}
++++++++++++return+item;
++++++++}'



declare+@InsertStatement+varchar(max)+=+'public+void++Insert'%2B@TableName%2B'('%2B@TableName%2B'+item)
{
+String+conn+=+ConfigurationManager.ConnectionStrings["ConnectionNameInWeb.config"].ConnectionString;

++++++++++try
++++++++++++{
++++++++++++++++using+(var+sqlCon+=+new+SqlConnection(conn))
++++++++++++++++{
++++++++++++++++++++sqlCon.Open();
++++++++++++++++++++var+cmd+=+new+SqlCommand
++++++++++++++++++++{
++++++++++++++++++++++++Connection+=+sqlCon,
++++++++++++++++++++++++CommandType+=+CommandType.StoredProcedure,
++++++++++++++++++++++++CommandText+=+"StoredProcedureInsert"
++++++++++++++++++++};

++++++++++++++++++++'+
select+@InsertStatement+=+@InsertStatement+%2B+'
+cmd.Parameters.AddWithValue("@'%2BColumnName%2B'",+item.'%2BColumnName%2B');
'
from
(
++++select+
++++++++replace(col.name,+'+',+'_')+ColumnName,
++++++++column_id+ColumnId,
++++++++case+typ.name+
++++++++++++when+'bigint'+then+'long'
++++++++++++when+'binary'+then+'byte[]'
++++++++++++when+'bit'+then+'bool'
++++++++++++when+'char'+then+'string'
++++++++++++when+'date'+then+'DateTime'
++++++++++++when+'datetime'+then+'DateTime'
++++++++++++when+'datetime2'+then+'DateTime'
++++++++++++when+'datetimeoffset'+then+'DateTimeOffset'
++++++++++++when+'decimal'+then+'decimal'
++++++++++++when+'float'+then+'float'
++++++++++++when+'image'+then+'byte[]'
++++++++++++when+'int'+then+'int'
++++++++++++when+'money'+then+'decimal'
++++++++++++when+'nchar'+then+'char'
++++++++++++when+'ntext'+then+'string'
++++++++++++when+'numeric'+then+'decimal'
++++++++++++when+'nvarchar'+then+'string'
++++++++++++when+'real'+then+'double'
++++++++++++when+'smalldatetime'+then+'DateTime'
++++++++++++when+'smallint'+then+'short'
++++++++++++when+'smallmoney'+then+'decimal'
++++++++++++when+'text'+then+'string'
++++++++++++when+'time'+then+'TimeSpan'
++++++++++++when+'timestamp'+then+'DateTime'
++++++++++++when+'tinyint'+then+'byte'
++++++++++++when+'uniqueidentifier'+then+'Guid'
++++++++++++when+'varbinary'+then+'byte[]'
++++++++++++when+'varchar'+then+'string'
++++++++++++else+'UNKNOWN_'+%2B+typ.name
++++++++end+ColumnType,
++++++++case+
++++++++++++when+col.is_nullable+=+1+and+typ.name+in+('bigint',+'bit',+'date',+'datetime',+'datetime2',+'datetimeoffset',+'decimal',+'float',+'int',+'money',+'numeric',+'real',+'smalldatetime',+'smallint',+'smallmoney',+'time',+'tinyint',+'uniqueidentifier')+
++++++++++++then+'?'+
++++++++++++else+''+
++++++++end+NullableSign
++++from+sys.columns+col
++++++++join+sys.types+typ+on
++++++++++++col.system_type_id+=+typ.system_type_id+AND+col.user_type_id+=+typ.user_type_id
++++where+object_id+=+object_id(@TableName)
)+t
order+by+ColumnId

select+@InsertStatement+=+@InsertStatement+%2B'

++++++++++++++++++++cmd.ExecuteNonQuery();

++++++++++++++++}
++++++++++++}
++++++++++++catch+(Exception+ex)
++++++++++++{
++++++++++++++++throw+new+Exception(ex.Message);
++++++++++++}

++++++++}'

declare+@UpdateStatement+varchar(max)+=+'public+void++Update'%2B@TableName%2B'('%2B@TableName%2B'+item)
{
+String+conn+=+ConfigurationManager.ConnectionStrings["ConnectionNameInWeb.config"].ConnectionString;

++++++++++try
++++++++++++{
++++++++++++++++using+(var+sqlCon+=+new+SqlConnection(conn))
++++++++++++++++{
++++++++++++++++++++sqlCon.Open();
++++++++++++++++++++var+cmd+=+new+SqlCommand
++++++++++++++++++++{
++++++++++++++++++++++++Connection+=+sqlCon,
++++++++++++++++++++++++CommandType+=+CommandType.StoredProcedure,
++++++++++++++++++++++++CommandText+=+"StoredProcedureUpdate"
++++++++++++++++++++};
++++++++++++++++++++cmd.Parameters.AddWithValue("@UpdateCriteria",+item.Id);
++++++++++++++++++++'+
select+@UpdateStatement+=+@UpdateStatement+%2B+'
+cmd.Parameters.AddWithValue("@'%2BColumnName%2B'",+item.'%2BColumnName%2B');
'
from
(
++++select+
++++++++replace(col.name,+'+',+'_')+ColumnName,
++++++++column_id+ColumnId,
++++++++case+typ.name+
++++++++++++when+'bigint'+then+'long'
++++++++++++when+'binary'+then+'byte[]'
++++++++++++when+'bit'+then+'bool'
++++++++++++when+'char'+then+'string'
++++++++++++when+'date'+then+'DateTime'
++++++++++++when+'datetime'+then+'DateTime'
++++++++++++when+'datetime2'+then+'DateTime'
++++++++++++when+'datetimeoffset'+then+'DateTimeOffset'
++++++++++++when+'decimal'+then+'decimal'
++++++++++++when+'float'+then+'float'
++++++++++++when+'image'+then+'byte[]'
++++++++++++when+'int'+then+'int'
++++++++++++when+'money'+then+'decimal'
++++++++++++when+'nchar'+then+'char'
++++++++++++when+'ntext'+then+'string'
++++++++++++when+'numeric'+then+'decimal'
++++++++++++when+'nvarchar'+then+'string'
++++++++++++when+'real'+then+'double'
++++++++++++when+'smalldatetime'+then+'DateTime'
++++++++++++when+'smallint'+then+'short'
++++++++++++when+'smallmoney'+then+'decimal'
++++++++++++when+'text'+then+'string'
++++++++++++when+'time'+then+'TimeSpan'
++++++++++++when+'timestamp'+then+'DateTime'
++++++++++++when+'tinyint'+then+'byte'
++++++++++++when+'uniqueidentifier'+then+'Guid'
++++++++++++when+'varbinary'+then+'byte[]'
++++++++++++when+'varchar'+then+'string'
++++++++++++else+'UNKNOWN_'+%2B+typ.name
++++++++end+ColumnType,
++++++++case+
++++++++++++when+col.is_nullable+=+1+and+typ.name+in+('bigint',+'bit',+'date',+'datetime',+'datetime2',+'datetimeoffset',+'decimal',+'float',+'int',+'money',+'numeric',+'real',+'smalldatetime',+'smallint',+'smallmoney',+'time',+'tinyint',+'uniqueidentifier')+
++++++++++++then+'?'+
++++++++++++else+''+
++++++++end+NullableSign
++++from+sys.columns+col
++++++++join+sys.types+typ+on
++++++++++++col.system_type_id+=+typ.system_type_id+AND+col.user_type_id+=+typ.user_type_id
++++where+object_id+=+object_id(@TableName)
)+t
order+by+ColumnId

select+@UpdateStatement+=+@UpdateStatement+%2B'

++++++++++++++++++++cmd.ExecuteNonQuery();

++++++++++++++++}
++++++++++++}
++++++++++++catch+(Exception+ex)
++++++++++++{
++++++++++++++++throw+new+Exception(ex.Message);
++++++++++++}

++++++++}'

declare+@EndDataAccess+varchar(max)++=+'
}'
+print+@InitDataAccess
+print+@GetIndividual
print+@InsertStatement
print+@UpdateStatement
print+@ListStatement
print+@EndDataAccess|code-block|syntax|javascript|695288|当然，它不是防弹代码，可以改进。我只想为这个卓越的解决方案做出贡献|695289|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This post has saved me several times. I just want to add my two cents.
For those that dont like to use ORMs, and instead write their own DAL classes, when you have like 20 columns in a table, and 40 different tables with their respective CRUD operations, its painful and a waste of time. I repeated the above code, for generating CRUD methods based on the table entity and properties.

<pre><code> declare @TableName sysname = 'Tablename'
declare @Result varchar(max) = 'public class ' + @TableName + '
{'

select @Result = @Result + '
 public ' + ColumnType + NullableSign + ' ' + ColumnName + ' { get; set; }
'
from
(
 select 
 replace(col.name, ' ', '_') ColumnName,
 column_id ColumnId,
 case typ.name 
 when 'bigint' then 'long'
 when 'binary' then 'byte[]'
 when 'bit' then 'bool'
 when 'char' then 'string'
 when 'date' then 'DateTime'
 when 'datetime' then 'DateTime'
 when 'datetime2' then 'DateTime'
 when 'datetimeoffset' then 'DateTimeOffset'
 when 'decimal' then 'decimal'
 when 'float' then 'float'
 when 'image' then 'byte[]'
 when 'int' then 'int'
 when 'money' then 'decimal'
 when 'nchar' then 'char'
 when 'ntext' then 'string'
 when 'numeric' then 'decimal'
 when 'nvarchar' then 'string'
 when 'real' then 'double'
 when 'smalldatetime' then 'DateTime'
 when 'smallint' then 'short'
 when 'smallmoney' then 'decimal'
 when 'text' then 'string'
 when 'time' then 'TimeSpan'
 when 'timestamp' then 'DateTime'
 when 'tinyint' then 'byte'
 when 'uniqueidentifier' then 'Guid'
 when 'varbinary' then 'byte[]'
 when 'varchar' then 'string'
 else 'UNKNOWN_' + typ.name
 end ColumnType,
 case 
 when col.is_nullable = 1 and typ.name in ('bigint', 'bit', 'date', 'datetime', 'datetime2', 'datetimeoffset', 'decimal', 'float', 'int', 'money', 'numeric', 'real', 'smalldatetime', 'smallint', 'smallmoney', 'time', 'tinyint', 'uniqueidentifier') 
 then '?' 
 else '' 
 end NullableSign
 from sys.columns col
 join sys.types typ on
 col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id
 where object_id = object_id(@TableName)
) t
order by ColumnId

set @Result = @Result + '
}'

print @Result

declare @InitDataAccess varchar(max) = 'public class '+ @TableName +'DataAccess 
{ '

declare @ListStatement varchar(max) ='public List&lt;'+@TableName+'&gt; Get'+@TableName+'List()
{
 String conn = ConfigurationManager.ConnectionStrings["ConnectionNameInWeb.config"].ConnectionString;
 var itemList = new List&lt;'+@TableName+'&gt;();
 try
 {
 using (var sqlCon = new SqlConnection(conn))
 {
 sqlCon.Open();
 var cmd = new SqlCommand
 {
 Connection = sqlCon,
 CommandType = CommandType.StoredProcedure,
 CommandText = "StoredProcedureSelectAll"
 };
 SqlDataReader reader = cmd.ExecuteReader();
 while (reader.Read())
 {
 var item = new '+@TableName+'();
' 
select @ListStatement = @ListStatement + '
item.'+ ColumnName + '= ('+ ColumnType + NullableSign +')reader["'+ColumnName+'"];
'
from
(
 select 
 replace(col.name, ' ', '_') ColumnName,
 column_id ColumnId,
 case typ.name 
 when 'bigint' then 'long'
 when 'binary' then 'byte[]'
 when 'bit' then 'bool'
 when 'char' then 'string'
 when 'date' then 'DateTime'
 when 'datetime' then 'DateTime'
 when 'datetime2' then 'DateTime'
 when 'datetimeoffset' then 'DateTimeOffset'
 when 'decimal' then 'decimal'
 when 'float' then 'float'
 when 'image' then 'byte[]'
 when 'int' then 'int'
 when 'money' then 'decimal'
 when 'nchar' then 'char'
 when 'ntext' then 'string'
 when 'numeric' then 'decimal'
 when 'nvarchar' then 'string'
 when 'real' then 'double'
 when 'smalldatetime' then 'DateTime'
 when 'smallint' then 'short'
 when 'smallmoney' then 'decimal'
 when 'text' then 'string'
 when 'time' then 'TimeSpan'
 when 'timestamp' then 'DateTime'
 when 'tinyint' then 'byte'
 when 'uniqueidentifier' then 'Guid'
 when 'varbinary' then 'byte[]'
 when 'varchar' then 'string'
 else 'UNKNOWN_' + typ.name
 end ColumnType,
 case 
 when col.is_nullable = 1 and typ.name in ('bigint', 'bit', 'date', 'datetime', 'datetime2', 'datetimeoffset', 'decimal', 'float', 'int', 'money', 'numeric', 'real', 'smalldatetime', 'smallint', 'smallmoney', 'time', 'tinyint', 'uniqueidentifier') 
 then '?' 
 else '' 
 end NullableSign
 from sys.columns col
 join sys.types typ on
 col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id
 where object_id = object_id(@TableName)
) t
order by ColumnId

select @ListStatement = @ListStatement +'
 itemList.Add(item);
 }

 }
 }
 catch (Exception ex)
 {
 throw new Exception(ex.Message);
 }
 return itemList;
 }'

declare @GetIndividual varchar(max) = 
'public '+@TableName+' Get'+@TableName+'()
{
 String conn = ConfigurationManager.ConnectionStrings["ConnectionNameInWeb.config"].ConnectionString;
 var item = new '+@TableName+'();
 try
 {
 using (var sqlCon = new SqlConnection(conn))
 {
 sqlCon.Open();
 var cmd = new SqlCommand
 {
 Connection = sqlCon,
 CommandType = CommandType.StoredProcedure,
 CommandText = "StoredProcedureSelectIndividual"
 };
 cmd.Parameters.AddWithValue("@ItemCriteria", item.id);
 SqlDataReader reader = cmd.ExecuteReader();
 if (reader.Read())
 {' 
select @GetIndividual = @GetIndividual + '
item.'+ ColumnName + '= ('+ ColumnType + NullableSign +')reader["'+ColumnName+'"];
'
from
(
 select 
 replace(col.name, ' ', '_') ColumnName,
 column_id ColumnId,
 case typ.name 
 when 'bigint' then 'long'
 when 'binary' then 'byte[]'
 when 'bit' then 'bool'
 when 'char' then 'string'
 when 'date' then 'DateTime'
 when 'datetime' then 'DateTime'
 when 'datetime2' then 'DateTime'
 when 'datetimeoffset' then 'DateTimeOffset'
 when 'decimal' then 'decimal'
 when 'float' then 'float'
 when 'image' then 'byte[]'
 when 'int' then 'int'
 when 'money' then 'decimal'
 when 'nchar' then 'char'
 when 'ntext' then 'string'
 when 'numeric' then 'decimal'
 when 'nvarchar' then 'string'
 when 'real' then 'double'
 when 'smalldatetime' then 'DateTime'
 when 'smallint' then 'short'
 when 'smallmoney' then 'decimal'
 when 'text' then 'string'
 when 'time' then 'TimeSpan'
 when 'timestamp' then 'DateTime'
 when 'tinyint' then 'byte'
 when 'uniqueidentifier' then 'Guid'
 when 'varbinary' then 'byte[]'
 when 'varchar' then 'string'
 else 'UNKNOWN_' + typ.name
 end ColumnType,
 case 
 when col.is_nullable = 1 and typ.name in ('bigint', 'bit', 'date', 'datetime', 'datetime2', 'datetimeoffset', 'decimal', 'float', 'int', 'money', 'numeric', 'real', 'smalldatetime', 'smallint', 'smallmoney', 'time', 'tinyint', 'uniqueidentifier') 
 then '?' 
 else '' 
 end NullableSign
 from sys.columns col
 join sys.types typ on
 col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id
 where object_id = object_id(@TableName)
) t
order by ColumnId

select @GetIndividual = @GetIndividual +'

 }

 }
 }
 catch (Exception ex)
 {
 throw new Exception(ex.Message);
 }
 return item;
 }'



declare @InsertStatement varchar(max) = 'public void Insert'+@TableName+'('+@TableName+' item)
{
 String conn = ConfigurationManager.ConnectionStrings["ConnectionNameInWeb.config"].ConnectionString;

 try
 {
 using (var sqlCon = new SqlConnection(conn))
 {
 sqlCon.Open();
 var cmd = new SqlCommand
 {
 Connection = sqlCon,
 CommandType = CommandType.StoredProcedure,
 CommandText = "StoredProcedureInsert"
 };

 ' 
select @InsertStatement = @InsertStatement + '
 cmd.Parameters.AddWithValue("@'+ColumnName+'", item.'+ColumnName+');
'
from
(
 select 
 replace(col.name, ' ', '_') ColumnName,
 column_id ColumnId,
 case typ.name 
 when 'bigint' then 'long'
 when 'binary' then 'byte[]'
 when 'bit' then 'bool'
 when 'char' then 'string'
 when 'date' then 'DateTime'
 when 'datetime' then 'DateTime'
 when 'datetime2' then 'DateTime'
 when 'datetimeoffset' then 'DateTimeOffset'
 when 'decimal' then 'decimal'
 when 'float' then 'float'
 when 'image' then 'byte[]'
 when 'int' then 'int'
 when 'money' then 'decimal'
 when 'nchar' then 'char'
 when 'ntext' then 'string'
 when 'numeric' then 'decimal'
 when 'nvarchar' then 'string'
 when 'real' then 'double'
 when 'smalldatetime' then 'DateTime'
 when 'smallint' then 'short'
 when 'smallmoney' then 'decimal'
 when 'text' then 'string'
 when 'time' then 'TimeSpan'
 when 'timestamp' then 'DateTime'
 when 'tinyint' then 'byte'
 when 'uniqueidentifier' then 'Guid'
 when 'varbinary' then 'byte[]'
 when 'varchar' then 'string'
 else 'UNKNOWN_' + typ.name
 end ColumnType,
 case 
 when col.is_nullable = 1 and typ.name in ('bigint', 'bit', 'date', 'datetime', 'datetime2', 'datetimeoffset', 'decimal', 'float', 'int', 'money', 'numeric', 'real', 'smalldatetime', 'smallint', 'smallmoney', 'time', 'tinyint', 'uniqueidentifier') 
 then '?' 
 else '' 
 end NullableSign
 from sys.columns col
 join sys.types typ on
 col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id
 where object_id = object_id(@TableName)
) t
order by ColumnId

select @InsertStatement = @InsertStatement +'

 cmd.ExecuteNonQuery();

 }
 }
 catch (Exception ex)
 {
 throw new Exception(ex.Message);
 }

 }'

declare @UpdateStatement varchar(max) = 'public void Update'+@TableName+'('+@TableName+' item)
{
 String conn = ConfigurationManager.ConnectionStrings["ConnectionNameInWeb.config"].ConnectionString;

 try
 {
 using (var sqlCon = new SqlConnection(conn))
 {
 sqlCon.Open();
 var cmd = new SqlCommand
 {
 Connection = sqlCon,
 CommandType = CommandType.StoredProcedure,
 CommandText = "StoredProcedureUpdate"
 };
 cmd.Parameters.AddWithValue("@UpdateCriteria", item.Id);
 ' 
select @UpdateStatement = @UpdateStatement + '
 cmd.Parameters.AddWithValue("@'+ColumnName+'", item.'+ColumnName+');
'
from
(
 select 
 replace(col.name, ' ', '_') ColumnName,
 column_id ColumnId,
 case typ.name 
 when 'bigint' then 'long'
 when 'binary' then 'byte[]'
 when 'bit' then 'bool'
 when 'char' then 'string'
 when 'date' then 'DateTime'
 when 'datetime' then 'DateTime'
 when 'datetime2' then 'DateTime'
 when 'datetimeoffset' then 'DateTimeOffset'
 when 'decimal' then 'decimal'
 when 'float' then 'float'
 when 'image' then 'byte[]'
 when 'int' then 'int'
 when 'money' then 'decimal'
 when 'nchar' then 'char'
 when 'ntext' then 'string'
 when 'numeric' then 'decimal'
 when 'nvarchar' then 'string'
 when 'real' then 'double'
 when 'smalldatetime' then 'DateTime'
 when 'smallint' then 'short'
 when 'smallmoney' then 'decimal'
 when 'text' then 'string'
 when 'time' then 'TimeSpan'
 when 'timestamp' then 'DateTime'
 when 'tinyint' then 'byte'
 when 'uniqueidentifier' then 'Guid'
 when 'varbinary' then 'byte[]'
 when 'varchar' then 'string'
 else 'UNKNOWN_' + typ.name
 end ColumnType,
 case 
 when col.is_nullable = 1 and typ.name in ('bigint', 'bit', 'date', 'datetime', 'datetime2', 'datetimeoffset', 'decimal', 'float', 'int', 'money', 'numeric', 'real', 'smalldatetime', 'smallint', 'smallmoney', 'time', 'tinyint', 'uniqueidentifier') 
 then '?' 
 else '' 
 end NullableSign
 from sys.columns col
 join sys.types typ on
 col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id
 where object_id = object_id(@TableName)
) t
order by ColumnId

select @UpdateStatement = @UpdateStatement +'

 cmd.ExecuteNonQuery();

 }
 }
 catch (Exception ex)
 {
 throw new Exception(ex.Message);
 }

 }'

declare @EndDataAccess varchar(max) = '
}'
 print @InitDataAccess
 print @GetIndividual
print @InsertStatement
print @UpdateStatement
print @ListStatement
print @EndDataAccess
</code></pre>

Of course its not bulletproof code, and can be improved. Just wanted to contribute to this excelent solution

blocks|key|695375|text|如果您有权访问SQL+Server2016，则可以使用FOR+JSON+(带INCLUDE_NULL_VALUES)选项从select语句中获取JSON输出。复制输出，然后在Visual+Studio中，粘贴特殊的->粘贴JSON作为类。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|695376|这是一种预算解决方案，但可能会节省一些时间。|695377|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

If you have access to SQL Server 2016, you can use the FOR JSON (with INCLUDE_NULL_VALUES) option to get JSON output from a select statement. Copy the output, then in Visual Studio, paste special -> paste JSON as class.

Kind of a budget solution, but might save some time.

blocks|key|911533|text|从顶部回复略有修改：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|911534|declare+@TableName+sysname+=+'HistoricCommand'

declare+@Result+varchar(max)+=+'[System.Data.Linq.Mapping.Table(Name+=+"'+%2B+@TableName+%2B+'")]
public+class+Dbo'+%2B+@TableName+%2B+'
{'

select+@Result+=+@Result+%2B+'
++++[System.Data.Linq.Mapping.Column(Name+=+"'+%2B+t.ColumnName+%2B+'",+IsPrimaryKey+=+'+%2B+pkk.ISPK+%2B+')]
++++public+'+%2B+ColumnType+%2B+NullableSign+%2B+'+'+%2B+t.ColumnName+%2B+'+{+get;+set;+}
'
from
(
++++select+
++++++++replace(col.name,+'+',+'_')+ColumnName,
++++++++column_id+ColumnId,
++++++++case+typ.name+
++++++++++++when+'bigint'+then+'long'
++++++++++++when+'binary'+then+'byte[]'
++++++++++++when+'bit'+then+'bool'
++++++++++++when+'char'+then+'string'
++++++++++++when+'date'+then+'DateTime'
++++++++++++when+'datetime'+then+'DateTime'
++++++++++++when+'datetime2'+then+'DateTime'
++++++++++++when+'datetimeoffset'+then+'DateTimeOffset'
++++++++++++when+'decimal'+then+'decimal'
++++++++++++when+'float'+then+'float'
++++++++++++when+'image'+then+'byte[]'
++++++++++++when+'int'+then+'int'
++++++++++++when+'money'+then+'decimal'
++++++++++++when+'nchar'+then+'string'
++++++++++++when+'ntext'+then+'string'
++++++++++++when+'numeric'+then+'decimal'
++++++++++++when+'nvarchar'+then+'string'
++++++++++++when+'real'+then+'double'
++++++++++++when+'smalldatetime'+then+'DateTime'
++++++++++++when+'smallint'+then+'short'
++++++++++++when+'smallmoney'+then+'decimal'
++++++++++++when+'text'+then+'string'
++++++++++++when+'time'+then+'TimeSpan'
++++++++++++when+'timestamp'+then+'DateTime'
++++++++++++when+'tinyint'+then+'byte'
++++++++++++when+'uniqueidentifier'+then+'Guid'
++++++++++++when+'varbinary'+then+'byte[]'
++++++++++++when+'varchar'+then+'string'
++++++++++++else+'UNKNOWN_'+%2B+typ.name
++++++++end+ColumnType,
++++++++case+
++++++++++++when+col.is_nullable+=+1+and+typ.name+in+('bigint',+'bit',+'date',+'datetime',+'datetime2',+'datetimeoffset',+'decimal',+'float',+'int',+'money',+'numeric',+'real',+'smalldatetime',+'smallint',+'smallmoney',+'time',+'tinyint',+'uniqueidentifier')+
++++++++++++then+'?'+
++++++++++++else+''+
++++++++end+NullableSign
++++from+sys.columns+col
++++++++join+sys.types+typ+on
++++++++++++col.system_type_id+=+typ.system_type_id+AND+col.user_type_id+=+typ.user_type_id+++++++++
++++where+object_id+=+object_id(@TableName)+
)+t,+
(
++++++++++++++++SELECT+c.name++AS+'ColumnName',+CASE+WHEN+dd.pk+IS+NULL+THEN+'false'+ELSE+'true'+END+ISPK+++++++++++
++++++++++++++++FROM++++++++sys.columns+c
++++++++++++++++++++JOIN++++sys.tables++t+++ON+c.object_id+=+t.object_id++++
++++++++++++++++++++LEFT+JOIN+(SELECT+++K.COLUMN_NAME+,+C.CONSTRAINT_TYPE+as+pk++
++++++++++++++++++++++++FROM+INFORMATION_SCHEMA.KEY_COLUMN_USAGE+AS+K+
++++++++++++++++++++++++++++LEFT+JOIN+INFORMATION_SCHEMA.TABLE_CONSTRAINTS+AS+C
++++++++++++++++++++++++ON+K.TABLE_NAME+=+C.TABLE_NAME
++++++++++++++++++++++++++++AND+K.CONSTRAINT_NAME+=+C.CONSTRAINT_NAME
++++++++++++++++++++++++++++AND+K.CONSTRAINT_CATALOG+=+C.CONSTRAINT_CATALOG
++++++++++++++++++++++++++++AND+K.CONSTRAINT_SCHEMA+=+C.CONSTRAINT_SCHEMA++++++++++++
++++++++++++++++++++++++WHERE+K.TABLE_NAME+=+@TableName)+as+dd
+++++++++++++++++++++ON+dd.COLUMN_NAME+=+c.name
+++++++++++++++++WHERE+++++++t.name+=+@TableName++++++++++++
++++++++++++)+pkk
where+pkk.ColumnName+=+t.ColumnName
order+by+ColumnId

set+@Result+=+@Result++%2B+'
}'

print+@Result|code-block|syntax|javascript|911535|这使输出成为C#声明中完整的LINQ所需的。|911536|[System.Data.Linq.Mapping.Table(Name+=+"HistoricCommand")]
public+class+DboHistoricCommand
{
++++[System.Data.Linq.Mapping.Column(Name+=+"HistoricCommandId",+IsPrimaryKey+=+true)]
++++public+int+HistoricCommandId+{+get;+set;+}

++++[System.Data.Linq.Mapping.Column(Name+=+"PHCloudSoftwareInstanceId",+IsPrimaryKey+=+true)]
++++public+int+PHCloudSoftwareInstanceId+{+get;+set;+}

++++[System.Data.Linq.Mapping.Column(Name+=+"CommandType",+IsPrimaryKey+=+false)]
++++public+int+CommandType+{+get;+set;+}

++++[System.Data.Linq.Mapping.Column(Name+=+"InitiatedDateTime",+IsPrimaryKey+=+false)]
++++public+DateTime+InitiatedDateTime+{+get;+set;+}

++++[System.Data.Linq.Mapping.Column(Name+=+"CompletedDateTime",+IsPrimaryKey+=+false)]
++++public+DateTime+CompletedDateTime+{+get;+set;+}

++++[System.Data.Linq.Mapping.Column(Name+=+"WasSuccessful",+IsPrimaryKey+=+false)]
++++public+bool+WasSuccessful+{+get;+set;+}

++++[System.Data.Linq.Mapping.Column(Name+=+"Message",+IsPrimaryKey+=+false)]
++++public+string+Message+{+get;+set;+}

++++[System.Data.Linq.Mapping.Column(Name+=+"ResponseData",+IsPrimaryKey+=+false)]
++++public+string+ResponseData+{+get;+set;+}

++++[System.Data.Linq.Mapping.Column(Name+=+"Message_orig",+IsPrimaryKey+=+false)]
++++public+string+Message_orig+{+get;+set;+}

++++[System.Data.Linq.Mapping.Column(Name+=+"Message_XX",+IsPrimaryKey+=+false)]
++++public+string+Message_XX+{+get;+set;+}

}|911537|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

slightly modified from top reply:

<pre><code>declare @TableName sysname = 'HistoricCommand'

declare @Result varchar(max) = '[System.Data.Linq.Mapping.Table(Name = "' + @TableName + '")]
public class Dbo' + @TableName + '
{'

select @Result = @Result + '
 [System.Data.Linq.Mapping.Column(Name = "' + t.ColumnName + '", IsPrimaryKey = ' + pkk.ISPK + ')]
 public ' + ColumnType + NullableSign + ' ' + t.ColumnName + ' { get; set; }
'
from
(
 select 
 replace(col.name, ' ', '_') ColumnName,
 column_id ColumnId,
 case typ.name 
 when 'bigint' then 'long'
 when 'binary' then 'byte[]'
 when 'bit' then 'bool'
 when 'char' then 'string'
 when 'date' then 'DateTime'
 when 'datetime' then 'DateTime'
 when 'datetime2' then 'DateTime'
 when 'datetimeoffset' then 'DateTimeOffset'
 when 'decimal' then 'decimal'
 when 'float' then 'float'
 when 'image' then 'byte[]'
 when 'int' then 'int'
 when 'money' then 'decimal'
 when 'nchar' then 'string'
 when 'ntext' then 'string'
 when 'numeric' then 'decimal'
 when 'nvarchar' then 'string'
 when 'real' then 'double'
 when 'smalldatetime' then 'DateTime'
 when 'smallint' then 'short'
 when 'smallmoney' then 'decimal'
 when 'text' then 'string'
 when 'time' then 'TimeSpan'
 when 'timestamp' then 'DateTime'
 when 'tinyint' then 'byte'
 when 'uniqueidentifier' then 'Guid'
 when 'varbinary' then 'byte[]'
 when 'varchar' then 'string'
 else 'UNKNOWN_' + typ.name
 end ColumnType,
 case 
 when col.is_nullable = 1 and typ.name in ('bigint', 'bit', 'date', 'datetime', 'datetime2', 'datetimeoffset', 'decimal', 'float', 'int', 'money', 'numeric', 'real', 'smalldatetime', 'smallint', 'smallmoney', 'time', 'tinyint', 'uniqueidentifier') 
 then '?' 
 else '' 
 end NullableSign
 from sys.columns col
 join sys.types typ on
 col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id 
 where object_id = object_id(@TableName) 
) t, 
(
 SELECT c.name AS 'ColumnName', CASE WHEN dd.pk IS NULL THEN 'false' ELSE 'true' END ISPK 
 FROM sys.columns c
 JOIN sys.tables t ON c.object_id = t.object_id 
 LEFT JOIN (SELECT K.COLUMN_NAME , C.CONSTRAINT_TYPE as pk 
 FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS K 
 LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS C
 ON K.TABLE_NAME = C.TABLE_NAME
 AND K.CONSTRAINT_NAME = C.CONSTRAINT_NAME
 AND K.CONSTRAINT_CATALOG = C.CONSTRAINT_CATALOG
 AND K.CONSTRAINT_SCHEMA = C.CONSTRAINT_SCHEMA 
 WHERE K.TABLE_NAME = @TableName) as dd
 ON dd.COLUMN_NAME = c.name
 WHERE t.name = @TableName 
 ) pkk
where pkk.ColumnName = t.ColumnName
order by ColumnId

set @Result = @Result + '
}'

print @Result
</code></pre>

which makes output needed for full LINQ in C# declaration 

<pre><code>[System.Data.Linq.Mapping.Table(Name = "HistoricCommand")]
public class DboHistoricCommand
{
 [System.Data.Linq.Mapping.Column(Name = "HistoricCommandId", IsPrimaryKey = true)]
 public int HistoricCommandId { get; set; }

 [System.Data.Linq.Mapping.Column(Name = "PHCloudSoftwareInstanceId", IsPrimaryKey = true)]
 public int PHCloudSoftwareInstanceId { get; set; }

 [System.Data.Linq.Mapping.Column(Name = "CommandType", IsPrimaryKey = false)]
 public int CommandType { get; set; }

 [System.Data.Linq.Mapping.Column(Name = "InitiatedDateTime", IsPrimaryKey = false)]
 public DateTime InitiatedDateTime { get; set; }

 [System.Data.Linq.Mapping.Column(Name = "CompletedDateTime", IsPrimaryKey = false)]
 public DateTime CompletedDateTime { get; set; }

 [System.Data.Linq.Mapping.Column(Name = "WasSuccessful", IsPrimaryKey = false)]
 public bool WasSuccessful { get; set; }

 [System.Data.Linq.Mapping.Column(Name = "Message", IsPrimaryKey = false)]
 public string Message { get; set; }

 [System.Data.Linq.Mapping.Column(Name = "ResponseData", IsPrimaryKey = false)]
 public string ResponseData { get; set; }

 [System.Data.Linq.Mapping.Column(Name = "Message_orig", IsPrimaryKey = false)]
 public string Message_orig { get; set; }

 [System.Data.Linq.Mapping.Column(Name = "Message_XX", IsPrimaryKey = false)]
 public string Message_XX { get; set; }

}
</code></pre>

blocks|key|911617|text|虽然有点晚，但我已经创建了一个web工具来帮助从SQL+result、SQL+Table和SQL创建C#+(或其他)对象。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|911618|sql2object.com|offset|length|911619|这真的可以让你不必键入所有的属性和类型。|911620|如果类型无法识别，将选择默认值。|911621|entityMap|0|LINK|mutability|MUTABLE|url|https://www.sql2object.com/^0|0|0|E|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

A bit late but I've created a web tool to help create a C# (or other) objects from SQL result, SQL Table and SQL SP.

<a href="https://www.sql2object.com" rel="noreferrer">sql2object.com</a> 

This can really safe you having to type all your properties and types.

If the types are not recognised the default will be selected.

blocks|key|911693|text|Java类生成|type|unstyled|depth|inlineStyleRanges|entityRanges|data|911694|declare+@TableName+varchar(max)+=+'Restaurants'
declare+@Templete+varchar(max)+=+'+
+++++public+@ColumnType+@ColumnName+;+//+@ColumnDesc++
+++++public+@ColumnType+get@ColumnName()
+++++{
++++++++return+this.@ColumnName;
+++++}
+++++public+void+set@ColumnName(@ColumnType+@ColumnName)
+++++{
++++++++this.@ColumnName=@ColumnName;
+++++}

+++++'
declare+@before+varchar(max)='public+class++@TableName++
{'
+++
declare+@after+varchar(max)='
}'



declare+@result+varchar(max)

set+@before+=replace(@before,'@TableName',@TableName)

set+@result=@before

select+@result+=+@result+
%2B+replace(replace(replace(replace(replace(@Templete,'@ColumnType',ColumnType)+,'@ColumnName',ColumnName)+,'@ColumnDesc',ColumnDesc),'@ISPK',ISPK),'@max_length',max_length)

from++
(
++++select+
++++column_id,
++++replace(col.name,+'+',+'_')+ColumnName,
++++typ.name+as+sqltype,
++++typ.max_length,
++++is_identity,
++++pkk.ISPK,+
++++++++case+typ.name+
++++++++++++when+'bigint'+then+'long'
++++++++++++when+'binary'+then+'byte[]'
++++++++++++when+'bit'+then+'bool'
++++++++++++when+'char'+then+'String'
++++++++++++when+'date'+then+'DateTime'
++++++++++++when+'datetime'+then+'DateTime'
++++++++++++when+'datetime2'+then+'DateTime'
++++++++++++when+'datetimeoffset'+then+'DateTimeOffset'
++++++++++++when+'decimal'+then+'decimal'
++++++++++++when+'float'+then+'float'
++++++++++++when+'image'+then+'byte[]'
++++++++++++when+'int'+then+'int'
++++++++++++when+'money'+then+'decimal'
++++++++++++when+'nchar'+then+'char'
++++++++++++when+'ntext'+then+'string'
++++++++++++when+'numeric'+then+'decimal'
++++++++++++when+'nvarchar'+then+'String'
++++++++++++when+'real'+then+'double'
++++++++++++when+'smalldatetime'+then+'DateTime'
++++++++++++when+'smallint'+then+'short'
++++++++++++when+'smallmoney'+then+'decimal'
++++++++++++when+'text'+then+'String'
++++++++++++when+'time'+then+'TimeSpan'
++++++++++++when+'timestamp'+then+'DateTime'
++++++++++++when+'tinyint'+then+'byte'
++++++++++++when+'uniqueidentifier'+then+'Guid'
++++++++++++when+'varbinary'+then+'byte[]'
++++++++++++when+'varchar'+then+'string'
++++++++++++else+'UNKNOWN_'+%2B+typ.name
++++++++END+%2B+CASE+WHEN+col.is_nullable=1+AND+typ.name+NOT+IN+('binary',+'varbinary',+'image',+'text',+'ntext',+'varchar',+'nvarchar',+'char',+'nchar')+THEN+'?'+ELSE+''+END+ColumnType,
++++++isnull(colDesc.colDesc,'')+AS+ColumnDesc+
++++from+sys.columns+col
++++++++join+sys.types+typ+on
++++++++++++col.system_type_id+=+typ.system_type_id+AND+col.user_type_id+=+typ.user_type_id
++++++++++++left+join
++++++++++++(
++++++++++++++++SELECT+c.name++AS+'ColumnName',+CASE+WHEN+dd.pk+IS+NULL+THEN+'false'+ELSE+'true'+END+ISPK+++++++++++
++++++++++++++++FROM++++++++sys.columns+c
++++++++++++++++++++JOIN++++sys.tables++t+++ON+c.object_id+=+t.object_id++++
++++++++++++++++++++LEFT+JOIN+(SELECT+++K.COLUMN_NAME+,+C.CONSTRAINT_TYPE+as+pk++
++++++++++++++++++++++++FROM+INFORMATION_SCHEMA.KEY_COLUMN_USAGE+AS+K+
++++++++++++++++++++++++++++LEFT+JOIN+INFORMATION_SCHEMA.TABLE_CONSTRAINTS+AS+C
++++++++++++++++++++++++ON+K.TABLE_NAME+=+C.TABLE_NAME
++++++++++++++++++++++++++++AND+K.CONSTRAINT_NAME+=+C.CONSTRAINT_NAME
++++++++++++++++++++++++++++AND+K.CONSTRAINT_CATALOG+=+C.CONSTRAINT_CATALOG
++++++++++++++++++++++++++++AND+K.CONSTRAINT_SCHEMA+=+C.CONSTRAINT_SCHEMA++++++++++++
++++++++++++++++++++++++WHERE+K.TABLE_NAME+=+@TableName)+as+dd
+++++++++++++++++++++ON+dd.COLUMN_NAME+=+c.name
+++++++++++++++++WHERE+++++++t.name+=+@TableName+++++++
++++++++++++)+pkk++on+ColumnName=col.name

++++OUTER+APPLY+(
++++SELECT+TOP+1+CAST(value+AS+NVARCHAR(max))+AS+colDesc
++++FROM
+++++++sys.extended_properties
++++WHERE
+++++++major_id+=+col.object_id
+++++++AND
+++++++minor_id+=+COLUMNPROPERTY(major_id,+col.name,+'ColumnId')
++++)+colDesc++++++
++++where+object_id+=+object_id(@TableName)

++++)+t

++++set+@result=@result%2B@after

++++select+@result
++++--print+@result|code-block|syntax|javascript|911695|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Java class Generation
<pre><code>declare @TableName varchar(max) = 'Restaurants'
declare @Templete varchar(max) = ' 
 public @ColumnType @ColumnName ; // @ColumnDesc 
 public @ColumnType get@ColumnName()
 {
 return this.@ColumnName;
 }
 public void set@ColumnName(@ColumnType @ColumnName)
 {
 this.@ColumnName=@ColumnName;
 }

 '
declare @before varchar(max)='public class @TableName 
{'
 
declare @after varchar(max)='
}'



declare @result varchar(max)

set @before =replace(@before,'@TableName',@TableName)

set @result=@before

select @result = @result 
+ replace(replace(replace(replace(replace(@Templete,'@ColumnType',ColumnType) ,'@ColumnName',ColumnName) ,'@ColumnDesc',ColumnDesc),'@ISPK',ISPK),'@max_length',max_length)

from 
(
 select 
 column_id,
 replace(col.name, ' ', '_') ColumnName,
 typ.name as sqltype,
 typ.max_length,
 is_identity,
 pkk.ISPK, 
 case typ.name 
 when 'bigint' then 'long'
 when 'binary' then 'byte[]'
 when 'bit' then 'bool'
 when 'char' then 'String'
 when 'date' then 'DateTime'
 when 'datetime' then 'DateTime'
 when 'datetime2' then 'DateTime'
 when 'datetimeoffset' then 'DateTimeOffset'
 when 'decimal' then 'decimal'
 when 'float' then 'float'
 when 'image' then 'byte[]'
 when 'int' then 'int'
 when 'money' then 'decimal'
 when 'nchar' then 'char'
 when 'ntext' then 'string'
 when 'numeric' then 'decimal'
 when 'nvarchar' then 'String'
 when 'real' then 'double'
 when 'smalldatetime' then 'DateTime'
 when 'smallint' then 'short'
 when 'smallmoney' then 'decimal'
 when 'text' then 'String'
 when 'time' then 'TimeSpan'
 when 'timestamp' then 'DateTime'
 when 'tinyint' then 'byte'
 when 'uniqueidentifier' then 'Guid'
 when 'varbinary' then 'byte[]'
 when 'varchar' then 'string'
 else 'UNKNOWN_' + typ.name
 END + CASE WHEN col.is_nullable=1 AND typ.name NOT IN ('binary', 'varbinary', 'image', 'text', 'ntext', 'varchar', 'nvarchar', 'char', 'nchar') THEN '?' ELSE '' END ColumnType,
 isnull(colDesc.colDesc,'') AS ColumnDesc 
 from sys.columns col
 join sys.types typ on
 col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id
 left join
 (
 SELECT c.name AS 'ColumnName', CASE WHEN dd.pk IS NULL THEN 'false' ELSE 'true' END ISPK 
 FROM sys.columns c
 JOIN sys.tables t ON c.object_id = t.object_id 
 LEFT JOIN (SELECT K.COLUMN_NAME , C.CONSTRAINT_TYPE as pk 
 FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS K 
 LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS C
 ON K.TABLE_NAME = C.TABLE_NAME
 AND K.CONSTRAINT_NAME = C.CONSTRAINT_NAME
 AND K.CONSTRAINT_CATALOG = C.CONSTRAINT_CATALOG
 AND K.CONSTRAINT_SCHEMA = C.CONSTRAINT_SCHEMA 
 WHERE K.TABLE_NAME = @TableName) as dd
 ON dd.COLUMN_NAME = c.name
 WHERE t.name = @TableName 
 ) pkk on ColumnName=col.name

 OUTER APPLY (
 SELECT TOP 1 CAST(value AS NVARCHAR(max)) AS colDesc
 FROM
 sys.extended_properties
 WHERE
 major_id = col.object_id
 AND
 minor_id = COLUMNPROPERTY(major_id, col.name, 'ColumnId')
 ) colDesc 
 where object_id = object_id(@TableName)

 ) t

 set @result=@result+@after

 select @result
 --print @result
</code></pre>

blocks|key|911747|text|因为之前没有人提到它，所以还有Scaffold-DbContext|type|unstyled|depth|inlineStyleRanges|entityRanges|data|911748|在NuGet包管理器控制台中键入以下内容：Scaffold-DbContext+"Your+Connection+String"+Microsoft.EntityFrameworkCore.SqlServer+-OutputDir+"Output+Directory"|offset|length|style|CODE|911749|entityMap^0|0|L|35|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Since no one mentioned it before, there is also Scaffold-DbContext
In NuGet Package Manager console type the following:
<code>
Scaffold-DbContext &quot;Your Connection String&quot; Microsoft.EntityFrameworkCore.SqlServer -OutputDir &quot;Output Directory&quot;
</code>

blocks|key|911789|text|从Postgres数据库生成|type|unstyled|depth|inlineStyleRanges|entityRanges|data|911790|DO+$$+DECLARE+v_tabela+varchar;+DECLARE+v_cursor_colunas+record;+DECLARE+v_nome_coluna+varchar;+DECLARE+v_classe+VARCHAR;+DECLARE+v_tipo+VARCHAR;+DECLARE+v_schema_name+VARCHAR;+BEGIN+v_schema_name+:=+'my-schema';+v_tabela+:=+'my-table';+select+table_name+INTO+v_tabela+from+information_schema.tables+where+table_schema+=+v_schema_name+and+table_type+=+'BASE+TABLE'+and+table_name+=+v_tabela;+v_classe+:=+E'\r\n'+%7C%7C+'public+class+'+%7C%7C+v_tabela+%7C%7C+'+{'+%7C%7C++E'\r\n';+FOR+v_cursor_colunas+IN+SELECT+column_name+as+coluna,+is_nullable+as+isnull,+data_type+as+tipo,+character_maximum_length+as+tamanho+FROM+information_schema.columns+WHERE+table_schema+=+v_schema_name+AND+table_name+++=+v_tabela+LOOP|offset|length|style|CODE|911791|IF+v_cursor_colunas.tipo='character+varying'+THEN+v_tipo:=+'string';+ELSIF+v_cursor_colunas.tipo='character'+and+v_cursor_colunas.tamanho=1+THEN+v_tipo:=+'char';+ELSIF+v_cursor_colunas.tipo='character'+and+v_cursor_colunas.tamanho<>1+THEN+v_tipo:=+'string';+ELSIF+v_cursor_colunas.tipo+like+'timestamp%25'+THEN+v_tipo:=+'DateTime';+IF+v_cursor_colunas.isnull='YES'+then+v_tipo:=+'DateTime?';+END+IF;+ELSIF+v_cursor_colunas.tipo='boolean'+THEN+v_tipo:=+'bool';+IF+v_cursor_colunas.isnull='YES'+then+v_tipo:=+'bool?';+END+IF;+ELSIF+v_cursor_colunas.tipo='integer'+THEN+v_tipo:=+'int';+IF+v_cursor_colunas.isnull='YES'+then+v_tipo:=+'int?';+END+IF;+ELSIF+v_cursor_colunas.tipo='numeric'+THEN+v_tipo:=+'double';+IF+v_cursor_colunas.isnull='YES'+then+v_tipo:=+'double?';+END+IF;+ELSIF+v_cursor_colunas.tipo='text'+THEN+v_tipo:=+'string';+ELSE+v_tipo:=+'another';+END+IF;|911792|v_nome_coluna+:=+v_cursor_colunas.coluna;+v_classe+:=+v_classe+%7C%7C+'public+'+%7C%7C+v_tipo+%7C%7C+'+'+%7C%7C+v_cursor_colunas.coluna+%7C%7C+'+{+get;+set;+}'+%7C%7C+E'\r\n';|911793|END+LOOP;|911794|v_classe+:=+v_classe+%7C%7C+E'\r\n'+%7C%7C+'}';|911795|RAISE+NOTICE+'%25'+,+v_classe;+END+$$;|911796|entityMap^0|0|0|JB|0|0|NZ|0|0|47|0|0|9|0|0|13|0|0|10|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@$D|V|E|W|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@$D|Y|E|Z|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|10|8|@$D|11|E|12|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|13|8|@$D|14|E|15|F|G]]|9|@]|A|$]]|$1|N|3|O|5|6|7|16|8|@$D|17|E|18|F|G]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|19|8|@$D|1A|E|1B|F|G]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|S|$]]

Generate from Postgres DB
<code>DO $$
DECLARE v_tabela varchar;
DECLARE v_cursor_colunas record;
DECLARE v_nome_coluna varchar;
DECLARE v_classe VARCHAR;
DECLARE v_tipo VARCHAR;
DECLARE v_schema_name VARCHAR;
BEGIN
v_schema_name := 'my-schema';
v_tabela := 'my-table';
select table_name INTO v_tabela from information_schema.tables where table_schema = v_schema_name
and table_type = 'BASE TABLE'
and table_name = v_tabela;
v_classe := E'\r\n' || 'public class ' || v_tabela || ' {' || E'\r\n';
FOR v_cursor_colunas IN
SELECT column_name as coluna, is_nullable as isnull, data_type as tipo, character_maximum_length as tamanho
FROM information_schema.columns
WHERE table_schema = v_schema_name
AND table_name = v_tabela
LOOP 
IF v_cursor_colunas.tipo='character varying' THEN
v_tipo:= 'string';
ELSIF v_cursor_colunas.tipo='character' and v_cursor_colunas.tamanho=1 THEN
v_tipo:= 'char';
ELSIF v_cursor_colunas.tipo='character' and v_cursor_colunas.tamanho&lt;&gt;1 THEN
v_tipo:= 'string';
ELSIF v_cursor_colunas.tipo like 'timestamp%' THEN
v_tipo:= 'DateTime';
IF v_cursor_colunas.isnull='YES' then
v_tipo:= 'DateTime?';
END IF;
ELSIF v_cursor_colunas.tipo='boolean' THEN
v_tipo:= 'bool';
IF v_cursor_colunas.isnull='YES' then
v_tipo:= 'bool?';
END IF;
ELSIF v_cursor_colunas.tipo='integer' THEN
v_tipo:= 'int';
IF v_cursor_colunas.isnull='YES' then
v_tipo:= 'int?';
END IF;
ELSIF v_cursor_colunas.tipo='numeric' THEN
v_tipo:= 'double';
IF v_cursor_colunas.isnull='YES' then
v_tipo:= 'double?';
END IF;
ELSIF v_cursor_colunas.tipo='text' THEN
v_tipo:= 'string';
ELSE
v_tipo:= 'another';
END IF; 
v_nome_coluna := v_cursor_colunas.coluna;
v_classe := v_classe || 'public ' || v_tipo || ' ' || v_cursor_colunas.coluna || ' { get; set; }' || E'\r\n'; 
END LOOP;
v_classe := v_classe || E'\r\n' || '}'; 
RAISE NOTICE '%' , v_classe;
END $$;
</code>

How can I generate a class from a SQL Server table object?

I'm not talking about using some ORM. I just need to create the entities (simple class). Something like:

<pre class="lang-cs prettyprint-override"><code> public class Person 
 {
 public string Name { get;set; }
 public string Phone { get;set; }
 }
</code></pre>

Given some table like:

<pre><code>+----+-------+----------------+
| ID | Name | Phone |
+----+-------+----------------+
| 1 | Alice | (555) 555-5550 |
| 2 | Bob | (555) 555-5551 |
| 3 | Cathy | (555) 555-5552 |
+----+-------+----------------+


</code></pre>

Generate class from database table

Visual Studio

数据存储

包管理器

SQL数据库

SQL Server

数据库

JSON

Java

如何从SQL Server表对象生成类？我不是在谈论使用一些ORM。我只需要创建实体(简单的类)。类似于：    public class Person     {        public string Name { get;set; }        public string Phone { get;set; ...

问从数据库表生成类
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从数据库表生成类EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从数据库表生成类
EN