public void Func3()
{
using (var db = new TestDbManager())
{
var q =
from c in db.Child
from p in db.GetParentByID(c.ParentID)
select p;
q.ToList();
}
}
public void Func3([IncludeDataContexts("Sql2008", "Sql2012")] string context)
{
using (var db = new TestDbManager(context))
{
var q =
from c in db.Child
from p in db.GetParentByID(c.ParentID)
select p;
q.ToList();
}
}
public void Func2()
{
using (var db = new TestDbManager())
{
var q =
from c in db.Child
from p in db.GetParentByID(2)
select p;
q.ToList();
}
}
public void Func3([IncludeDataContexts("Sql2008", "Sql2012")] string context)
{
using (var db = new TestDbManager(context))
{
var q =
from c in db.Child
from p in db.GetParentByID(c.ParentID)
select p;
q.ToList();
}
}
public void SubQueryCount([IncludeDataContexts("Sql2008", "Sql2012")] string context)
{
using (var db = new TestDbManager(context))
{
AreEqual(
from p in Parent
select Parent.Where(t => t.ParentID == p.ParentID).Count()
,
from p in db.Parent
//select Sql.AsSql(db.Parent.Count()));
select Sql.AsSql(db.GetParentByID(p.ParentID).Count()));
}
}
public void SubQueryCount()
{
using (var db = new TestDbManager())
{
AreEqual(
from p in Parent
select Parent.Where(t => t.ParentID == p.ParentID).Count()
,
from p in db.Parent
//select Sql.AsSql(db.Parent.Count()));
select Sql.AsSql(db.GetParentByID(p.ParentID).Count()));
}
}
public void SubQueryCount([IncludeDataContexts("Sql2008", "Sql2012")] string context)
{
using (var db = new TestDbManager(context))
{
AreEqual(
from p in Parent
select Parent.Where(t => t.ParentID == p.ParentID).Count()
,
from p in db.Parent
//select Sql.AsSql(db.Parent.Count()));
select Sql.AsSql(db.GetParentByID(p.ParentID).Count()));
}
}
public void SubQueryCount()
{
using (var db = new TestDbManager())
{
AreEqual(
from p in Parent
select Parent.Where(t => t.ParentID == p.ParentID).Count()
,
from p in db.Parent
//select Sql.AsSql(db.Parent.Count()));
select Sql.AsSql(db.GetParentByID(p.ParentID).Count()));
}
}