How to make query "is uid X attending event Y"

Question

How to make query "is uid X attending event Y" with ASP.NET toolkit?

Do I need to use Facebook SQL?

I have an event with 5000+ members and I want to enumerate all friends of current users to see if they belong to this event.

Answer 1

The following FQL call should handle this:

select name from user where uid in(
 select uid from event_member where eid = EVENT_ID and uid in (
  select uid2 from friend where uid1 = FACEBOOK_UID
 )
)

where EVENT_ID is the event id you want and FACEBOOK_UID is the current user's user id.