public async Task CorrectUserIdIsFoundForFriend() { // Arrange using (var con = OpenConnection()) using (var cache = new SqliteCache(con)) { using (var cmd = con.CreateCommand()) { cmd.CommandText = "INSERT INTO UserFriends (UserId, FriendId) VALUES (1, 5), (2,4), (3,5);"; cmd.ExecuteNonQuery(); } // Act var noFriend = await cache.FindFriend(15); var single = await cache.FindFriend(4); var two = await cache.FindFriend(5); // Assert Assert.AreEqual(0ul, noFriend); Assert.AreEqual(2ul, single); Assert.IsTrue(two == 1ul || two == 3ul, two.ToString()); } }