LINQ to XML using join, group by order by query

We can use LINQ to write a complex query like join and group by operations. The below sample shows a simple join query and the group by command in 2 XML files. I use the 2 xml files firstxml.xml and secondxml.xml FirstXml.Xml <dataroot>  <Names>    <NAME_ID>1121</NAME_ID>    <PARENTS_NAME_ID>Selvan</PARENTS_NAME_ID>  </Names>  <Names>    <NAME_ID>1122</NAME_ID>    <PARENTS_NAME_ID>Sen</PARENTS_NAME_ID>  </Names></dataroot> SecondXml.Xml <dataroot>  <Info>    <INFO_NAME_ID>1121</INFO_NAME_ID>   ... Continue Reading →

Entity Framework Connection String

  Code Snippet using System.Data.EntityClient;               EntityConnectionStringBuilder entityConString = new EntityConnectionStringBuilder()             {                 Metadata = @"res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl",                 Provider = "System.Data.SqlClient",                 ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder                 {                     InitialCatalog = dbname,                     DataSource = servername,                     IntegratedSecurity = false,                     UserID = user,                     Password = pwd                 }                   .ConnectionString             };             return entityConString.ToString();

Create a website or blog at

Up ↑