我想用with 4 table写lambda expesion。得到的结果是Electiionresponse值 [英] i want to write lambda expesion using with is 4 table. get result is Electiionresponse value

问题描述

我有4张桌子。用ER图链接到gathere。从4个表我想要通常的选举响应值。我想使用lambda表达式连接四个表。

var statements = db.Statements.Where（s => s.DivisionID == division.DivisionID）;



var Ec = statements.Count（s => s。）;



i有4张桌子

1）分工

2）声明

3）选举

4）选举回应



1）除法表：主键是divisionid

2）语句表：主键是statementid（Frkey divisionid）

3）选举表：主键是statementid ，frk voteresponseid

4）选举回应表：主键选举回应



i想从选举回应中选举回应价值

$ / b
这些表之间的通货紧缩船

分区表是一个而且声明表很多

staement表是一个而选表是多少

选举响应表是一个，选举可能是

关系是这样的



我想选举回应价值。使用lambda expresion

解决方案

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.);

i have 4 tables
1)division
2)satement
3)election
4)election response

1)division table: primary key is divisionid
2)statement table: primary key is statementid(Frkey divisionid)
3)election table :primary key is statementid,frk electionresponseid
4)election response table:primary key electionresponseid

i want to electionresponse value from Election response talbe

rlation ship betweent these table
division table is one and statement table is many
staement table is one and election table is many
election response table is one and election is may
relation are like this

i want to election response value. using with lambda expresion

解决方案

这篇关于我想用with 4 table写lambda expesion。得到的结果是Electiionresponse值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！