static private UpdateDatabaseExtendedProperty ( string connectionString, string propertyName, string propertyValue ) : void | ||
connectionString | string | |
propertyName | string | |
propertyValue | string | |
return | void |
internal static void UpdateDatabaseExtendedProperty(string connectionString, string propertyName, string propertyValue)
{
if(ExtendedPropertyExists(connectionString, propertyName, string.Empty, string.Empty, string.Empty))
{
UpdateExtendedPropery(connectionString, propertyName, propertyValue, string.Empty, string.Empty, string.Empty);
}
else
{
InsertExtendedPropery(connectionString, propertyName, propertyValue, string.Empty, string.Empty, string.Empty);
}
}
private void RunUpgrade() { _connection = new System.Data.SqlClient.SqlConnection(_connectionString); _connection.Open(); _transaction = _connection.BeginTransaction(); try { this.UpgradeSchemaAndStaticData(); this.ReinstallStoredProcedures(); _transaction.Commit(); SqlServers.UpdateDatabaseExtendedProperty(_connectionString, "dbVersion", _upgradeToVersion.ToString(".")); SqlServers.UpdateDatabaseExtendedProperty(_connectionString, "LastUpdate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture)); } catch (Exception ex) { _transaction.Rollback(); throw; } finally { _connection.Close(); } }