public void GetListTest()
{
using (TestSqlDataSource testDataSource = new TestSqlDataSource("default"))
{
testDataSource.Open();
using (SoodaTransaction tran = new SoodaTransaction())
{
tran.RegisterDataSource(testDataSource);
Contact mary = Contact.Load(1);
//mary.Name = "Ala ma kota";
Contact ed = Contact.Load(2);
ed.PrimaryGroup = null;
ContactList list = Contact.GetList(tran, new SoodaWhereClause("PrimaryGroup.Manager.Name = 'Mary Manager'"), SoodaSnapshotOptions.Default);
Console.WriteLine("Len: {0}", list.Count);
SoodaObjectMultiFieldComparer comparer = new SoodaObjectMultiFieldComparer();
comparer.AddField(new string[] { "PrimaryGroup", "Name" }, SortOrder.Ascending);
comparer.AddField("LastSalary", SortOrder.Ascending);
comparer.AddField("Name", SortOrder.Descending);
foreach (Contact c in list.Sort(comparer).Filter(new SoodaObjectFilter(predicate1)))
{
Console.WriteLine("Member: {0} - {2} - {1}", c.Evaluate("PrimaryGroup.Name"), c.Name, c.LastSalary);
}
tran.Commit();
}
}
}
public void GetListTest()
{
using (TestSqlDataSource testDataSource = new TestSqlDataSource("default"))
{
testDataSource.Open();
using (SoodaTransaction tran = new SoodaTransaction())
{
tran.RegisterDataSource(testDataSource);
Contact mary = Contact.Load(1);
//mary.Name = "Ala ma kota";
Contact ed = Contact.Load(2);
ed.PrimaryGroup = null;
ContactList list = Contact.GetList(tran, new SoodaWhereClause("PrimaryGroup.Manager.Name = 'Mary Manager'"), SoodaSnapshotOptions.Default);
Console.WriteLine("Len: {0}", list.Count);
SoodaObjectMultiFieldComparer comparer = new SoodaObjectMultiFieldComparer();
comparer.AddField(new string[] { "PrimaryGroup", "Name" }, SortOrder.Ascending);
comparer.AddField("LastSalary", SortOrder.Ascending);
comparer.AddField("Name", SortOrder.Descending);
foreach (Contact c in list.Sort(comparer).Filter(new SoodaObjectFilter(predicate1)))
{
Console.WriteLine("Member: {0} - {2} - {1}", c.Evaluate("PrimaryGroup.Name"), c.Name, c.LastSalary);
}
tran.Commit();
}
}
}