C#和SQLite；插入多对多关系的最佳代码

// 假设有两个表：Students（学生）和Courses（课程），它们之间是多对多的关系

// 创建一个SQLite连接
using (var connection = new SQLiteConnection("Data Source=database.db"))
{
    connection.Open();

    // 插入学生数据
    var student1 = new Student { Name = "张三" };
    var student2 = new Student { Name = "李四" };
    var student3 = new Student { Name = "王五" };

    connection.Insert(student1);
    connection.Insert(student2);
    connection.Insert(student3);

    // 插入课程数据
    var course1 = new Course { Name = "数学" };
    var course2 = new Course { Name = "英语" };
    var course3 = new Course { Name = "物理" };

    connection.Insert(course1);
    connection.Insert(course2);
    connection.Insert(course3);

    // 插入多对多关系数据
    var studentCourse1 = new StudentCourse { StudentId = student1.Id, CourseId = course1.Id };
    var studentCourse2 = new StudentCourse { StudentId = student1.Id, CourseId = course2.Id };
    var studentCourse3 = new StudentCourse { StudentId = student2.Id, CourseId = course2.Id };
    var studentCourse4 = new StudentCourse { StudentId = student3.Id, CourseId = course3.Id };

    connection.Insert(studentCourse1);
    connection.Insert(studentCourse2);
    connection.Insert(studentCourse3);
    connection.Insert(studentCourse4);
}

// 数据模型类
public class Student
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }
    public string Name { get; set; }
}

public class Course
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }
    public string Name { get; set; }
}

public class StudentCourse
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }
    public int StudentId { get; set; }
    public int CourseId { get; set; }
}