ID(pk) Sid remarks 1 2 15 2 2 14 3 1 11 Sid EAId(pk) Sid location 1 2 hyd 2 1 dehi 3 2 Che above i Have two tables llike above based on SID get all records and compare with EAID and get Location in LINQ

var data = (from tbl1 in _dbcontext.table1 join tbl2 in _dbcontext.table2 on tbl1.sid equals tbl2.sid select new {tbl2.location } ).ToList();

var data = (from inv in _context.table1 join req in _context.table2 on inv.sid equals req.sid select new viewModel {location = req.location } ).ToList();

My Question is to get Location name Based on table 1 SID and Table 2 SID Get EAID and EAID related Location Name need No foreign keys on both the tables pls Help LINQ Query

Please update your question and provide desired output and explain that output also.

Answers

Join two tables

Pramod M

554

ID(pk)	Sid	remarks
1	2	15
2	2	14
3	1	11

Sid

EAId(pk)	Sid	location
1	2	hyd
2	1	dehi
3	2	Che

above i Have two tables llike above based on SID get all records and compare with EAID and get Location in LINQ

Answers (4)

Next Recommended Forum

Otp Verification with in 5 minutes

comma separated values

Leaderboard

View all

Shubhankar Banerjee

-1

Magnus Mårtensson

Bhasker Das

-1

View all

Yesterday's leader

Shubhankar Banerjee

Blockchain, Solidity, Polygon, C#, NodeJS, HTML, C Language, C++, JavaScript, CSS, ReactJS, MySQL

Kanpur (India)

165

113.8k

11.3k

500

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

188

283.7k

10.4k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

17.2k

56.5k

Upcoming events

View all

Suggested for you

View all

Satya Karki

Chris Love

Vishal Joshi

Vijay Pratap Singh

Basant Kumar

Forum Statistics

Please welcome our newest member luan .
3,075,564 users have contributed to 147,419 threads and 483,388
In the past 24 hours, we have 10 new threads, 28 new posts, and 200 new users.
In last week, the most popular thread is 'Query result in HTML format'.