public void ParameterName([DataSources(TestProvName.AllSapHana)] string context)
{
using (var db = GetDataContext(context))
AreEqual(
from p in Parent where p.ParentID == 1 select p,
VisualBasicCommon.ParamenterName(db));
}
public void ParameterName(string context)
{
using (var db = GetDataContext(context))
AreEqual(
from p in Parent where p.ParentID == 1 select p,
VisualBasicCommon.ParamenterName(db));
}
public void SearchCondition1([DataSources(TestProvName.AllAccess)] string context)
{
using (var db = GetDataContext(context))
AreEqual(
from t in Types
where !t.BoolValue && (t.SmallIntValue == 5 || t.SmallIntValue == 7 || (t.SmallIntValue | 2) == 10)
select t,
VisualBasicCommon.SearchCondition1(db));
}
public void SearchCondition1()
{
ForEachProvider(
new[] { ProviderName.Access },
db => AreEqual(
from t in Types
where !t.BoolValue && (t.SmallIntValue == 5 || t.SmallIntValue == 7 || (t.SmallIntValue | 2) == 10)
select t,
VisualBasicCommon.SearchCondition1(db)));
}
public void SearchCondition2(string context)
{
using (var db = new NorthwindDB())
{
AreEqual(
from cust in Customer
where cust.Orders.Count > 0 && cust.CompanyName.StartsWith("H")
select cust.CustomerID,
VisualBasicCommon.SearchCondition2(db));
}
}
public void SearchCondition2([NorthwindDataContext] string context)
{
using (var db = new NorthwindDB(context))
{
var dd = GetNorthwindAsList(context);
AreEqual(
from cust in dd.Customer
where cust.Orders.Count > 0 && cust.CompanyName.StartsWith("H")
select cust.CustomerID,
VisualBasicCommon.SearchCondition2(db));
}
}
public void SearchCondition4(string context)
{
using (var db = new NorthwindDB())
{
var cQuery = from order in db.Order
where order.OrderDate == new DateTime(1997, 11, 14)
select order.OrderID;
var cSharpResults = cQuery.ToList();
var vbResults = (VisualBasicCommon.SearchCondition4(db)).ToList();
AreEqual(
cSharpResults,
vbResults);
}
}
public void ParameterName()
{
ForEachProvider(db => AreEqual(
from p in Parent where p.ParentID == 1 select p,
VisualBasicCommon.ParamenterName(db)));
}
