How to get data from multiple objects using linq in C#

Question

1.00/5 (2 votes)

See more:

I have 3 classes
Organization Table
orgId
orgName
partyId

Agency Table
agencyObjectId
partyId

Serice Table
serviceId
agencyObjectId

Agent
partyId
agentName

How to get service details for aget using agency table details

What I have tried:

I have tried
var result GetOrganizationdetails().Where(x=>x.agentPartyId = agentpartyid);

var result2 GetAgenydetails().Where(x=>x.agentPartyId = agentpartyid);

var result3 GetServicedetails().Where(x=>x.agencyObjectId= agencyObjectId);

<pre>var result4 GetAgenttails().Where(x=>x.partyId= partyId);

how to achieve using linq query

Posted 22-Dec-22 0:39am

Member 15090354

Add a Solution

Comments

Richard Deeming 22-Dec-22 6:43am

You say you have three classes, then show the properties for four classes with no obvious connection between them.

You'll need to join the tables together. But since you haven't shown any connection between the classes, we can't tell you how.

You're also using the assignment operator (=) where you should be using the equality operator (==) - but that's probably just a typo in your question.

Member 15090354 22-Dec-22 13:43pm

How to convert from sql qery to linq
Select * from Employee emp where empId
in (select pId from EmpRelationShip where childId in (select pid from Employee emp1
Join EmpRelationShip emprs on emprs.cId= emp1.ahid
Where empObjectId in (select agencyobjectId from Employee
Where empid=384)
))

[no name] 23-Dec-22 7:53am

https://learn.microsoft.com/en-us/answers/questions/96372/how-to-convert-raw-sql-to-entity-linq.html

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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