使用facebook c＃sdk v6.0.10执行FQL查询

2 回答

• 25

  FQL

  var fb = new FacebookClient("access_token");
  dynamic result = fb.Get("fql", 
      new { q = "SELECT uid FROM user WHERE uid=me()" });
  

  FQL多查询

  var fb = new FacebookClient("access_token");
  dynamic result = fb.Get("fql", new
      {
          q = new[]
                  {
                      "SELECT uid from user where uid=me()",
                      "SELECT name FROM user WHERE uid=me()"
                  }
      });
  

  FQL命名为多查询

  var fb = new FacebookClient("access_token");
  dynamic result = fb.Get("fql",
      new
          {
              q = new
              {
                  id = "SELECT uid from user where uid=me()",
                  name = "SELECT name FROM user WHERE uid " +
                  "IN (SELECT uid FROM #id)",
              }
          });
  

  回复于 2024-04-29T18:21:49+08:00
• 17

  您可以通过Graph API调用实际获得相同的内容：

  var client = new FacebookClient();
  var query = string.Format("SELECT uid, name FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = {0})", me.id);
  
  dynamic parameters = new ExpandoObject();
  parameters.q = query;
  dynamic results = client.Get("/fql", parameters);
  

  回复于 2024-04-29T18:21:49+08:00