public void SkipAndTakeWithOrdering()
{
using (testEntities context = new testEntities())
{
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Companies ORDER BY Name DESC LIMIT 2,2", conn);
DataTable dt = new DataTable();
da.Fill(dt);
int i = 0;
var query = context.Companies.OrderByDescending(q => q.Name).Skip(2).Take(2).ToList();
foreach (Company c in query)
Assert.AreEqual(dt.Rows[i++]["Name"], c.Name);
}
}
}