public void TestLinqSingleOrDefault()
{
var connectionString = GetConnectionString("TestLinqSingleOrDefault");
var context = new MyEntityContext(connectionString);
var sod = context.TestEntities.SingleOrDefault();
Assert.IsNull(sod);
var entity = context.TestEntities.Create();
entity.SomeString = "An entity";
context.SaveChanges();
Assert.AreEqual(1, context.TestEntities.Count());
var single = context.TestEntities.SingleOrDefault();
Assert.IsNotNull(single);
Assert.AreEqual("An entity", single.SomeString);
for (var i = 1; i < 10; i++)
{
var e = context.TestEntities.Create();
e.SomeInt = i;
}
context.SaveChanges();
Assert.AreEqual(10, context.TestEntities.Count());
//var sod = context.Entities.SingleOrDefault();
//Assert.IsNull(sod);
}