1.在开发过程中,有时候需要将数据库表转化为实体类。手敲除了不方便,还容易出错。本着DRY+懒人原则,参考了一位老司机的博客【见底部】,并在其基础上进行了优化。【原先是不带注释的】
DECLARE @TableName sysname = 'TableName'; DECLARE @Result VARCHAR(MAX) = 'public class ' + @TableName + ' { '; SELECT @Result = @Result + CHAR(13) + ' ///<summary>' + CHAR(13) + ' ///' + CAST(desr AS NVARCHAR) + CHAR(13) + ' ///</summary>' + ' public ' + ColumnType + NullableSign + ' ' + colname + ' ' + ' { get; set; } ' FROM (SELECT column_id ColumnId, ISNULL(t.desctr, '') AS desr, col.name colname, CASE typ.name WHEN 'bigint' THEN 'long