powerdesigner怎么根据sql生成模型
发布网友
发布时间：2022-05-03 11:32
我来回答
共2个回答
懂视网
时间：2022-05-03 15:53
TableName‘;
DECLARE @Result VARCHAR(MAX) = ‘public class ‘ + @TableName + ‘
{‘;
SELECT @Result = @Result + ‘
/// <summary>
/// ‘ + CAST(t.Summary AS VARCHAR(MAX)) + ‘
/// </summary>
public ‘ + ColumnType + NullableSign + ‘ ‘ + ColumnName + ‘ { get; set; }
‘
FROM
(
SELECT REPLACE(col.name, ‘ ‘, ‘_‘) ColumnName,
col.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,
ISNULL(ep.value, col.name) AS Summary
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 sys.extended_properties ep
ON ep.major_id = col.object_id
AND ep.minor_id = col.column_id
WHERE col.object_id = OBJECT_ID(@TableName)
) t
ORDER BY ColumnId;
SET @Result = @Result + ‘
}‘;
PRINT @Result;
转自大佬：https://www.cnblogs.com/meowv/p/11379829.html
利用SQL生成模型实体类（转）
标签：pre eric sys bin summary double arch ide system
热心网友
时间：2022-05-03 13:01
打开PowerDesigner软件，设计“概念数据模型”(ConceptualData Model)： 点击workspace 右键---》New—>Conceptual DataModel,
