xmltolinq

Question

linq query for inserting data into xml with out entering duplicate records

Rodrigo Bereta · Answer

Hi Santhi XElement Departments = new XElement(Departments new XElement(Department new XElement(DepartmentID 1) new XElement(Name Sales) new XElement(GroupName Sales and Marketing) new XElement(ModifiedDate 1/6/1998 00:00:00) ) ); IEnumerable myDep = from dep in Departments.Descendants(Department) where (string)dep.Element(Name) == Sales select dep; if (myDep.Count() == 0) { Departments.Add( new XElement(Department new XElement(DepartmentID 1) new XElement(Name Sales) new XElement(GroupName Sales and Marketing) new XElement(ModifiedDate 1/6/1998 00:00:00) )); } Regards