public void TestToLowerWithIn()
{
AggregateTestCollection collection = new AggregateTestCollection();
collection.Query.Where(collection.Query.LastName.ToLower().In("doe", "douglas"));
collection.Query.Load();
Assert.AreEqual(4, collection.Count);
}
public void TestLTrim()
{
AggregateTestCollection collection = new AggregateTestCollection();
collection.Query.Where(collection.Query.LastName.LTrim() == "Doe");
collection.Query.Load();
Assert.AreEqual(3, collection.Count);
}
public void TestToUpperWithLike()
{
AggregateTestCollection collection = new AggregateTestCollection();
collection.Query.Where(collection.Query.LastName.ToUpper().Like("DO%"));
collection.Query.Load();
Assert.AreEqual(4, collection.Count);
}
public void TestToUpper()
{
AggregateTestCollection collection = new AggregateTestCollection();
collection.Query.Where(collection.Query.LastName.ToUpper() == "DOE");
collection.Query.Load();
Assert.AreEqual(3, collection.Count);
}
public void SelectWithAlias()
{
aggTestColl.Query.Select(
aggTestColl.Query.Salary.As("S2"),
aggTestColl.Query.FirstName,
aggTestColl.Query.FirstName.As("FN")
);
aggTestColl.Query.OrderBy(aggTestColl.Query.Id.Ascending);
Assert.IsTrue(aggTestColl.Query.Load());
Assert.AreEqual(30, aggTestColl.Count);
AggregateTestCollection aggControl = new AggregateTestCollection();
aggControl.Query.OrderBy(aggControl.Query.Id.Ascending);
aggControl.Query.Load();
int i = 0;
foreach (AggregateTest agg in aggTestColl)
{
if (aggControl[i].Salary.HasValue)
{
Assert.AreEqual(aggControl[i].Salary.Value,
agg.GetColumn("S2"));
}
else
{
Assert.AreEqual(null, agg.GetColumn("S2") as string);
}
Assert.AreEqual(aggControl[i].FirstName,
agg.GetColumn("FN") as string);
i++;
}
}
public void TestToUpperInSelect()
{
AggregateTestCollection collection = new AggregateTestCollection();
collection.Query.Select(collection.Query.LastName.ToUpper());
collection.Query.Where(collection.Query.LastName == "Doe");
collection.Query.Load();
Assert.AreEqual(3, collection.Count);
Assert.AreEqual("DOE", collection[0].LastName);
}
public void Init2()
{
aggTestColl = new AggregateTestCollection();
aggTest = new AggregateTest();
aggTestQuery = new AggregateTestQuery();
aggCloneColl = new AggregateTestCollection();
aggClone = new AggregateTest();
aggCloneQuery = new AggregateTestQuery();
}
// Obsolete as of 2007.1.1021.0
//protected override void CreateExtendedProperties(esColumnMetadataCollection extendedProps)
//{
// if (null == extendedProps["NewId"])
// {
// esColumnMetadata col = new esColumnMetadata("NewId", this.Meta.Columns.Count + 1, Type.GetType("System.Int32"));
// col.PropertyName = "NewId";
// extendedProps.Add(col);
// }
// if (null == extendedProps["OrderIndex"])
// {
// esColumnMetadata col = new esColumnMetadata("OrderIndex", this.Meta.Columns.Count + 1, Type.GetType("System.Int32"));
// col.PropertyName = "OrderIndex";
// extendedProps.Add(col);
// }
//}
//public void AddOrderIndexColumn()
//{
// if (this.Table != null && this.Table.Columns.Contains("OrderIndex") == false)
// {
// this.Table.Columns.Add("OrderIndex", typeof(Int16));
// }
//}
//public DataTable GetTable()
//{
// return this.Table;
//}
public static void CustomForEach()
{
AggregateTestCollection coll = new AggregateTestCollection();
coll.LoadAll();
foreach (AggregateTest entity in coll)
{
entity.LastName = "CustomForEach";
}
}
// Obsolete as of 2007.1.1021.0
//protected override void CreateExtendedProperties(esColumnMetadataCollection extendedProps)
//{
// if (null == extendedProps["NewId"])
// {
// esColumnMetadata col = new esColumnMetadata("NewId", this.Meta.Columns.Count + 1, Type.GetType("System.Int32"));
// col.PropertyName = "NewId";
// extendedProps.Add(col);
// }
// if (null == extendedProps["OrderIndex"])
// {
// esColumnMetadata col = new esColumnMetadata("OrderIndex", this.Meta.Columns.Count + 1, Type.GetType("System.Int32"));
// col.PropertyName = "OrderIndex";
// extendedProps.Add(col);
// }
//}
//public void AddOrderIndexColumn()
//{
// if (this.Table != null && this.Table.Columns.Contains("OrderIndex") == false)
// {
// this.Table.Columns.Add("OrderIndex", typeof(Int16));
// }
//}
//public DataTable GetTable()
//{
// return this.Table;
//}
public static void CustomForEach()
{
AggregateTestCollection coll = new AggregateTestCollection();
coll.LoadAll();
foreach (AggregateTest entity in coll)
{
entity.LastName = "CustomForEach";
}
}
public void ViewOnCollection()
{
AggregateTestCollection collection = new AggregateTestCollection();
collection.Query.Where(collection.Query.LastName.ToUpper() == "DOE");
collection.Query.Load();
Assert.AreEqual(3, collection.Count);
esEntityCollectionView<AggregateTest> view1 =
new esEntityCollectionView<AggregateTest>(collection);
Assert.AreEqual(3, view1.Count);
Assert.AreEqual(3, collection.Count);
}
public void ViewOnFilteredCollection()
{
AggregateTestCollection collection = new AggregateTestCollection();
collection.Query.Load();
Assert.AreEqual(30, collection.Count);
collection.Filter = collection.AsQueryable().Where(f => f.LastName == "Doe");
Assert.AreEqual(3, collection.Count);
esEntityCollectionView<AggregateTest> view1 =
new esEntityCollectionView<AggregateTest>(collection);
Assert.AreEqual(30, view1.Count);
Assert.AreEqual(3, collection.Count);
}
public void EmptyQueryReturnsSelectAll()
{
aggTestColl = new AggregateTestCollection();
Assert.IsTrue(aggTestColl.LoadAll());
Assert.AreEqual(30, aggTestColl.Count, "LoadAll");
aggTestColl = new AggregateTestCollection();
Assert.IsTrue(aggTestColl.Query.Load());
Assert.AreEqual(30, aggTestColl.Count, "Query.Load");
aggTestColl = new AggregateTestCollection();
aggTestColl.Query.LoadDataTable();
Assert.AreEqual(0, aggTestColl.Count, "Query.LoadDataTable");
}
public void TestDateTime()
{
int testId = -1;
AggregateTestCollection aggTestColl = new AggregateTestCollection();
AggregateTest test = new AggregateTest();
try
{
using (EntitySpaces.Interfaces.esTransactionScope scope =
new EntitySpaces.Interfaces.esTransactionScope())
{
aggTestColl.Query.Load();
aggTestColl.Filter = aggTestColl.AsQueryable().OrderBy(s => s.Id);
test = (AggregateTest)aggTestColl[0];
DateTime date = test.HireDate.Value;
Assert.AreEqual(Convert.ToDateTime("02/16/2000 05:59:31"), date);
test = new AggregateTest();
test.HireDate = Convert.ToDateTime("12/31/9999");
test.Save();
testId = test.Id.Value;
test = new AggregateTest();
Assert.IsTrue(test.LoadByPrimaryKey(testId));
Assert.AreEqual(Convert.ToDateTime("12/31/9999"), test.HireDate.Value);
test.MarkAsDeleted();
test.Save();
}
}
finally
{
// Clean up
test = new AggregateTest();
if (test.LoadByPrimaryKey(testId))
{
test.MarkAsDeleted();
test.Save();
}
}
}
public void TestIdentityInsert()
{
AggregateTestCollection coll = new AggregateTestCollection();
coll.LoadAll();
StringBuilder sql = new StringBuilder();
sql.AppendLine("SET IDENTITY_INSERT [AggregateTest] ON");
sql.AppendLine("SET NOCOUNT ON");
for (int i = 1; i < coll.Count; i++)
{
sql.AppendLine("INSERT INTO [AggregateTest]([ID], [LastName])");
sql.AppendLine("VALUES(" + i.ToString() + ", '" + coll[i].LastName + "')");
}
sql.AppendLine("SET IDENTITY_INSERT [AggregateTest] OFF");
//esUtility u = new esUtility();
//u.ExecuteNonQuery(esQueryType.Text, sql.ToString());
}
public void TwoFilteredViewsOnFilteredCollection()
{
AggregateTestCollection collection = new AggregateTestCollection();
collection.Query.Load();
Assert.AreEqual(30, collection.Count);
collection.Filter = collection.AsQueryable().Where(f => f.LastName == "Doe");
Assert.AreEqual(3, collection.Count);
esEntityCollectionView<AggregateTest> view1 =
new esEntityCollectionView<AggregateTest>(collection);
Assert.AreEqual(30, view1.Count);
view1.Filter = view1.AsQueryable().Where(f => f.Age > 20);
Assert.AreEqual(18, view1.Count);
Assert.AreEqual(3, collection.Count);
esEntityCollectionView<AggregateTest> view2 =
new esEntityCollectionView<AggregateTest>(collection);
Assert.AreEqual(30, view2.Count);
view2.Filter = view2.AsQueryable().Where(f => f.FirstName == "John");
Assert.AreEqual(2, view2.Count);
Assert.AreEqual(18, view1.Count);
Assert.AreEqual(3, collection.Count);
}
public void PagingWithTop()
{
AggregateTestCollection collection = new AggregateTestCollection();
if (collection.es.Connection.Name == "SqlCe"
|| collection.es.Connection.ProviderMetadataKey ==
"esSqlCe4"
|| collection.es.Connection.ProviderMetadataKey ==
"esSqlCe")
{
Assert.Ignore("Not tested for SqlCe.");
}
else
{
switch (collection.es.Connection.ProviderSignature.DataProviderName)
{
case "EntitySpaces.MSAccessProvider":
case "EntitySpaces.VistaDBProvider":
case "EntitySpaces.VistaDB4Provider":
Assert.Ignore("Not supported");
break;
default:
AggregateTestCollection all = new AggregateTestCollection();
all.Query.es.Top = 20;
all.Query.OrderBy(all.Query.LastName, esOrderByDirection.Ascending);
all.Query.OrderBy(all.Query.Id, esOrderByDirection.Ascending);
all.Query.Load();
collection = new AggregateTestCollection();
collection.Query.es.Top = 20;
collection.Query.Select(
collection.Query.Id,
collection.Query.LastName,
collection.Query.FirstName,
collection.Query.IsActive);
collection.Query.OrderBy(collection.Query.LastName, esOrderByDirection.Ascending);
collection.Query.OrderBy(collection.Query.Id, esOrderByDirection.Ascending);
collection.Query.es.PageNumber = 1;
collection.Query.es.PageSize = 8;
Assert.IsTrue(collection.Query.Load(), "Load 1");
Assert.AreEqual(8, collection.Count, "Count 1");
AggregateTest all0 = (AggregateTest)all[0];
AggregateTest collection0 = (AggregateTest)collection[0];
Assert.AreEqual(all0.Id.Value, collection0.Id.Value, "Compare 1");
collection.Query.es.PageNumber = 2;
Assert.IsTrue(collection.Query.Load(), "Load 2");
Assert.AreEqual(8, collection.Count, "Count 2");
all0 = (AggregateTest)all[8];
collection0 = (AggregateTest)collection[0];
Assert.AreEqual(all0.Id.Value, collection0.Id.Value, "Compare 2");
break;
}
}
}
public void SkipTake()
{
AggregateTestCollection coll = new AggregateTestCollection();
switch (coll.es.Connection.ProviderSignature.DataProviderName)
{
case "EntitySpaces.MSAccessProvider":
case "EntitySpaces.SqlServerCeProvider":
case "EntitySpaces.SqlClientProvider":
case "EntitySpaces.VistaDBProvider":
case "EntitySpaces.VistaDB4Provider":
Assert.Ignore("Not supported");
break;
default:
AggregateTestCollection all = new AggregateTestCollection();
all.Query.OrderBy(all.Query.LastName, esOrderByDirection.Ascending);
all.Query.OrderBy(all.Query.Id, esOrderByDirection.Ascending);
all.Query.Load();
coll = new AggregateTestCollection();
coll.Query.Select(
coll.Query.Id,
coll.Query.LastName,
coll.Query.FirstName,
coll.Query.IsActive);
coll.Query.Skip(8).Take(2);
coll.Query.OrderBy(coll.Query.LastName, esOrderByDirection.Ascending);
coll.Query.OrderBy(coll.Query.Id, esOrderByDirection.Ascending);
//string lq = coll.Query.Parse();
Assert.IsTrue(coll.Query.Load(), "Load");
Assert.AreEqual(2, coll.Count, "Count");
AggregateTest all0 = (AggregateTest)all[8];
AggregateTest collection0 = (AggregateTest)coll[0];
Assert.AreEqual(all0.Id.Value, collection0.Id.Value, "Compare");
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 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 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 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 SerializeDeserializeCollectionBinary()
{
if (aggTestColl.es.Connection.Name == "SqlCe")
{
Assert.Ignore("Not tested for SqlCe.");
}
else
{
aggTestColl.LoadAll();
BinaryFormatter bf = new BinaryFormatter();
MemoryStream ms = new MemoryStream();
bf.Serialize(ms, aggTestColl);
ms.Position = 0;
aggCloneColl = (AggregateTestCollection)bf.Deserialize(ms);
ms.Close();
Assert.AreEqual(30, aggCloneColl.Count);
}
}
public void TestCommandTimeoutConfig()
{
switch (aggTestColl.es.Connection.ProviderSignature.DataProviderName)
{
case "EntitySpaces.SqlClientProvider":
// Collection
aggTestColl = new AggregateTestCollection();
Assert.AreEqual(39, aggTestColl.es.Connection.CommandTimeout);
Assert.IsTrue(aggTestColl.Query.Load(), "Query.Load");
aggTestColl = new AggregateTestCollection();
Assert.AreEqual(39, aggTestColl.es.Connection.CommandTimeout);
Assert.IsTrue(aggTestColl.LoadAll(), "LoadAll");
// Entity
aggTest = new AggregateTest();
Assert.AreEqual(39, aggTest.es.Connection.CommandTimeout);
aggTest.Query.es.Top = 1;
Assert.IsTrue(aggTest.Query.Load(), "Query.Load");
int aggKey = aggTest.Id.Value;
aggTest = new AggregateTest();
Assert.AreEqual(39, aggTest.es.Connection.CommandTimeout);
Assert.IsTrue(aggTest.LoadByPrimaryKey(aggKey), "LoadByPK");
break;
default:
Assert.Ignore("tested for SQL Server only");
break;
}
}
public void LoadTextEsParams()
{
aggTestColl = new AggregateTestCollection();
aggTestColl.CustomLoadTextEsParams("D");
Assert.AreEqual(6, aggTestColl.Count);
}
public void LoadText()
{
aggTestColl = new AggregateTestCollection();
aggTestColl.CustomLoadText();
Assert.AreEqual(8, aggTestColl.Count);
}
public void IterateSortedViewAndCollection()
{
AggregateTestCollection collection = new AggregateTestCollection();
collection.Query.Load();
collection.Filter = collection.AsQueryable().OrderBy(s => s.LastName);
esEntityCollectionView<AggregateTest> view1 =
new esEntityCollectionView<AggregateTest>(collection);
view1.Filter = view1.AsQueryable().OrderByDescending(s => s.LastName);
string prevName = collection[0].LastName;
foreach (AggregateTest at in collection)
{
Assert.IsTrue(String.Compare(prevName, at.LastName) <= 0);
prevName = at.LastName;
}
prevName = view1[0].LastName;
foreach (AggregateTest at in view1)
{
Assert.IsTrue(String.Compare(prevName, at.LastName) >= 0);
prevName = at.LastName;
}
}
public void TestCommandTimeout()
{
switch (aggTestColl.es.Connection.ProviderSignature.DataProviderName)
{
case "EntitySpaces.SqlClientProvider":
aggTestColl = new AggregateTestCollection();
aggTestColl.es.Connection.CommandTimeout = 49;
Assert.IsTrue(aggTestColl.Query.Load(), "Query.Load");
Assert.AreEqual(49, aggTestColl.es.Connection.CommandTimeout);
aggTestColl = new AggregateTestCollection();
Assert.IsTrue(aggTestColl.LoadAll(), "LoadAll");
Assert.AreEqual(39, aggTestColl.es.Connection.CommandTimeout);
break;
default:
Assert.Ignore("SQL Server only");
break;
}
}
public void TestIdentityInsert()
{
AggregateTestCollection coll = new AggregateTestCollection();
coll.LoadAll();
StringBuilder sql = new StringBuilder();
sql.AppendLine("SET IDENTITY_INSERT [AggregateTest] ON");
sql.AppendLine("SET NOCOUNT ON");
for (int i = 1; i < coll.Count; i++)
{
sql.AppendLine("INSERT INTO [AggregateTest]([ID], [LastName])");
sql.AppendLine("VALUES(" + i.ToString() + ", '" + coll[ i ].LastName + "')");
}
sql.AppendLine("SET IDENTITY_INSERT [AggregateTest] OFF");
//esUtility u = new esUtility();
//u.ExecuteNonQuery(esQueryType.Text, sql.ToString());
}
public void PagingWithGroupBy()
{
AggregateTestCollection collection = new AggregateTestCollection();
switch (collection.es.Connection.ProviderSignature.DataProviderName)
{
case "EntitySpaces.MSAccessProvider":
case "EntitySpaces.SqlServerCeProvider":
case "EntitySpaces.VistaDBProvider":
case "EntitySpaces.VistaDB4Provider":
Assert.Ignore("Paging Not supported");
break;
default:
AggregateTestCollection all = new AggregateTestCollection();
all.Query.Select(
all.Query.LastName,
all.Query.Salary.Avg());
all.Query.Where(all.Query.IsActive == true);
all.Query.GroupBy(all.Query.LastName);
all.Query.OrderBy(all.Query.LastName, esOrderByDirection.Ascending);
all.Query.Load();
collection = new AggregateTestCollection();
collection.Query.Select(
collection.Query.LastName,
collection.Query.Salary.Avg());
collection.Query.Where(collection.Query.IsActive == true);
collection.Query.GroupBy(collection.Query.LastName);
collection.Query.OrderBy(collection.Query.LastName, esOrderByDirection.Ascending);
collection.Query.es.PageNumber = 1;
collection.Query.es.PageSize = 8;
Assert.IsTrue(collection.Query.Load(), "Load 1");
Assert.AreEqual(8, collection.Count, "Count 1");
AggregateTest all0 = (AggregateTest)all[0];
AggregateTest collection0 = (AggregateTest)collection[0];
Assert.AreEqual(all0.LastName, collection0.LastName, "Compare 1");
collection.Query.es.PageNumber = 2;
Assert.IsTrue(collection.Query.Load(), "Load 2");
Assert.AreEqual(2, collection.Count, "Count 2");
all0 = (AggregateTest)all[8];
collection0 = (AggregateTest)collection[0];
Assert.AreEqual(all0.LastName, collection0.LastName, "Compare 2");
break;
}
}
public static void RefreshDatabase(string connectionName)
{
AggregateTestCollection aggTestColl = new AggregateTestCollection();
if (connectionName.Length != 0)
{
aggTestColl.es.Connection.Name = connectionName;
}
aggTestColl.LoadAll();
aggTestColl.MarkAllAsDeleted();
aggTestColl.Save();
aggTestColl = new AggregateTestCollection();
AggregateTest aggTest = new AggregateTest();
if (connectionName.Length != 0)
{
aggTestColl.es.Connection.Name = connectionName;
aggTest.es.Connection.Name = connectionName;
}
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "3";
aggTest.str().FirstName = "David";
aggTest.str().LastName = "Doe";
aggTest.str().Age = "16";
aggTest.str().HireDate = "2000-02-16 05:59:31";
aggTest.str().Salary = "34.71";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "1";
aggTest.str().FirstName = "Sarah";
aggTest.str().LastName = "McDonald";
aggTest.str().Age = "28";
aggTest.str().HireDate = "1999-03-25 00:00:00";
aggTest.str().Salary = "11.06";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "3";
aggTest.str().FirstName = "David";
aggTest.str().LastName = "Vincent";
aggTest.str().Age = "43";
aggTest.str().HireDate = "2000-10-17 00:00:00";
aggTest.str().Salary = "10.27";
aggTest.str().IsActive = "false";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "2";
aggTest.str().FirstName = "Fred";
aggTest.str().LastName = "Smith";
aggTest.str().Age = "15";
aggTest.str().HireDate = "1999-03-15 00:00:00";
aggTest.str().Salary = "15.15";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "3";
aggTest.str().FirstName = "Sally";
aggTest.str().LastName = "Johnson";
aggTest.str().Age = "30";
aggTest.str().HireDate = "2000-10-07 00:00:00";
aggTest.str().Salary = "14.36";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "5";
aggTest.str().FirstName = "Jane";
aggTest.str().LastName = "Rapaport";
aggTest.str().Age = "44";
aggTest.str().HireDate = "2002-05-02 00:00:00";
aggTest.str().Salary = "13.56";
aggTest.str().IsActive = "false";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "4";
aggTest.str().FirstName = "Paul";
aggTest.str().LastName = "Gellar";
aggTest.str().Age = "16";
aggTest.str().HireDate = "2000-09-27 00:00:00";
aggTest.str().Salary = "18.44";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "2";
aggTest.str().FirstName = "John";
aggTest.str().LastName = "Jones";
aggTest.str().Age = "31";
aggTest.str().HireDate = "2002-04-22 00:00:00";
aggTest.str().Salary = "17.65";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "3";
aggTest.str().FirstName = "Michelle";
aggTest.str().LastName = "Johnson";
aggTest.str().Age = "45";
aggTest.str().HireDate = "2003-11-14 00:00:00";
aggTest.str().Salary = "16.86";
aggTest.str().IsActive = "false";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "2";
aggTest.str().FirstName = "David";
aggTest.str().LastName = "Costner";
aggTest.str().Age = "17";
aggTest.str().HireDate = "2002-04-11 00:00:00";
aggTest.str().Salary = "21.74";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "4";
aggTest.str().FirstName = "William";
aggTest.str().LastName = "Gellar";
aggTest.str().Age = "32";
aggTest.str().HireDate = "2003-11-04 00:00:00";
aggTest.str().Salary = "20.94";
aggTest.str().IsActive = "false";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "3";
aggTest.str().FirstName = "Sally";
aggTest.str().LastName = "Rapaport";
aggTest.str().Age = "39";
aggTest.str().HireDate = "2002-04-01 00:00:00";
aggTest.str().Salary = "25.82";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "5";
aggTest.str().FirstName = "Jane";
aggTest.str().LastName = "Vincent";
aggTest.str().Age = "18";
aggTest.str().HireDate = "2003-10-25 00:00:00";
aggTest.str().Salary = "25.03";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "2";
aggTest.str().FirstName = "Fred";
aggTest.str().LastName = "Costner";
aggTest.str().Age = "33";
aggTest.str().HireDate = "1998-05-20 00:00:00";
aggTest.str().Salary = "24.24";
aggTest.str().IsActive = "false";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "1";
aggTest.str().FirstName = "John";
aggTest.str().LastName = "Johnson";
aggTest.str().Age = "40";
aggTest.str().HireDate = "2003-10-15 00:00:00";
aggTest.str().Salary = "29.12";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "3";
aggTest.str().FirstName = "Michelle";
aggTest.str().LastName = "Rapaport";
aggTest.str().Age = "19";
aggTest.str().HireDate = "1998-05-10 00:00:00";
aggTest.str().Salary = "28.32";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "4";
aggTest.str().FirstName = "Sarah";
aggTest.str().LastName = "Doe";
aggTest.str().Age = "34";
aggTest.str().HireDate = "1999-12-03 00:00:00";
aggTest.str().Salary = "27.53";
aggTest.str().IsActive = "false";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "4";
aggTest.str().FirstName = "William";
aggTest.str().LastName = "Jones";
aggTest.str().Age = "41";
aggTest.str().HireDate = "1998-04-30 00:00:00";
aggTest.str().Salary = "32.41";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "1";
aggTest.str().FirstName = "Sarah";
aggTest.str().LastName = "McDonald";
aggTest.str().Age = "21";
aggTest.str().HireDate = "1999-11-23 00:00:00";
aggTest.str().Salary = "31.62";
aggTest.str().IsActive = "false";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "4";
aggTest.str().FirstName = "Jane";
aggTest.str().LastName = "Costner";
aggTest.str().Age = "28";
aggTest.str().HireDate = "1998-04-20 00:00:00";
aggTest.str().Salary = "36.50";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "2";
aggTest.str().FirstName = "Fred";
aggTest.str().LastName = "Douglas";
aggTest.str().Age = "42";
aggTest.str().HireDate = "1999-11-13 00:00:00";
aggTest.str().Salary = "35.71";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "3";
aggTest.str().FirstName = "Sarah";
aggTest.str().LastName = "Jones";
aggTest.str().Age = "22";
aggTest.str().HireDate = "2001-06-07 00:00:00";
aggTest.str().Salary = "34.91";
aggTest.str().IsActive = "false";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "3";
aggTest.str().FirstName = "Michelle";
aggTest.str().LastName = "Doe";
aggTest.str().Age = "29";
aggTest.str().HireDate = "1999-11-03 00:00:00";
aggTest.str().Salary = "39.79";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "4";
aggTest.str().FirstName = "Paul";
aggTest.str().LastName = "Costner";
aggTest.str().Age = "43";
aggTest.str().HireDate = "2001-05-28 00:00:00";
aggTest.str().Salary = "39.00";
aggTest.str().IsActive = "true";
aggTest = aggTestColl.AddNew();
aggTest.str().DepartmentID = "0";
aggTest.str().FirstName = "";
aggTest.str().LastName = "";
aggTest.str().Age = "0";
aggTest.str().Salary = "0";
aggTest = aggTestColl.AddNew();
aggTest = aggTestColl.AddNew();
aggTest = aggTestColl.AddNew();
aggTest = aggTestColl.AddNew();
aggTest = aggTestColl.AddNew();
aggTestColl.Save();
}
public void CollectionChangesBinary()
{
if (aggTestColl.es.Connection.Name == "SqlCe")
{
Assert.Ignore("Not tested for SqlCe.");
}
else
{
aggTestColl.LoadAll();
Assert.AreEqual(30, aggTestColl.Count, "Old");
aggTestColl.Filter = aggTestColl.AsQueryable().OrderBy(s => s.Id);
aggTestColl[0].MarkAsDeleted();
foreach (AggregateTest entity in aggTestColl)
{
if (entity.LastName == "Doe")
{
entity.LastName = "Changed";
}
}
aggTest = aggTestColl.AddNew();
aggTest.LastName = "New";
int rowCount = 0;
foreach (AggregateTest r in aggTestColl)
{
if (r.es.IsAdded || r.es.IsModified)
{
rowCount++;
}
}
foreach (AggregateTest r in aggTestColl.es.DeletedEntities)
{
rowCount++;
}
//aggTestColl.RowStateFilter = DataViewRowState.ModifiedCurrent |
// DataViewRowState.Deleted |
// DataViewRowState.Added;
Assert.AreEqual(4, rowCount, "OldFiltered");
BinaryFormatter bf = new BinaryFormatter();
MemoryStream ms = new MemoryStream();
bf.Serialize(ms, aggTestColl);
ms.Position = 0;
aggCloneColl = (AggregateTestCollection)bf.Deserialize(ms);
ms.Close();
Assert.AreEqual(30, aggCloneColl.Count, "New");
rowCount = 0;
foreach (AggregateTest r in aggTestColl)
{
if (r.es.IsAdded|| r.es.IsModified)
{
rowCount++;
}
}
foreach (AggregateTest r in aggTestColl.es.DeletedEntities)
{
rowCount++;
}
//aggCloneColl.RowStateFilter = DataViewRowState.ModifiedCurrent |
// DataViewRowState.Deleted |
// DataViewRowState.Added;
Assert.AreEqual(4, rowCount, "NewFiltered");
}
}
public void AliasAndGetColumn()
{
int totalNo = 0;
AggregateTestCollection collection = new AggregateTestCollection();
collection.Query.Select(
collection.Query.Age.Sum().As("total"));
collection.Query.Load();
totalNo = Convert.ToInt32(collection[0].GetColumn("total"));
Assert.AreEqual(726, totalNo);
}
