public async Task ViaCRIU()
{
Marker("Starting");
using (var sqlServer = new SqlServerViaDockerFast("sqlservr-camels"))
{
await sqlServer.Start();
Marker("Started");
using (var db = new SqlConnection($"Server={sqlServer.Host},{sqlServer.Port};Database=CamelsRUs;User Id=sa;Password=Wibble123!"))
{
await db.OpenAsync();
Marker("Opened");
var ranchId = await db.CreateRanch(name : "Jason's Camel Ranch");
var camelId1 = await db.CreateCamel(name : "Claude", species : "Dromedary", age : 7);
await db.PlaceCamel(ranchId, camelId1);
var camelId2 = await db.CreateCamel(name : "Claudette", species : "Persian", age : 14);
await db.PlaceCamel(ranchId, camelId2);
var camels = await db.QueryAsync("SELECT * FROM Camels WHERE Species IN ('Bactrian', 'Wild Bactrian', 'Dromedary')");
Assert.That(camels.Count(), Is.EqualTo(1));
}
Marker("Finished");
}
}
public async Task Available_AfterStart()
{
using (var sql = new SqlServerViaDockerFast("sqlservr-tracking"))
{
await sql.Start(CancellationToken.None);
var connectionString =
$"Server={sql.ServerUri.Host},{sql.ServerUri.Port};Database=electio_tracking;User Id=sa;Password=Wibble123!;Encrypt=False;Connection Timeout=30;MultipleActiveResultSets=True";
using (var connection = new SqlConnection(connectionString))
{
await connection.OpenAsync();
}
}
}
