Click here to Skip to main content
15,789,698 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
select er.ElectionResponceValue from Election e inner join [Statement] s
on s.StatementID=e.StatementID inner join Division d
on d.DivisionID=s.DivisionID inner join ElectionResponce er
on er.ElectionResponceID=e.ElectionResponceID
where d.DivisionID=

division id are 3,5,2
Maciej Los 19-Mar-14 18:42pm    
What have you tried till now? Where are you stuck?
Member 10683298 19-Mar-14 23:48pm    
i have 4 tables. link to gathere with ER diagrams. from 4 tables i wantcommon election response value. i want to join four tables using with lambda expression.
var statements = db.Statements.Where(s => s.DivisionID == division.DivisionID);

var Ec = statements.Count(s => s.);

1 solution

First of all, please read my comment to the question.

Secondly, please, follow below links and try!
LINQ (Language-Integrated Query)[^]
Basic LINQ Query Operations (C#)[^]
How to: Write LINQ Queries in C#[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900