public void TestLinqFirstOrDefault()
{
var connectionString = GetConnectionString("TestLinqFirstOrDefault");
var context = new MyEntityContext(connectionString);
var pe = context.Persons.Create();
pe.Name = "Eddie";
var pb = context.Persons.Create();
pb.Name = "Bill";
var pf = context.Persons.Create();
pf.Name = "Freddie";
var pd = context.Persons.Create();
pd.Name = "Dennis";
var pc = context.Persons.Create();
pc.Name = "Carole";
var pa = context.Persons.Create();
pa.Name = "Annie";
context.SaveChanges();
Assert.AreEqual(6, context.Persons.Count());
var first = context.Persons.Where(p => p.Name.Equals("Annie")).FirstOrDefault();
Assert.IsNotNull(first);
Assert.AreEqual("Annie", first.Name);
var notfound = context.Persons.Where(p => p.Name.Equals("Jo")).FirstOrDefault();
Assert.IsNull(notfound);
}