How to fetch data from database for a particular FB account?

Question

I am using C# MVC Web Application & MongoDB 3.2

I have to do Facebook integration with the C# MVC Web Application. When user logs into Facebook & navigates to custom page, automatically data should be fetched from MongoDB database for that particular Facebook account & shown in the Facebook page in an iFrame.

Please suggest solution for above task.

Thanks in advance.

Answer 1

Hi,

I don't think it is possible to achieve what you are looking with a single select query.

You won't get distinct from every columns while selecting multiple columns. Because distinct keyword considers whether a single row is distinct or not. Not a column. Please have a look at below link -

http://dba.stackexchange.com/questions/102677/select-distinct-on-multiple-columns

Answer 2

your logic is true

could you post the screenshots of the table with data