Create property methods for fields using query

SET NOCOUNT ON
select 
'/// <summary>
/// Retrieves ' + column_name + ' from Author object
/// </summary>
internal static ' +
case when data_type='varchar' then 'String '
when data_type='char' then 'String '
when data_type='tinyint' then 'Byte '
when data_type='money' then 'Decimal '
end

+ column_name + '
{
get
{
' +
case when data_type='varchar' then 'String str'
when data_type='char' then 'String str'
when data_type='tinyint' then 'Byte by'
when data_type='money' then 'Decimal dec'
end + column_name + '=(' +

case when data_type='varchar' then 'String'
when data_type='char' then 'String'
when data_type='tinyint' then 'Byte'
when data_type='money' then 'Decimal'
end

+ ')GetAuthorValue("' +
upper(column_name)
+ '","' +  
case when data_type='varchar' then 'String'
when data_type='char' then 'String'
when data_type='tinyint' then 'Byte'
when data_type='money' then 'Decimal'
end+   
'");
return ' + 
case when data_type='varchar' then 'str'
when data_type='char' then 'str'
when data_type='tinyint' then 'by'
when data_type='money' then 'dec'
end + column_name +
';'
+ '
}
}// End of Property ' + column_name + '

'
from information_schema.columns where table_name='Authors'
order by ordinal_position

SET NOCOUNT OFF