private static void OpenV4Database()
{
Console.WriteLine("Create v4 database");
var connectionString = EnsureDataDirectory("DatabaseV4.db");
using (var db = new LiteDBv4.LiteDatabase(connectionString))
{
// Get customer collection
var col = db.GetCollection <Customer>("customers");
// Create your new customer instance
var customer = new Customer
{
Name = "John Doe",
Phones = new[] { "8000-0000", "9000-0000" },
Age = 39,
IsActive = true
};
// Create unique index in Name field
// col.EnsureIndex(x => x.Name, true);
col.Upsert(customer);
// Use LINQ to query documents (with no index)
var results = col.Find(x => x.Age > 20);
// Dump(results.ToList());
}
}
public static void CreateDatabases()
{
Console.WriteLine("Create v4 database");
using (var db = new LiteDBv4.LiteDatabase(EnsureDataDirectory("DatabaseV4.db")))
{
// Get customer collection
var col = db.GetCollection <Customer>("customers");
// Create your new customer instance
var customer = new Customer
{
Name = "John Doe",
Phones = new string[] { "8000-0000", "9000-0000" },
Age = 39,
IsActive = true
};
// Create unique index in Name field
// col.EnsureIndex(x => x.Name, true);
col.Upsert(customer);
// Use LINQ to query documents (with no index)
var results = col.Find(x => x.Age > 20);
Dump(results.ToList());
}
Console.WriteLine();
Console.WriteLine("Create v5 database");
using (var db = new LiteDBv5.LiteDatabase(EnsureDataDirectory("DatabaseV5.db")))
{
// var jsonInfo = JsonConvert.SerializeObject(LiteDBv5., Formatting.Indented);
// Get customer collection
var col = db.GetCollection <Customer>("customers");
// Create your new customer instance
var customer = new Customer
{
Name = "Julian Paulozzi",
Phones = new string[] { "6000-0000", "7000-0000" },
Age = 24,
IsActive = false
};
// Create unique index in Name field
// col.EnsureIndex(x => x.Name, true);
col.Upsert(customer);
// Use LINQ to query documents (with no index)
var results = col.Find(x => x.Age > 20);
Dump(results.ToList());
}
}
