SQL 和 c# Emtity的相互转换

相信大家在开发中,都遇到一个问题 ,如 json 和emtity 的转换  

sql和emtity 的转换  

在线工具里面很多json  xml   emtity 的互转工具 ,层出不穷

唯独 sql和实体的转换很少很少 

好了 ,话归真题...

ALTER PROC P_SqlToEmtity 
@TableName SYSNAME ---表名
AS
DECLARE @Result NVARCHAR(MAX) = N'public class ' + @TableName + N'
{';

SELECT @Result = @Result + N'
public ' + ColumnType + NullableSign + N' ' + ColumnName + N' { 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 'NVARCHAR'    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 + N'
}'

PRINT @Result