public virtual void TestSelectDistinctCount()
{
// cannot do: SELECT COUNT(DISTINCT some-colum) FROM some-table
// because COUNT(DISTINCT some-column) does not count nulls
var cnt = db.Customers.Select(c => c.City).Distinct().Count();
AssertValue(69, cnt);
}