C# join tables using IQueryable in LINQ

Yesterday I was struggling with how to Join tables using IQueryable in C# or Asp.Net and return it in List. So, here I’m with the solution. Let’s start..

With the introduction of LINQ the difference between writing code for  accessing a list of data in an external data source like SQL Server is vanishing. With the introduction of .NET Framework 4.0 this has changed.In this post i would like to filter my SQL data employing 2 tables.

In my project I’ve 2 tables. 1: Containing all the basic user data like Full Name, DOB etc and 2nd containing user’s student id, card number and so on.. I’ve needed a Data like this: Full Name [Roll Number]

So, here’s the code

var query = (from a in DbInstance.User_Account
join s in DbInstance.User_Student on a.Id equals s.Id
where s.Status == 1
select new { a, s } into t1
select new
{
Id = t1.a.Id.ToString(),
Name = string.Concat(t1.a.FullName.ToString(), ” [“, t1.s.RollNumber.ToString(), “]”)
}).ToList();

Windows KMS Activator Ultimate 2018 4.2

Windows KMS Activator Ultimate is the most simple and user-friendly activator for Windows Server, Windows Vista, Windows 7, 8.1, 10. It is a safe activator, without harm to system files. The Windows activation period is 180 days, and you can renew it after its expiry. You can delete all previous activation. You can find out information about your activation and the current activation status of your Windows.

Instructions:
– Install the program
– Run as administrator
– Click “Clean Activation History”.
– Click Update Server to update the Update KMS Server.
– Select your OS type.
– Click “Activate Now”.
– Done, enjoy it!

Latest Windows KMS Activator Ultimate 2017 CAN the BE activated
the Windows 10, all versions
the Windows 8.1, all versions
the Windows 8.1, the Preview all versions
the Windows 8, all versions
the Windows 7 Professional
the Windows 7 Enterprise
the Windows Vista Business
the Windows Vista Enterprise
the Windows Server 12, all versions
the Windows Server 08, all versions

For Permanent Activation
Click on the “Activation Permanent Now” Activate:
Windows Vista Business / Enterprise
Windows 7 Professional / Enterprise
Windows 8 / 8.1 / 10 All
Office 2010/2013/2016 Preview
Windows Server 2008 / 2008R2 / 2012 / 2012R2 / 2016

System Requirements
Net Framework 2.0
Internet connection
What’s new in 4.2
– the add “the Digital License Activation” tool by s1ave77 for permanent activation
– the Can the activate the latest version of windows 10
– Fixed For All Bugs.

So, why are you waiting for? Download from here