public void BulkInsertTestData()
{
var repository = new StatisticsRepository(ConnectionString);
var rnd = new Random();
for (int i = 0; i < 100; i++)
{
var stats = new UserStats()
{
UserId = "testuser_" + i.ToString(),
Victories = rnd.Next(1000),
Defeats = rnd.Next(1000),
GameCount = rnd.Next(1000)
};
repository.Save(stats);
}
}
public void SaveAndRetrieveUserStatistics()
{
using (var ts = new TransactionScope())
{
var repository = new StatisticsRepository(ConnectionString);
var stats = new UserStats()
{
UserId = "testuser",
GameCount = 10,
Victories = 5,
Defeats = 1
};
repository.Save(stats);
var result = repository.Retrieve(stats.UserId);
Assert.AreEqual(result.UserId, stats.UserId);
Assert.AreEqual(result.GameCount, stats.GameCount);
Assert.AreEqual(result.Victories, stats.Victories);
Assert.AreEqual(result.Defeats, stats.Defeats);
}
}
