Technical questionAccepted answer
Entity Framework : join two tables and where clause
Àlex
May 14
0 views1
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.languagecode = 'es'
Currently I have this
var appInformationToReturn = context.app_information
.Join(
context.app_language,
ai => ai.languageid,
al => al.id,
(ai, al) => new AppInformation()
{
id = ai.id,
title = ai.title,
description = ai.description,
coverimageurl = ai.coverimageurl
})
.Where()
.FirstOrDefault();
I don't know how to build the where clause.
postgresql1 answer
Accepted answer · original discussion
Afshin Mobayen Khiabani
PermalinkMay 14
Like this:
var appInformationToReturn = context.app_information
.Join(
context.app_language,
ai => ai.languageid,
al => al.id,
(ai, al) => new
{
id = ai.id,
title = ai.title,
description = ai.description,
coverimageurl = ai.coverimageurl,
lang = al.languagecode
})
.Where(x => x.lang == "es")
.Select(x => new AppInformation()
{
id = x.id,
title = x.title,
description = x.description,
coverimageurl = x.coverimageurl
})
.FirstOrDefault();
Update (2023/03/26): Lately this answer got some attention so I decided to update and combine it with the first part of the answer provided by @Serge.
var item = (
from ai in context.app_information
join al in context.app_language on ai.languageid equals al.id
where (al.languagecode == "es")
select new AppInformation
{
id = ai.id,
title = ai.title,
description = ai.description,
coverimageurl = ai.coverimageurl
}).FirstOrDefault();
0 question comments
Use comments to ask for clarification. Post a solution as an answer.
No question comments on this page.