SQL Serverのテーブル or ビューの定義から C#のデータアクセス用classを作成

 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
 

１００近い項目の変換が面倒になった