In this blog post you will learn inner join using lambda queries. There will be two samples, in first sample you will see how you can join two tables and in second sample you will see how you can extend even further to join three tables and so on. I will sample in-memory data, but the same implementation will work with IQueryable (lazy query) too. Here's the code snippet:- namespace ConsoleApp1 { class Program { static void Main() { var table1 = new List<Table1>(); table1.Add( new Table1 { Id = 1, Name = "Name 1" , Address = "Address 1" }); table1.Add( new Table1 { Id = 2, Name = "Name 2" , Address = "Address 2" }); table1.Add( new Table1 { Id = 3, Name = "Name 3" , Address = "Address 3" }); table1.Add( new Table1 { Id = 4, Name = "Name 4" , Address = "Address 4" });
Hi Abhi (Abhimanyu) Sir, Its very nice as usual like your all blogs. Its very helpful for me for my learning process. I wanted to know about WCF Sir. Could u help me for this? I don't know about this technology.
ReplyDeletethanks. let me put your request in TODO list.
DeleteReally a wonderful Explanation about Edmx. You had given new tips inside the edmx file.I am really say thanks to you. Your blog and information's are all nice. Wonderful Job.It is Help To Database beginners and developers for each and everyone.
ReplyDeleteThank you sir very help full video because it is in Hindi. Thanks a lot!
ReplyDelete