xml to sqlserver （比按某属性查、直接展现（但是数据库是手动建的） 多了Grade.cs）

Grade的表数据在prac1.xml中

Student的表数据在prac2.xml中

执行之后：数据库中出现了两张表：

Grade.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml.Serialization;

namespace xmlTosqlserver1
{
   
    [XmlRoot("grades")]
    public class Grade
    {
   
        public string Id {
    get; set; }
        public string Name {
    get; set; }
        public string Course {
    get; set; }
        public int Score {
    get; set; }
    }
}

Student.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml.Serialization;

namespace xmlTosqlserver1
{
   
    [XmlRoot("students")]
    public class Student
    {
   
       
        public string sname {
    get; set; }
        public string ssex {
    get; set; }
        public int Score {
    get; set; }
    }
}

DB.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;//DataTable用到  
using System.Data.SqlClient