Pasted

select pname + prequire + pmax + ';' from
(
select 'Property(e => e.' + name + ').HasColumnName("'+ name +'")' as pname,
case isnullable
       when 0 then '.IsRequired()'
       else '' end as prequire,
case xtype
       when 167 then '.HasMaxLength(' + CAST(length as varchar(50)) +')'
       else '' end as pmax
from syscolumns where id = 1331807777
) a