public void LinqToEntities51()
{
Require.ProviderIsNot(StorageProvider.SqlServerCe);
Require.ProviderIsNot(StorageProvider.Firebird);
Require.ProviderIsNot(StorageProvider.MySql);
var query = Session.Query.All <Invoice>()
.Where(i => i.BillingAddress.Country == "Mexico")
.Select(i => i.DesignatedEmployee)
.Except(Session.Query.All <Invoice>()
.Where(i => i.BillingAddress.Country == "Canada")
.Select(i => i.DesignatedEmployee));
QueryDumper.Dump(query);
}
public void LinqToEntities40()
{
Require.AllFeaturesSupported(ProviderFeatures.ScalarSubqueries);
var query = from p in Session.Query.All <Track>()
group p by p.MediaType
into g
select new {
g.Key,
ExpensiveProducts =
from t2 in g
where t2.UnitPrice > g.Average(t3 => t3.UnitPrice)
select t2
};
QueryDumper.Dump(query);
}
public void LinqToEntities47()
{
Require.ProviderIsNot(StorageProvider.SqlServerCe);
var mexico = Session.Query.All <Invoice>().Where(i => i.BillingAddress.Country == "Mexico").Select(i => i);
var canada = Session.Query.All <Invoice>().Where(i => i.BillingAddress.Country == "Canada").Select(i => i);
var union = mexico.Union(canada).Select(i => i.DesignatedEmployee);
var query = union.Distinct();
var actualMexico = Session.Query.All <Invoice>().ToList()
.Where(i => i.BillingAddress.Country == "Mexico").Select(i => i);
var actualCanada = Session.Query.All <Invoice>().ToList()
.Where(i => i.BillingAddress.Country == "Canada").Select(i => i);
var actualUnion = actualMexico.Union(actualCanada).Select(i => i.DesignatedEmployee);
var actual = actualUnion.Distinct();
Assert.AreEqual(0, actual.Select(e => e.EmployeeId).Except(query.ToList().Select(e => e.EmployeeId)).Count());
QueryDumper.Dump(query);
}
public void LinqToEntities30()
{
var query = Session.Query.All <Invoice>().Min(i => i.Commission);
QueryDumper.Dump(query);
}
public void LinqToEntities39()
{
var query = Session.Query.All <Track>().Where(p => p.MediaType.MediaTypeId == 305).Average(p => p.UnitPrice);
QueryDumper.Dump(query);
}
public void LinqToEntities38()
{
var query = Session.Query.All <Track>().Average(p => p.UnitPrice);
QueryDumper.Dump(query);
}
public void LinqToEntities37()
{
var query = Session.Query.All <Invoice>().Select(i => i.Commission).Average();
QueryDumper.Dump(query);
}
public void LinqToEntities35()
{
var query = Session.Query.All <Track>().Where(p => p.MediaType.MediaTypeId == 305).Max(p => p.Milliseconds);
QueryDumper.Dump(query);
}
public void LinqToEntities80()
{
var query = Session.Query.All <Track>().OfType <AudioTrack>();
QueryDumper.Dump(query);
}
public void LinqToEntities67()
{
var query = Session.Query.All <Customer>().GroupBy(c => c.Address.State).Select(r => new { state = r.Key, count = r.Count() });
QueryDumper.Dump(query);
}
public void LinqToEntities58()
{
var query = Session.Query.All <Customer>().Select(c => c).OrderByDescending(c2 => c2.Address.State);
QueryDumper.Dump(query);
}
public void LinqToEntities28()
{
var query = Session.Query.All <Track>().Where(p => p.Genre.GenreId == 299).Sum(p => p.Milliseconds);
QueryDumper.Dump(query);
}
public void LinqToEntities29()
{
var query = Session.Query.All <Track>().Select(p => p.UnitPrice).Min();
QueryDumper.Dump(query);
}
public void LinqToEntities24()
{
var query = Session.Query.All <Invoice>().Where(i => i.Customer.Address.Country == "Mexico").Count();
QueryDumper.Dump(query);
}
public void LinqToEntities23()
{
var query = Session.Query.All <Invoice>().Count();
QueryDumper.Dump(query);
}
public void LinqToEntities15a()
{
var query = Session.Query.All <Customer>().Select(c => new { Customer = c, Invoices = c.Invoices.Where(i => i.Commission > 0.05m) });
QueryDumper.Dump(query);
}
public void LinqToEntities84()
{
var query = Session.Query.All <Person>().OfType <BusinessContact>().Select(c => c);
Assert.Throws <QueryTranslationException>(() => QueryDumper.Dump(query));
}
public void LinqToEntities81()
{
var query = Session.Query.All <Track>().Where(p => p is VideoTrack);
QueryDumper.Dump(query);
}
public void LinqToEntities31()
{
var query = Session.Query.All <Invoice>().Where(i => i.BillingAddress.Country == "Mexico").Min(i => i.Commission);
QueryDumper.Dump(query);
}
public void LinqToEntities33()
{
var query = Session.Query.All <Employee>().Select(e => e.HireDate).Max();
QueryDumper.Dump(query);
}
public void LinqToEntities61()
{
var query = Session.Query.All <Customer>().Select(c => c).OrderBy(c => c.Address.State).ThenByDescending(c => c.LastName);
QueryDumper.Dump(query);
}
public void LinqToEntities34()
{
var query = Session.Query.All <Track>().Max(p => p.Milliseconds);
QueryDumper.Dump(query);
}
public void LinqToEntities71()
{
var query = Session.Query.All <Customer>().Where(cust => cust.CustomerId == 4200).SelectMany(c => c.Invoices);
QueryDumper.Dump(query);
}
public void LinqToEntities79()
{
var query = Session.Query.All <Track>().OfType <Track>().Select(p => p);
QueryDumper.Dump(query);
}
