public async Task UserFriendsCanBeRead() { // Arrange using (var con = OpenConnection()) using (var cache = new SqliteCache(con)) { using (var cmd = con.CreateCommand()) { cmd.CommandText = "INSERT INTO UserFriends (UserId, FriendId) VALUES (123,1), (123,2), (123,3);"; cmd.ExecuteNonQuery(); } // Act var friends = (await cache.GetUserFriends(123)).ToArray(); // Assert CollectionAssert.AreEquivalent(new ulong[] { 1, 2, 3 }, friends); } }