Click here to Skip to main content
15,845,436 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I want implement inner join in my linq query.can any one send me sample of inner join used in the linq query.
Posted

 
Share this answer
 
Comments
VJ Reddy 14-Jun-12 2:13am    
Good references. 5!
Vani Kulkarni 14-Jun-12 2:21am    
Thanks VJ!
Prasad_Kulkarni 14-Jun-12 3:23am    
msdn is always best, +5 for that
Manas Bhardwaj 14-Jun-12 4:23am    
Correct +5
Vani Kulkarni 14-Jun-12 4:43am    
Thanks Manas and Prasad.
 
Share this answer
 
Comments
VJ Reddy 14-Jun-12 2:13am    
Good references. 5!
[no name] 14-Jun-12 2:14am    
Thanks VJ.
Prasad_Kulkarni 14-Jun-12 3:23am    
msdn is always best, +5 for that
Manas Bhardwaj 14-Jun-12 4:24am    
Correct +5
[no name] 14-Jun-12 4:29am    
Thank you prasad and manas.. :)
 
Share this answer
 
Comments
Vani Kulkarni 14-Jun-12 1:56am    
My 5!
Prasad_Kulkarni 14-Jun-12 3:22am    
Thank you Vani!
VJ Reddy 14-Jun-12 2:13am    
Good references. 5!
Prasad_Kulkarni 14-Jun-12 3:22am    
Thank you VJ!
Manas Bhardwaj 14-Jun-12 4:24am    
Good ref +5
var hp = from p in db.table_name1 join m in db.table_name2 on p.id equals m.o_id select new
{ Name = p.name, Order = m.order_name };
GridView1.DataSource=hp;
GridView1.DataBind();
 
Share this answer
 
Quote:
http://seesharpconcepts.blogspot.in/2012/08/performing-inner-join-and-left-outer.html[^]

This is similar information that you find on MSDN and StackOverFlow, but with a simple example and explanation.
 
Share this answer
 
C#
from st in obj.Cart_tables
                                 join x in obj.movie_details on st.movie_id equals x.Id
                                 where st.username == Session["user"].ToString()
                                 select new{x.items,st.items}
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900