How to use Join with LINQ
using System; using System.Linq; using System.Configuration; public partial class LINQWithJoin : System.Web.UI. Page { TestDataClassesDataContext objDBContext = new TestDataClassesDataContext ( ConfigurationManager .ConnectionStrings[ "TestConnectionString" ].ToString()); protected void Page_Load( object sender, EventArgs e) { } protected void btnDisplay_Click( object sender, EventArgs e) { var Allcity = from city in objDBContext.City_Tbls join state in objDBContext.State_Tbls on city.State_Id equals state.State_Id select new ...