private static void ClearTestDatabase(SqlServerDbSettings settings)
        {
            DropExistingAggregatesTable();

            SqlServerDbInitialiser.Initialise(new SqlServerDbClientFactory(settings), settings);

            void DropExistingAggregatesTable()
            {
                using (var client = new SqlServerDbClientFactory(settings).OpenClient())
                {
                    try
                    {
                        client.CreateCommand().Op(
                            c =>
                        {
                            c.CommandText = $"DROP TABLE {settings.TableName};";
                            c.ExecuteNonQuery();
                        });
                    }
                    catch
                    {
                        // ignored, may not exist
                    }
                }
            }
        }
        public static ITestHarness Create(SqlServerDbSettings dbConfig)
        {
            ClearTestDatabase(dbConfig);

            return(new SqlServerTestHarness(new SqlServerRepository(dbConfig)));
        }