private static Guid CreateDatabase()
 {
     var database = Guid.NewGuid();
     var connectionString = string.Format("Data Source=localhost;Integrated Security=true;");
     var factory = new SqlServerConnectionFactory { ConnectionString = connectionString };
     using (var connection = factory.CreateConnection())
     {
         connection.Open();
         var sql = string.Format("CREATE DATABASE [{0}]", database);
         connection.Execute(sql);
     }
     return database;
 }
        private string ConfigureTestDatabase()
        {
            var database = CreateDatabase();
            var connectionString = string.Format("Data Source=localhost;Initial Catalog={0};Integrated Security=true", database);
            tophat.Database.Install<SqlServerConnectionFactory>(connectionString, ConnectionScope.ByThread);
            Database = database.ToString();

            var factory = new SqlServerConnectionFactory { ConnectionString = connectionString };
            using (var connection = factory.CreateConnection())
            {
                connection.Open();
                Schema.Install(DatabaseDialect.SqlServer, connection);
            }

            return connectionString;
        }