-- ============================================= -- Author: Duminda Piumwardena -- Create date: 10/10/2012 -- Description: To generate class properties from tables -- ============================================= Alter PROCEDURE GenerateProperties @tableName varchar(50) AS BEGIN DECLARE @LINEFEED varchar(10) SET @LINEFEED = CHAR(13)+CHAR(10) SELECT '#region Fields'+@LINEFEED UNION ALL SELECT 'private ' + CASE data_type WHEN 'bigint' THEN 'int' -- WHEN 'binary' THEN ...