C# FacebookClient.Query方法代码示例

        public static void SingleQuery(string accessToken)
        {
            var query = string.Format("SELECT uid,pic_square FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1={0})", "me()");

            try
            {
                var fb = new FacebookClient(accessToken);

                var result = (IList<object>)fb.Query(query);

                foreach (var row in result)
                {
                    var r = (IDictionary<string, object>)row;
                    var uid = (long)r["uid"];
                    var picSquare = (string)r["pic_square"];

                    Console.WriteLine("User Id: {0}", uid);
                    Console.WriteLine("Picture Square: {0}", picSquare);
                    Console.WriteLine();
                }

                // Note: This json result is not the orginal json string as returned by Facebook.
                Console.WriteLine("Json: {0}", result.ToString());
            }
            catch (FacebookApiException ex)
            {
                // Note: make sure to handle this exception.
                throw;
            }
        }

        public static void MultiQuery(string accessToken)
        {
            var query1 = "SELECT uid FROM user WHERE uid=me()";
            var query2 = "SELECT profile_url FROM user WHERE uid=me()";

            try
            {
                var fb = new FacebookClient(accessToken);

                var result = (IList<object>)fb.Query(query1, query2);

                var result0 = ((IDictionary<string, object>)result[0])["fql_result_set"];
                var result1 = ((IDictionary<string, object>)result[1])["fql_result_set"];

                Console.WriteLine("Query 0 result: {0}", result0);
                Console.WriteLine();
                Console.WriteLine("Query 1 result: {0}", result1);
                Console.WriteLine();

                // Note: This json result is not the orginal json string as returned by Facebook.
                Console.WriteLine("Json: {0}", result.ToString());
            }
            catch (FacebookApiException ex)
            {
                // Note: make sure to handle this exception.
                throw;
            }
        }

 /// <summary>
 /// gets the Application User representation of "me"
 /// </summary>
 /// <param name="i_AccessToken"></param>
 /// <returns></returns>
 public static ApplicationUser GetUser(string i_AccessToken)
 {
     ApplicationUser result = new ApplicationUser();
     FacebookClient fbClient = new FacebookClient(i_AccessToken); ;
     dynamic me = fbClient.Query(
      "SELECT uid, name, first_name, last_name, pic_small, pic_big, pic_square, pic, email, birthday_date FROM user WHERE uid = me()");
     result = createUserFromDynamicUser(me[0], result);
     result.AccessToken = i_AccessToken;
     return result;
 }

        /// <summary>
        /// return a dictionary of users friends. sorted as {ID,FRIEND}
        /// </summary>
        /// <param name="i_AccessToken"></param>
        /// <returns></returns>
        public static Dictionary<string, Friend> GetUsersFriends(string i_AccessToken)
        {
            Dictionary<string, Friend>  result = new Dictionary<string, Friend>();
            FacebookClient fbClient = new FacebookClient(i_AccessToken);

            dynamic userFriends = fbClient.Query(
             "SELECT uid, name, first_name, last_name, pic_small, pic_big, pic_square, pic, birthday_date FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = me())");
            foreach (dynamic friend in userFriends)
            {
                Friend tempFriend = new Friend();
                createUserFromDynamicUser(friend, tempFriend);
                result.Add(tempFriend.Id, tempFriend);
            }

            return result;
        }

        private static void GetPicUrls(List<string> queries, ConcurrentBag<Uri> picsToGet, string seconds,
            string queryFormat)
        {
            Parallel.ForEach(Settings.Default.FacebookUsersSettings.UserSettings,
                             (userSetting =>
                                  {
                                      string[] ids = userSetting.PictureSettings.Select(x => x.User.Id).ToArray();
                                      string query = string.Format(queryFormat, string.Join(",", ids), seconds);
                                      queries.Add(query);
                                      var fb = new FacebookClient(userSetting.AccessToken);
                                      dynamic result = fb.Query(query);

                                      foreach (dynamic pic in result)
                                      {
                                          picsToGet.Add(new Uri(pic.src_big));
                                      }
                                  }));
        }

 private void SearchForFacebookId(int personId, string firstname, string surname, FacebookClient client)
 {
     try
     {
         string fullname = firstname + " " + surname;
         dynamic friends = client.Query("SELECT uid, first_name, last_name FROM user WHERE uid IN (    SELECT uid2    FROM friend    WHERE uid1=me()) AND name='" + fullname + "'");
         if (friends.Count == 1)
         {
             PersonDataAccessor.SavePersonFacebookId(personId, friends[0].uid);
         }
     }
     catch { }
 }