예제 #1
0
        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);
                }
        }