var sw = new Stopwatch();
using (var db = new LiteDatabase(AppDomain.CurrentDomain.BaseDirectory+"sample.db"))
{
sw.Start();
var userColleciton = db.GetCollection<User>("USERS");
for (var i = 1; i <= 100_000; i++) {
var u = new User { Id = "user"+i, CreateDate = DateTime.Now, IsActive = true, Name = "USER"+i, Salary = 10*i };
u.Phones.Add(new User.Phone { Num = "09" + i, Type = "HOME" });
userColleciton.Upsert(u);
}
}
sw.Stop();
Console.WriteLine("Upsert 10w Data:");
Console.WriteLine(sw);
using (var db = new LiteDatabase(AppDomain.CurrentDomain.BaseDirectory + "sample.db"))
{
sw.Restart();
var userColleciton = db.GetCollection<User>("USERS");
var users=userColleciton.Find(Query.Contains(field: "_id", "r9999"));
sw.Stop();
Console.WriteLine("Count:"+users.Count());
foreach (var u in users)
{
Console.WriteLine(u.Id);
}
}
Console.WriteLine("Query Data:");
Console.WriteLine(sw);
