public void TestLinqContainsDateTime()
{
var connectionString = GetConnectionString("TestLinqContainsDateTime");
var context = new MyEntityContext(connectionString);
var e1 = context.TestEntities.Create();
var now = DateTime.Now;
e1.SomeString = "Networked Planet";
e1.CollectionOfStrings = new List<string> { "Jen", "Kal", "Gra", "Andy" };
e1.CollectionOfDateTimes = new List<DateTime>() { now.AddYears(2), now.AddYears(4) };
var e2 = context.TestEntities.Create();
e2.SomeString = "Samarind";
e2.CollectionOfStrings = new List<string> { "Miranda", "Sadik", "Tobey", "Ian" };
e2.CollectionOfDateTimes = new List<DateTime>() { now.AddYears(1), now.AddYears(3) };
context.SaveChanges();
Assert.AreEqual(2, context.TestEntities.Count());
var containsDateTime =
context.TestEntities.Where(e => e.CollectionOfDateTimes.Contains(now.AddYears(2))).ToList();
Assert.IsNotNull(containsDateTime);
Assert.AreEqual(1, containsDateTime.Count);
Assert.AreEqual("Networked Planet", containsDateTime.First().SomeString);
}