public void WriteAndReadBack()
{
var sw = new Stopwatch();
sw.Start();
using (var context = new TestContext("Server=.;Initial Catalog=TestDb;Integrated security=True;"))
{
Console.WriteLine("Init " + sw.Elapsed);
sw.Restart();
var guid = Guid.NewGuid();
var newEntity = new ClassD
{
EntityId = guid,
Name = "Lorem ipsum",
NumberOfSomething = 5
};
context.TestTable.Add(newEntity);
Console.WriteLine("Add " + sw.Elapsed);
sw.Restart();
context.SaveChanges();
Console.WriteLine("Persist " + sw.Elapsed);
sw.Restart();
var storedEntity = context.TestTable.SingleOrDefault(e => e.EntityId == guid);
Console.WriteLine("Select " + sw.Elapsed);
Assert.IsInstanceOfType(storedEntity, typeof(ClassD));
var classD = (ClassD) storedEntity;
Assert.AreEqual(classD.Name, newEntity.Name);
Assert.AreEqual(classD.NumberOfSomething, newEntity.NumberOfSomething);
Assert.AreNotEqual(classD.Id, 0);
}
}
public void InsertNotInTransactionSpeed()
{
using (var context = new TestContext("Server=.;Initial Catalog=TestDb;Integrated security=True;"))
{
var sum = new Stopwatch();
sum.Start();
var sw = new Stopwatch();
sw.Start();
for (var i = 0; i < 100; i++)
{
var guid = Guid.NewGuid();
var newEntity = new ClassD
{
EntityId = guid,
Name = "Lorem ipsum",
NumberOfSomething = 5
};
context.TestTable.Add(newEntity);
Console.WriteLine("Add " + sw.Elapsed);
sw.Restart();
context.SaveChanges();
Console.WriteLine("Persist " + sw.Elapsed);
sw.Restart();
}
Console.WriteLine("-----");
Console.WriteLine(sum.Elapsed);
}
}