使用ObjectContext获取数据

问题描述

我想知道以下Linq查询如何执行

I want to know how the following Linq query executes

var query = from teamRoles in this.ObjectContext.TRoles
                        join team in this.ObjectContext.Teams on teamRoles.teamId equals team.id
                        join teamMembers in this.ObjectContext.TMembers on team.id equals     teamMembers.teamId
                        join agent in this.ObjectContext.Agents on teamMembers.agentId equals agent.id where team.agencyId == agencyId  && teamRoles.role == (int)role
                        select agent;

以上代码是否会从每个表中获取数据处理Web服务器中的查询还是修改查询并将单个查询语句发送到数据库服务器？



谢谢，

Prasaadsj

Does the above code will get data from each table and process the query in the web server or will it modifies the query and send a single query statement to Database server?

Thanks,
Prasaadsj

推荐答案

这篇关于使用ObjectContext获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！