PageRenderTime 44ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/Samples/SimpleQuery/Default.aspx.cs

https://bitbucket.org/assaframan/facebooklinq
C# | 40 lines | 37 code | 3 blank | 0 comment | 6 complexity | 2084343fbb0cf2ee73a6d835e95643a9 MD5 | raw file
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using System.Web.UI;
  6. using System.Web.UI.WebControls;
  7. using facebook.Web;
  8. using facebook;
  9. namespace SimpleQuery
  10. {
  11. public partial class _Default : System.Web.UI.Page
  12. {
  13. protected void Page_Load(object sender, EventArgs e)
  14. {
  15. if (FacebookContext.Current.TryAuthenticating(true))
  16. {
  17. var db = new FacebookDataContext();
  18. var useQuerySyntax = true;
  19. var useMethodSyntax = false;
  20. if (useQuerySyntax)
  21. {
  22. var friendIds = from friend in db.friend_info where friend.uid1 == db.uid select friend.uid2;
  23. var friendDetails = (from user in db.user where friendIds.Contains(user.uid) select new { Name = user.name, Picture = user.pic_small }).Take(5);
  24. listFriends.DataSource = friendDetails.ToArray();
  25. DataBind();
  26. }
  27. else if (useMethodSyntax)
  28. {
  29. var friendIds2 = db.friend_info.Where(t => t.uid1 == db.uid).Select(t => t.uid2);
  30. var friendDetails2 = db.user.Where(t => friendIds2.Contains(t.uid)).Select(t => new { Name = t.name, Picture = t.pic_small }).Take(5);
  31. listFriends.DataSource = friendDetails2.ToArray();
  32. DataBind();
  33. }
  34. }
  35. }
  36. }
  37. }