LiteDB簡單範例

以前要做簡單的資料儲存，都會優先使用SQLite，後來發現還有更方便的函式庫：LiteDB。下面程式碼是簡單的CRUD：

var db = new LiteDatabase(@"MyData.db");

var col = db.GetCollection<Person>("persons");
Person person = new Person
{
    Name = Guid.NewGuid().ToString(),
    Age = 19,
};
var ret = col.Insert(person);

var list = col.FindAll();
foreach (var item in list)
{
    Console.WriteLine(item.Id);
    Console.WriteLine(item.Name);
    Console.WriteLine(item.Age);
    Console.WriteLine();
}

Console.WriteLine("條件式");
var query = col.Query().Where(x => x.Age == 19).Select(x => new { x.Name }).ToEnumerable();
foreach (var item in query)
{
    Console.WriteLine(item.Name);
}

Person u = col.Query().Where(x => x.Name == "GUID").First();
u.Age = 33;
col.Update(u);

public class Person
{
    public int Id { get; set; } = 0;
    public string Name { get; set; } = string.Empty;
    public int Age { get; set; } = 0;
}

參考資料

LiteDB Docs