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); } }