private static void ProfilingUpdateMany(ISisoDatabase database, int customerNoFrom, int customerNoTo)
{
var stopWatch = new Stopwatch();
stopWatch.Start();
using (var session = database.BeginWriteSession())
{
session.UpdateMany<Customer>(
c => c.CustomerNo >= customerNoFrom && c.CustomerNo <= customerNoTo,
customer => { customer.Firstname += "Udated"; });
}
stopWatch.Stop();
Console.WriteLine("TotalSeconds = {0}", stopWatch.Elapsed.TotalSeconds);
using (var rs = database.BeginReadSession())
{
var rowCount = rs.Query<Customer>().Count();
Console.WriteLine("Total rows = {0}", rowCount);
}
}
private static void InsertCustomers(IList<Customer> customers, ISisoDatabase database)
{
using (var unitOfWork = database.BeginWriteSession())
{
unitOfWork.InsertMany(customers);
}
}
