public void Where8(string context)
{
using (var db = GetDataContext(context))
{
var hid = SqlHierarchyId.Parse("/1/");
AreEqual(
SqlTypes.Data(context)
.Where(t => IsDescendantOf(hid, t.HID)),
db.GetTable <SqlTypes>()
.Where(t => IsDescendantOf(hid, t.HID) == true));
}
}
public void Where1(string context)
{
using (var db = GetDataContext(context))
{
var hid = SqlHierarchyId.Parse("/1/");
AreEqual(
SqlTypes.Data(context)
.Where(t => (bool)(hid.IsDescendantOf(t.HID) == SqlBoolean.True)),
db.GetTable <SqlTypes>()
.Where(t => (bool)(hid.IsDescendantOf(t.HID) == SqlBoolean.True)));
}
}
public void Where8([IncludeDataSources(true, TestProvName.AllSqlServer2008Plus)] string context)
{
using (var db = GetDataContext(context))
{
var hid = SqlHierarchyId.Parse("/1/");
AreEqual(
SqlTypes.Data(context)
.Where(t => IsDescendantOf(hid, t.HID)),
db.GetTable <SqlTypes>()
.Where(t => IsDescendantOf(hid, t.HID) == true));
}
}
public void Where5([SqlServerDataContext] string context)
{
using (var db = GetDataContext(context))
{
var hid = SqlHierarchyId.Parse("/1/");
AreEqual(
SqlTypes.Data(context)
.Where(t => hid.IsDescendantOf(t.HID).IsTrue),
db.GetTable <SqlTypes>()
.Where(t => hid.IsDescendantOf(t.HID).IsTrue));
}
}
public void Where6([IncludeDataSources(true, TestProvName.AllSqlServer2008Plus)] string context)
{
using (var db = GetDataContext(context))
{
var hid = SqlHierarchyId.Parse("/1/");
AreEqual(
SqlTypes.Data(context)
.Where(t => (bool)(hid.IsDescendantOf(t.HID) == SqlBoolean.True) && t.ID != 1)
.OrderBy(c => c.HID),
db.GetTable <SqlTypes>()
.Where(t => (bool)(hid.IsDescendantOf(t.HID) == SqlBoolean.True) && t.ID != 1)
.OrderBy(c => c.HID));
}
}
public void Where6([SqlServerDataContext] string context)
{
using (var db = GetDataContext(context))
{
var hid = SqlHierarchyId.Parse("/1/");
AreEqual(
SqlTypes.Data(context)
.Where(t => (bool)(hid.IsDescendantOf(t.HID) == SqlBoolean.True) && t.ID != 1)
.OrderBy(c => c.HID),
db.GetTable <SqlTypes>()
.Where(t => (bool)(hid.IsDescendantOf(t.HID) == SqlBoolean.True) && t.ID != 1)
.OrderBy(c => c.HID));
}
}
