Example #1
0
        static void removeAllCulturalData(String connectionParams)
        {
            NpgsqlConnection connection = new NpgsqlConnection(connectionParams);

            connection.Open();
            NpgsqlTransaction transaction = connection.BeginTransaction();

            try
            {
                CultureDB cultureDB = new CultureDB(connection);
                cultureDB.removeAllCultureData();
                cultureDB.removeAllCultureGenderBias();
                transaction.Commit();
                Console.WriteLine("removeCulturalData: Transaction successful");
            }
            catch (Exception exception)
            {
                try
                {
                    transaction.Rollback();
                }
                catch (Exception rollbackException)
                {
                    Console.WriteLine("Rollback failed :(");
                }
            }

            connection.Close();
        }