private bool LoadByPrimaryKeyDynamic(System.Int32 id)
{
AggregateTestQuery query = new AggregateTestQuery();
query.Where(query.Id == id);
return(this.Load(query));
}
public void Init2()
{
aggTestColl = new AggregateTestCollection();
aggTest = new AggregateTest();
aggTestQuery = new AggregateTestQuery();
aggCloneColl = new AggregateTestCollection();
aggClone = new AggregateTest();
aggCloneQuery = new AggregateTestQuery();
}
protected void InitQuery(AggregateTestQuery query)
{
query.OnLoadDelegate = this.OnQueryLoaded;
if (!query.es2.HasConnection)
{
query.es2.Connection = ((IEntityCollection)this).Connection;
}
}
public void CacheQueryObject()
{
aggTestQuery = aggTestColl.Query;
aggTestQuery
.Select()
.Where
(
aggTestQuery.Age <= aggTestQuery.Salary
);
Assert.IsTrue(aggTestQuery.Load());
Assert.AreEqual(11, aggTestColl.Count);
}
public void WhereConjunctionOrNotNested()
{
AggregateTestQuery query = new AggregateTestQuery();
query.Where
(
query.OrNot
(
query.DepartmentID == 1,
query.And
(
query.IsActive == true,
query.Age == 28
)
)
);
AggregateTestCollection coll = new AggregateTestCollection();
Assert.IsTrue(coll.Load(query));
switch (coll.es.Connection.ProviderSignature.DataProviderName)
{
case "EntitySpaces.MSAccessProvider":
Assert.AreEqual(29, coll.Count);
break;
case "EntitySpaces.NpgsqlProvider":
case "EntitySpaces.Npgsql2Provider":
case "EntitySpaces.OracleClientProvider":
case "EntitySpaces.SqlClientProvider":
case "EntitySpaces.SqlServerCeProvider":
case "EntitySpaces.SybaseSqlAnywhereProvider":
case "EntitySpaces.VistaDBProvider":
case "EntitySpaces.VistaDB4Provider":
Assert.AreEqual(24, coll.Count);
break;
default:
Assert.AreEqual(24, coll.Count);
break;
}
}
public void WhereConjunctionOrNotSeparateLines()
{
AggregateTestQuery query = new AggregateTestQuery();
query.Where(query.DepartmentID == 1);
query.es.DefaultConjunction = esConjunction.OrNot;
query.Where(new esComparison(esParenthesis.Open));
query.Where(query.IsActive == true);
query.es.DefaultConjunction = esConjunction.And;
query.Where(query.Age == 28);
query.Where(new esComparison(esParenthesis.Close));
AggregateTestCollection coll = new AggregateTestCollection();
Assert.IsTrue(coll.Load(query));
switch (coll.es.Connection.ProviderSignature.DataProviderName)
{
case "EntitySpaces.MSAccessProvider":
Assert.AreEqual(29, coll.Count);
break;
case "EntitySpaces.NpgsqlProvider":
case "EntitySpaces.Npgsql2Provider":
case "EntitySpaces.OracleClientProvider":
case "EntitySpaces.SqlClientProvider":
case "EntitySpaces.SqlServerCeProvider":
case "EntitySpaces.SybaseSqlAnywhereProvider":
case "EntitySpaces.VistaDBProvider":
case "EntitySpaces.VistaDB4Provider":
Assert.AreEqual(24, coll.Count);
break;
default:
Assert.AreEqual(24, coll.Count);
break;
}
}
public void WhereConjunctionAndNotNested()
{
AggregateTestQuery query = new AggregateTestQuery();
query.Where
(
query.AndNot
(
query.DepartmentID == 1,
query.And
(
query.IsActive == true,
query.Age == 28
)
)
);
AggregateTestCollection coll = new AggregateTestCollection();
Assert.IsTrue(coll.Load(query));
Assert.AreEqual(2, coll.Count);
}
public void WhereConjunctionAndNotSeparateLines()
{
AggregateTestQuery query = new AggregateTestQuery();
query.Where(query.DepartmentID == 1);
query.es.DefaultConjunction = esConjunction.AndNot;
query.Where(new esComparison(esParenthesis.Open));
query.Where(query.IsActive == true);
query.es.DefaultConjunction = esConjunction.And;
query.Where(query.Age == 28);
query.Where(new esComparison(esParenthesis.Close));
AggregateTestCollection coll = new AggregateTestCollection();
Assert.IsTrue(coll.Load(query));
Assert.AreEqual(2, coll.Count);
}
public bool Load(AggregateTestQuery query)
{
this.query = query;
InitQuery(this.query);
return(Query.Load());
}
public void CrossDbJoin()
{
EmployeeCollection collection = new EmployeeCollection();
collection.es.Connection.ConnectionString =
UnitTestBase.GetFktString(collection.es.Connection);
switch (collection.es.Connection.ProviderSignature.DataProviderName)
{
case "EntitySpaces.SqlClientProvider":
// AggregateDb
AggregateTestQuery aq = new AggregateTestQuery("a");
// ForeignKeyTest
EmployeeQuery eq = new EmployeeQuery("e");
eq.Select(eq.LastName, eq.FirstName, aq.Age);
eq.LeftJoin(aq).On(
eq.LastName == aq.LastName &
eq.FirstName == aq.FirstName);
eq.OrderBy(eq.LastName.Ascending,
eq.FirstName.Ascending);
Assert.IsTrue(collection.Load(eq));
Assert.AreEqual(22, collection[2].GetColumn("Age"));
break;
default:
Assert.Ignore("SQL Server only");
break;
}
}
