Acme.PROJECTNAME.Install.SqlServers.UpdateDatabaseExtendedProperty C# (CSharp) Метод

UpdateDatabaseExtendedProperty() статический приватный Метод

static private UpdateDatabaseExtendedProperty ( string connectionString, string propertyName, string propertyValue ) : void
connectionString string
propertyName string
propertyValue string
Результат 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);
			}
		}

Usage Example

Пример #1
0
 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();
     }
 }