Category: LINQ

02 Jun 2014 06:14

Joined:	29/06/2011
Level:	Silver
Points:	333

Points:	3

How to get Data from two table using Join in LIST?

Please tell me how can i get the result using join

my code is here....

from A in _db.T1
join B in _db.T2 on A.IM_ID equals B.IM_ID
where A.PropertyID == PropertyID
select new { A.IM_ID, B.IM_Rate, A.IM_Code, A.IM_Title }

i want it in LIST but it will not return or if possible to return data in dataset.

Thanks,
Atul Sharma

#746089

02 Jun 2014 07:07

Joined:	28/04/2006
Level:	Gold
Points:	30349

Points:	3

Hai Atul,
If you want the data should be returned as the List, then you need to create a list first by creating a class and then you can return the records and assign to the same class object so that it will have the records in the list and then you can do the operations to search, select etc.
Hope it will be helpful to you.

Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com

#746090

02 Jun 2014 07:09

Joined:	12/03/2014
Level:	Silver
Points:	190

Points:	2

Hi Atul Sharma,

your requirements seems that you want the resultset data into dataset by using linq to sql joins

Refer the following link

http://msdn.microsoft.com/en-us/library/bb386921(v=vs.110).aspx

http://www.mssqltips.com/sqlservertip/2504/using-linq-to-join-data-from-multiple-sql-servers/

Hope it will helpful

Regards
Bhavana Ky

#746129

03 Jun 2014 03:41

Joined:	28/06/2007
Level:	Diamond
Points:	56294

Points:	3

I would suggest to create a Model class containg all the fields which you want to return from Query and then return the value as


Var ReturnModelClassObject = 

(from A in _db.T1
join B in _db.T2 on A.IM_ID equals B.IM_ID
where A.PropertyID == PropertyID
select new ModelClassname()
 {
  A.IM_ID, 
  B.IM_Rate, 
  A.IM_Code, 
  A.IM_Title 
 }
);

Thanks & Regards
Anil Kumar Pandey
Microsoft MVP, DNS MVM

#747910

24 Jul 2014 02:48

Joined:	21/01/2014
Level:	Silver
Points:	134

Points:	2

hello
If you want to return data from two table in list then you have to Create such a class including the fields you return.
and then in select statement you have to return that fields in list.

Thanks
Umesh Bhosale

#747938

24 Jul 2014 05:37

Joined:	29/06/2011
Level:	Silver
Points:	333

Points:	1

Hi Bhavana, Anil and Umesh,
please understand my problem then give answer, i want exactly , all records of five or more tables columns using join.

i have already test this...

Thanks,

#747939

24 Jul 2014 05:38

Joined:	29/06/2011
Level:	Silver
Points:	333

Points:	1

Hi Anil,

i have lot of records so that i want return all columns, please suggest another way.

thanks,

Atul

How to get Data from two table using Join in LIST?

Email subscription

About dotnetspider.com

Quick Links

General

Services