{
    public int Id { get; set; }
    public int Age { get; set; }
    public string Name { get; set; } = string.Empty;
    public string[] Phone { get; set; }
    public bool IsActive { get; set; }
}

    // 打開數(shù)據(jù)庫，如果不存在就會自動創(chuàng)建
    var db = new LiteDatabase(@"MyData.db");
    // 增刪改查案例
    // 獲取Student集合對象
    var col = db.GetCollection<Student>("student");
    for(int i = 1; i < 10; i++) 
    {
        var student = new Student()
        {
            Id = i,
            Age = 18+i,
            Name = "Test",
            Phone = new string[] { "8000-1000"+i, "1001-8080"+i },
            IsActive = true, 
         };
        // 數(shù)據(jù)插入
        col.Insert(student);
    }
    // 在id字段上創(chuàng)建唯一索引
    col.EnsureIndex(x => x.Id, true);
    // 數(shù)據(jù)查詢
    List<Student> list = col.Find(x => x.Age > 20).ToList();
    Student user = col.FindOne(x => x.Id == 1);
    Console.WriteLine($"Lite數(shù)據(jù)庫中共有{list.Count}人年齡大于20的人");
    foreach (Student stu in list)
    {
        ShowInfo(stu);
    }
    Console.WriteLine("Lite數(shù)據(jù)庫中Id為1的人");
    ShowInfo(user);
	// 刪除所有數(shù)據(jù)
    col.DeleteAll();
}
static void ShowInfo(Student student)
{
    Console.WriteLine("姓名："+student.Name + "年齡："+student.Age);
}