public void FreeTextTable3([IncludeDataSources(TestProvName.Northwind)] string context)
{
using (var db = new NorthwindDB(context))
{
var q =
from t in db.FreeTextTable <Northwind.Category, int>(c => c.Description, "sweetest candy bread and dry meat")
join c in db.Category
on t.Key equals c.CategoryID
select c;
q.ToList();
}
}
public void Issue386LeftJoinWithExpression([IncludeDataSources(TestProvName.Northwind)] string context)
{
using (var db = new NorthwindDB(context))
{
var q
= from t in db.Product
from c in db.FreeTextTable <Northwind.Category, int>(c => c.Description, "sweetest candy bread and dry meat").Where(f => f.Key == t.CategoryID).DefaultIfEmpty()
orderby t.ProductName descending
select t;
var list = q.ToList();
Assert.That(list.Count, Is.GreaterThan(0));
}
}
public void FreeTextTable2(string context)
{
using (var db = new NorthwindDB(context))
{
var q =
from c in db.Category
join t in db.FreeTextTable <Northwind.Category, int>(c1 => c1.Description, "sweetest candy bread and dry meat")
on c.CategoryID equals t.Key
select c;
q.ToList();
}
}
public void FreeTextTable1([IncludeDataSources(TestProvName.Northwind)] string context)
{
using (var db = new NorthwindDB(context))
{
var q =
from c in db.Category
join t in db.FreeTextTable <Northwind.Category, int>("[Description]", "sweetest candy bread and dry meat")
on c.CategoryID equals t.Key
select c;
q.ToList();
}
}
public void FreeText2([IncludeDataContexts("Northwind")] string context)
{
using (var db = new NorthwindDB())
{
var q =
from c in db.Category
join t in db.FreeTextTable <Northwind.Category, int>(c => c.Description, "sweetest candy bread and dry meat")
on c.CategoryID equals t.Key
select c;
q.ToList();
}
}
public void FreeText3(string context)
{
using (var db = new NorthwindDB())
{
var q =
from t in db.FreeTextTable <Northwind.Category, int>(c => c.Description, "sweetest candy bread and dry meat")
join c in db.Category
on t.Key equals c.CategoryID
select c;
q.ToList();
}
}
public void FreeText1()
{
using (var db = new NorthwindDB())
{
var q =
from c in db.Category
join t in db.FreeTextTable <Northwind.Category, int>("[Description]", "sweetest candy bread and dry meat")
on c.CategoryID equals t.Key
select c;
q.ToList();
}
}
public void Issue386InnerJoinWithExpression([IncludeDataSources(TestProvName.AllNorthwind)] string context)
{
using (var db = new NorthwindDB(context))
{
var q =
from t in db.Product
join c in db.FreeTextTable <Northwind.Category, int>(db.Category, c => c.Description, "sweetest candy bread and dry meat") on t.CategoryID equals c.Key
orderby t.ProductName descending
select t;
var list = q.ToList();
Assert.That(list.Count, Is.GreaterThan(0));
}
}
public void FreeText3([IncludeDataContexts("Northwind")] string context)
{
using (var db = new NorthwindDB())
{
var q =
from t in db.FreeTextTable<Northwind.Category,int>(c => c.Description, "sweetest candy bread and dry meat")
join c in db.Category
on t.Key equals c.CategoryID
select c;
q.ToList();
}
}
public void FreeText1([IncludeDataContexts("Northwind")] string context)
{
using (var db = new NorthwindDB())
{
var q =
from c in db.Category
join t in db.FreeTextTable<Northwind.Category,int>("[Description]", "sweetest candy bread and dry meat")
on c.CategoryID equals t.Key
select c;
q.ToList();
}
}
public void FreeText2(string context)
{
using (var db = new NorthwindDB())
{
var q =
from c in db.Category
join t in db.FreeTextTable<Northwind.Category,int>(c => c.Description, "sweetest candy bread and dry meat")
on c.CategoryID equals t.Key
select c;
q.ToList();
}
}