public void SubQueryCount([IncludeDataSources(TestProvName.AllSqlServer2008Plus)] string context)
{
using (var db = new TestDataConnection(context))
{
AreEqual(
from p in Parent
select Parent.Where(t => t.ParentID == p.ParentID).Count()
,
from p in db.Parent
select Sql.AsSql(db.GetParentByID(p.ParentID).Count()));
}
}
public void SubQueryCount(string context)
{
using (var db = new TestDataConnection(context))
{
AreEqual(
from p in Parent
select Parent.Where(t => t.ParentID == p.ParentID).Count()
,
from p in db.Parent
select Sql.AsSql(db.GetParentByID(p.ParentID).Count()));
}
}
public void SubQueryCount(string context)
{
using (var db = new TestDataConnection(context))
{
AreEqual(
from p in Parent
select Parent.Where(t => t.ParentID == p.ParentID).Count()
,
from p in db.Parent
select Sql.AsSql(db.GetParentByID(p.ParentID).Count()));
}
}
public void SubQueryCount([IncludeDataContexts(ProviderName.SqlServer2008)] string context)
{
using (var db = new TestDataConnection(context))
{
AreEqual(
from p in Parent
select Parent.Where(t => t.ParentID == p.ParentID).Count()
,
from p in db.Parent
select Sql.AsSql(db.GetParentByID(p.ParentID).Count()));
}
}
