SQL Server Build Entity

SELECT'// <summary> ///' + CAST (c.value as NVARCHAR) + '/// </summary>[DataMember] Public string '+ CAST (b.name as VARCHAR) +'{Get;Set;}'+char () as property,row_number () over (ORDER by B.name) as Rnuminto #temp710FROM sys.tables A INNER JOIN sys.column S B on b.object_id=a.object_id left JOIN sys.extended_properties C on c.major_id=b.object_id and c.minor_id=B.column_idwhere A.name='Table name';D eclare @i INT=1;D eclare @count INT= the;D eclare @tempColumn NVARCHAR ( -) ="'; while (@i<=@count) BEGIN SELECT @tempColumn=property from #temp710 as T WHERE t.rnum=@i;        PRINT @tempColumn; SET @i= @i +1; END;  DROP TABLE #temp710; 

SQL Server Build Entity