private static void SingelThread_SQLite()
{
var dbFactory = new OrmLiteConnectionFactory(
"App_Data/db.sqlite", SqliteDialect.Provider);
using (IDbConnection db = dbFactory.Open()) {
db.DropAndCreateTable <StringPOCO>();
Console.WriteLine("SingelThread_SQLite");
Stopwatch sw = Stopwatch.StartNew();
for (int i = 0; i < 1000; i++)
{
string key = Guid.NewGuid().ToString();
var poco = new StringPOCO()
{
Key = key,
Value = key,
};
db.Save(poco);
var savedpoco = db.SingleById <StringPOCO>(key);
if (savedpoco.Value != key)
{
throw new Exception();
}
}
sw.Stop();
Console.WriteLine(sw.Elapsed);
}
}
private static void SingelThread_SQLite()
{
var dbFactory = new OrmLiteConnectionFactory(
"App_Data/db.sqlite", SqliteDialect.Provider);
using (IDbConnection db = dbFactory.Open()) {
db.DropAndCreateTable<StringPOCO>();
Console.WriteLine("SingelThread_SQLite");
Stopwatch sw = Stopwatch.StartNew();
for (int i = 0; i < 1000; i++) {
string key = Guid.NewGuid().ToString();
var poco = new StringPOCO() {
Key = key,
Value = key,
};
db.Save(poco);
var savedpoco = db.SingleById<StringPOCO>(key);
if (savedpoco.Value != key) throw new Exception();
}
sw.Stop();
Console.WriteLine(sw.Elapsed);
}
}
