public void LocalDbForSingleTest()
{
// The database will be recreated here if it already exists
using (TempLocalDb db = new TempLocalDb("Test"))
{
// Create the schema in the database (This tool will work best if you are using some kind of database migration tool like FluentMigrator or DbUp)
SchemaHelper.MigrateToCurrentSchema(db);
// Call some code that interacts with the database
DatabaseService dbService = new DatabaseService(db.ConnectionString);
dbService.Insert("First", "Last");
// Verify that the code worked correctly
using (var conn = db.Open())
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT * FROM [Person] WHERE [FirstName] = @FirstName AND [LastName] = @LastName";
cmd.Parameters.AddWithValue("@FirstName", "First");
cmd.Parameters.AddWithValue("@LastName", "Last");
using (var reader = cmd.ExecuteReader())
{
// Just verify that the record exists in the table
Assert.IsTrue(reader.Read());
}
}
// OR Call some other methods to verify the operation worked
Assert.IsNotNull(dbService.FirstOrDefault("First", "Last"));
}
}
public static void Initialize(TestContext context)
{
database = new TempLocalDb("Test");
// Create schema for tests
// If you want to run tests against your database, you should execute your migrations or creation script here
SchemaHelper.MigrateToCurrentSchema(database);
}
public string Start(string databaseName)
{
_database = new TempLocalDb(databaseName);
return(_database.ConnectionString);
}
