title: Generate Sql DB Script in C#
body: <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>