Habanero.Test.BO.AddressTestBO.DropCpAddressTable C# (CSharp) Method

DropCpAddressTable() public static method

public static DropCpAddressTable ( string cpAddressTableName ) : void
cpAddressTableName string
return void
        public static void DropCpAddressTable(string cpAddressTableName)
        {
            if (BORegistry.DataAccessor is DataAccessorInMemory)
            {
                return;
            }
            if (BORegistry.DataAccessor is DataAccessorMultiSource)
            {
                return;
            }
            var sql = "DROP TABLE " + cpAddressTableName;
            DatabaseConnection.CurrentConnection.ExecuteRawSql(sql);
        }

Usage Example

Example #1
0
        public static void DropNewContactPersonAndAddressTables()
        {
            if (ClassDef.ClassDefs.Count > 0 && (ClassDef.ClassDefs.Contains("Habanero.Test.BO", "AddressTestBO")))
            {
                var    classDef = ClassDef.Get <AddressTestBO>();
                string defaultCpAddressTableName = "contact_person_address";
                if (classDef.TableName.ToLower() != defaultCpAddressTableName)
                {
                    AddressTestBO.DropCpAddressTable(classDef.TableName);
                }
            }

            if (ClassDef.ClassDefs.Count > 0 && (ClassDef.ClassDefs.Contains("Habanero.Test.BO", "ContactPersonTestBO")))
            {
                var    classDef = ClassDef.Get <ContactPersonTestBO>();
                string defaultContactPersonTableName = "contact_person";
                if (classDef.TableName.ToLower() != defaultContactPersonTableName)
                {
                    ContactPersonTestBO.DropContactPersonTable(classDef.TableName);
                }
            }
        }