Category: Entity Framework

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 →

I got this strange issue today, and was struggling to fix this. This issue is related to the SQL 2008 and 2005 compatibility. I had a local machine with SQL 2008, but the Dev environment is with SQL 2005. When i generated the Entities using EF in my local machine it had marked it with... Continue Reading →