SELECT '[DataColum(ColumnName = "' || COLUMN_NAME || '")]' || chr(13) || 'public ' || CASE DATA_TYPE WHEN 'uuid' THEN 'Nullable<Guid>' WHEN 'character varying' THEN 'string' WHEN 'boolean' THEN 'Nullable<bool>' WHEN 'timestamp without time zone' THEN 'Nullable<DateTimeOffset>' WHEN 'timestamp' THEN 'Nullable<DateTime>' WHEN 'integer' THEN 'Nullable<int>' WHEN 'smallint' THEN 'Nullable<short>' WHEN 'date' THEN 'Nullable<DateTime>' WHEN 'money' THEN 'Nullable<decimal>' ELSE 'Nullable<>' END ||' ' || REPLACE(COLUMN_NAME,'_','') || ' { get; set; }' || chr(13) || chr(13) FROM information_schema.columns WHERE TABLE_NAME='Fluxo_Caixa' ORDER BY ordinal_position;