T-SQLで作成
--ここからC#用classを作成
DECLARE @TableName VARCHAR(30)
SET @TableName = 'dummytable'
SELECT 'public ' +
CASE
WHEN UPPER(DATA_TYPE) IN ('INT') THEN 'int'
WHEN UPPER(DATA_TYPE) IN ('SMALLINT') THEN 'short'
WHEN UPPER(DATA_TYPE) IN ('FLOAT') THEN 'double'
WHEN UPPER(DATA_TYPE) IN ('TINYINT') THEN 'sbyte'
WHEN UPPER(DATA_TYPE) IN ('BIT') THEN 'bool'
WHEN UPPER(DATA_TYPE) IN ('DATE','DATETIME') THEN 'DateTime'
WHEN UPPER(DATA_TYPE) IN ('CHAR','NCHAR','VARCHAR','NVARCHAR','TEXT','NTEXT') THEN 'string'
ELSE 'xx' END +
CASE WHEN IS_NULLABLE = 'NO' THEN ' ' ELSE '?' END +
COLUMN_NAME +
' { get; set; }' + CHAR(13)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @TableName
ORDER BY ORDINAL_POSITION
100近い項目の変換が面倒になった
0 件のコメント:
コメントを投稿