public void Any()
{
MySqlDataAdapter da = new MySqlDataAdapter(
@"SELECT a.id FROM authors a WHERE NOT EXISTS(SELECT * FROM books b WHERE b.author_id=a.id)", conn);
DataTable dt = new DataTable();
da.Fill(dt);
int i = 0;
// find all authors that are in our db with no books
using (testEntities context = new testEntities())
{
var authors = from a in context.Authors where !a.Books.Any() select a;
string sql = authors.ToTraceString();
foreach (Author a in authors)
Assert.AreEqual(dt.Rows[i++]["id"], a.Id);
}
}