How to make a request "is uid X participating in event Y"

Question

How to make a request “is uid X a visit to event Y” using ASP.NET toolkit?

Do I need to use Facebook SQL?

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

Answer 1

The following FQL call should handle the following:

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 identifier of the event you want, and FACEBOOK_UID is the current user identifier.

Answer 2

This can be done using the chart API. Try executing a GET request in this form:

/[event id]/invite? user = [user_id] & access_token = [access_token]

rsvp_status, RSVPed, , "". , RSVPed.