Generate Sql DB Script in C#
<p>I have a sql table that contains Table Columns Properties like TableName, ColumnName,  Datatype, IsPrimary, IsNullable, DefaultValue, Length etc and also a versionId.
So my requirement is comparing two versionIds and then generating scripts in C# 
like <code>alter table</code>.</p>

<p>Please tell me how to do this programatically.</p>

<p>Thanks in Advance</p>
