Knight Data Access Layer
Generate Upgrade Scripts VB.NET
Basic Tasks VB.NET > Generation > Generate Upgrade Scripts VB.NET

Use the GenerateUpgradeNamespaceSql to create the SQL to add missing tables and columns to the database.

 

'Get the current instance of the helper

Dim db As IDataHelper = DataHelper.SessionFactory()

 

'Get the SQL to add missing tables and missing columns for the namespace

Dim sql As String = db.GenerateUpgradeNamespaceSql("AcmeCorporation.InvoiceSystem")