public void TestLinqContainsString()
{
var connectionString = GetConnectionString("TestLinqContainsString");
var context = new MyEntityContext(connectionString);
var e1 = context.TestEntities.Create();
e1.SomeString = "Networked Planet";
e1.CollectionOfStrings = new List<string> {"Jen", "Kal", "Gra", "Andy"};
var e2 = context.TestEntities.Create();
e2.SomeString = "Samarind";
e2.CollectionOfStrings = new List<string> {"Miranda", "Sadik", "Tobey", "Ian"};
context.SaveChanges();
Assert.AreEqual(2, context.TestEntities.Count());
var containsString = context.TestEntities.Where(e => e.CollectionOfStrings.Contains("Jen")).ToList();
Assert.IsNotNull(containsString);
Assert.AreEqual(1, containsString.Count());
Assert.AreEqual("Networked Planet", containsString.First().SomeString);
var matchTargets = new List<string> {"Samarind", "IBM", "Microsoft"};
var matchCompanies = context.TestEntities.Where(e => matchTargets.Contains(e.SomeString)).ToList();
Assert.IsNotNull(matchCompanies);
Assert.AreEqual(1, matchCompanies.Count);
Assert.AreEqual("Samarind", matchCompanies.First().SomeString);
}