Entity Framework : join two tables and where clause
I'm having trouble working with Entity Framework and PostgreSQL, does anybody know how to join two tables and use the second table as a where clause? The select I want to do in Entity Framework would be in SQL: SELECT ai.id, ai.title, ai.description, ai.coverimageurl FROM app_information ai INNER JOIN app_languages al on al.id = ai.languageid WHERE al.langua
