static void Main(string[] args)
{
Console.WriteLine("LITE DB v5");
Console.WriteLine("===========================================================");
//var cn = @"filename=d:\appPWD.db; password=abc";
File.Delete(@"d:\app.db");
File.Delete(@"d:\app-log.db");
//using (var repo = new LiteRepository(cn))
//{
// repo.Database.UserVersion = 99;
//}
var sw = new Stopwatch();
using (var e = new LiteEngine(new EngineSettings {
Filename = @"d:\app.db"
}))
{
sw.Start();
// insert 5.000 docs
//e.Insert("col1", Enumerable.Range(1, 5000).Select(x => new BsonDocument { ["_id"] = x }), BsonAutoId.Int32);
foreach (var d in Enumerable.Range(1, 5000).Select(x => new BsonDocument {
["_id"] = x
}))
{
e.Insert("col1", new BsonDocument[] { d }, BsonAutoId.Int32);
}
e.Checkpoint();
sw.Stop();
}
Console.WriteLine("Time: " + sw.ElapsedMilliseconds);
//
//using (var repo = new LiteRepository(cn))
//{
// var u = repo.Database.UserVersion;
//
// Console.WriteLine(u);
//
// var mau = repo.FirstOrDefault<BsonDocument>(x => x["_id"] == 1, "col1");
// //
// Console.WriteLine("dados:" + mau["n"].AsString);
//
//}
Console.WriteLine(" ===========================================================");
Console.WriteLine("End");
Console.ReadKey();
}
private void CreateDatabase(LiteEngine engine)
{
engine.Insert("mycol", new[]
{
new BsonDocument
{
["_id"] = 1,
["name"] = "Mauricio"
}
}, BsonAutoId.Int32);
// do checkpoint to use only data file
engine.Checkpoint();
}