public void CouldCreateTableAndInsertManyDataObject()
{
var Persistor = new DatabasePersistor(guidType: SequentialGuidType.SequentialAsBinary);
var sw = new Stopwatch();
sw.Start();
var list = new List <TestDataObject>();
for (int i = 0; i < 1000; i++)
{
var dobj = new TestDataObject()
{
Value = "inserted"
};
//Persistor.Insert(dobj);
list.Add(dobj);
}
Persistor.Insert(list);
sw.Stop();
Console.WriteLine("Elapsed: " + sw.ElapsedMilliseconds);
}
public void CouldCreateTableAndCrudDataObject()
{
var Persistor = new DatabasePersistor(guidType: SequentialGuidType.SequentialAsBinary);
for (int i = 0; i < 10; i++)
{
var dobj = new TestDataObject()
{
Value = "inserted"
};
Persistor.Insert(dobj);
var fromDb = Persistor.GetById <TestDataObject>(dobj.Id);
Assert.AreEqual("inserted", fromDb.Value);
fromDb.Value = "updated";
Persistor.Update(fromDb);
fromDb = Persistor.GetById <TestDataObject>(dobj.Id);
Assert.AreEqual("updated", fromDb.Value);
}
}
public void CouldCreateTableAndCrudDataObject()
{
var Persistor = new DatabasePersistor(guidType: SequentialGuidType.SequentialAsString, migrationConfig: new MySqlMigrationsConfiguration());
for (int i = 0; i < 1; i++)
{
var dobj = new TestDataObject()
{
Value = "inserted",
DateTime = DateTime.UtcNow
};
Persistor.Insert(dobj);
var fromDb = Persistor.GetById <TestDataObject>(dobj.Id);
Assert.AreEqual("inserted", fromDb.Value);
fromDb.Value = "updated";
Persistor.Update(fromDb);
fromDb = Persistor.GetById <TestDataObject>(dobj.Id);
Assert.AreEqual("updated", fromDb.Value);
}
}
public void CouldCreateTableAndInsertManyDataObject() {
var Persistor = new DatabasePersistor(guidType: SequentialGuidType.SequentialAsBinary);
var sw = new Stopwatch();
sw.Start();
var list = new List<TestDataObject>();
for (int i = 0; i < 1000; i++) {
var dobj = new TestDataObject() {
Value = "inserted"
};
//Persistor.Insert(dobj);
list.Add(dobj);
}
Persistor.Insert(list);
sw.Stop();
Console.WriteLine("Elapsed: " + sw.ElapsedMilliseconds);
}
public void CouldCreateTableAndCrudDataObject() {
var Persistor = new DatabasePersistor(guidType: SequentialGuidType.SequentialAsString, migrationConfig: new MySqlMigrationsConfiguration());
for (int i = 0; i < 1; i++) {
var dobj = new TestDataObject() {
Value = "inserted",
DateTime = DateTime.UtcNow
};
Persistor.Insert(dobj);
var fromDb = Persistor.GetById<TestDataObject>(dobj.Id);
Assert.AreEqual("inserted", fromDb.Value);
fromDb.Value = "updated";
Persistor.Update(fromDb);
fromDb = Persistor.GetById<TestDataObject>(dobj.Id);
Assert.AreEqual("updated", fromDb.Value);
}
}
