How to import xml data to sql server using c#

Question

Biswa Pujarini Mohapatra · Answer

you can parse the xml as per your requirement ad insert into db am showing one e.g below XML file abc Abc@live.com xyz xyz@live.com aaa Abcss@outlook.com Code file XDocument doc = XDocument.Load(@D:\PracticeProjects\ConsoleApplication1\ConsoleApplication1\XMLFile1.xml); var Items = doc.Descendants(Employee) .Select(x => new { Name = (string)x.Element(Name) Email = (int?)x.Element(Email) }).ToList(); using (SqlConnection conn = new SqlConnection(***************)) { foreach (var item in Items) { using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = Insert INTO Emplyee (NameEmail) VALUES (@Name@Email);; cmd.Parameters.AddWithValue(@Name item.Name); cmd.Parameters.AddWithValue(@Email (object)item.Email ?? DBNull.Value); cmd.ExecuteNonQuery(); } } } hope it helps