/// <summary>
        /// Loads test data
        /// </summary>
        /// <returns></returns>
        public async Task LoadData()
        {
            var users = client.GetTable<User>();
            var friends = client.GetTable<Friend>();
            var user = await users.ToListAsync();

            // Find me - you should have registered yourself as a user.
            var me = (await users.Where(u => u.Id != null).ToListAsync()).FirstOrDefault();

            // Add a friend
            var friend = new User
            {
                Username = "mikeross",
                Password = "password"
            };

            // Add friend as user first
            await users.InsertAsync(friend);

            // Make friends of each other
            await friends.InsertAsync(new Friend { MyId = me.Id, Username = friend.Username, UserId = friend.Id });
            await friends.InsertAsync(new Friend { MyId = friend.Id, Username = me.Username, UserId = me.Id });


            var conversations = client.GetTable<Conversation>();
            var messages = client.GetTable<Message>();

            // Add a new conversation between the friends
            var conversation = new Conversation
            {
                MyId = me.Id,
                UserId = friend.Id,
                Username = friend.Username,
                LastMessage = "HEY!"
            };
            await conversations.InsertAsync(conversation);
            await messages.InsertAsync(new Message
            {
                ConversationId = conversation.Id,
                ToId = me.Id,
                UserId = friend.Id,
                Username = friend.Username,
                Text = "What's up?",
                Date = DateTime.Now.AddSeconds(-60)
            });
            await messages.InsertAsync(new Message
            {
                ConversationId = conversation.Id,
                ToId = friend.Id,
                UserId = me.Id,
                Username = me.Username,
                Text = "Not much",
                Date = DateTime.Now.AddSeconds(-30)
            });
            await messages.InsertAsync(new Message
            {
                ConversationId = conversation.Id,
                ToId = me.Id,
                UserId = friend.Id,
                Username = friend.Username,
                Text = "HEY!",
                Date = DateTime.Now
            });
        }