public void TestVbStrComp() { // // Create list People. // var lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; Test.Add(lst, p1); People p2 = new People() { FirstName = "John", LastName = "De Smet", Age = 54, IsMember = false, ShortBio = "Family" }; Test.Add(lst, p2); // // Get query with Visual Basic string compare. // var res = TestHelpersVb.Helpers.StrCmp(site).AsEnumerable(); Assert.IsTrue(res.Count() == 1 && res.First().FirstName == "Bart", "Visual Basic string compare parse failure in query predicate."); }
public void GetEntityById() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; Test.Add(lst, p1); // // Get entity by id. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; People _p1 = src.GetEntityById(1, false); Assert.IsTrue(p1.Equals(_p1), "Invalid entity returned by GetEntityById method"); }
public void BoolPredicate() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; People p2 = new People() { ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder" }; Test.Add(lst, p1); Test.Add(lst, p2); // // List source. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; // // Test queries. // AssertWhere(src, p => p.IsMember, 1, "Invalid result for Boolean check (true)"); AssertWhere(src, p => !p.IsMember, 1, "Invalid result for Boolean check (false)"); }
public void ProjectSingleton() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; People p2 = new People() { ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder" }; Test.Add(lst, p1); Test.Add(lst, p2); // // List source. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; // // Projections. // AssertProject(src, p => p.Age, new double[] { 24, 52 }, "Integer projection failure"); AssertProject(src, p => p.FirstName + " " + p.LastName, new string[] { "Bart De Smet", "Bill Gates" }, "String projection failure"); }
public void DefaultQuery() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; Test.Add(lst, p1); // // Test default query. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; var res1 = (from p in src select p).AsEnumerable(); Assert.IsTrue(res1.Count() == 1, "Query did not return results."); }
public void MultiWhere() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; People p2 = new People() { ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder" }; Test.Add(lst, p1); Test.Add(lst, p2); // // List source. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; // // Multipe where clauses. // var res1 = (from p in src where p.Age >= 24 where p.FirstName == "Bart" select p).AsEnumerable(); Assert.IsTrue(res1.Count() == 1 && res1.First().FirstName == "Bart", "Invalid result for multiple where clauses (1)."); var res2 = (from p in src where p.FirstName == "Bart" where p.Age >= 24 select p).AsEnumerable(); Assert.IsTrue(res2.Count() == 1 && res2.First().FirstName == "Bart", "Invalid result for multiple where clauses (2)."); var res3 = (from p in src where 1 == 1 where p.FirstName == "Bart" select p).AsEnumerable(); Assert.IsTrue(res3.Count() == 1 && res3.First().FirstName == "Bart", "Invalid result for multiple where clauses (3)."); var res4 = (from p in src where p.FirstName == "Bart" where 1 == 1 select p).AsEnumerable(); Assert.IsTrue(res4.Count() == 1 && res4.First().FirstName == "Bart", "Invalid result for multiple where clauses (4)."); var res5 = (from p in src where 1 == 0 where p.FirstName == "Bart" select p).AsEnumerable(); Assert.IsTrue(res5.Count() == 0, "Invalid result for multiple where clauses (5)."); var res6 = (from p in src where p.FirstName == "Bart" where 1 == 0 select p).AsEnumerable(); Assert.IsTrue(res6.Count() == 0, "Invalid result for multiple where clauses (6)."); }
public void BooleanOptimizations() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; People p2 = new People() { ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder" }; People p3 = new People() { ID = 3, FirstName = "Bart", LastName = "Simpson", Age = 15, IsMember = false, ShortBio = "Funny guy" }; People p4 = new People() { ID = 4, FirstName = "Ray", LastName = "Ozzie", Age = 52, IsMember = false, ShortBio = "Chief Software Architect at Microsoft Corporation" }; People p5 = new People() { ID = 5, FirstName = "Anders", LastName = "Hejlsberg", Age = 47, IsMember = true, ShortBio = "C# language architect" }; Test.Add(lst, p1); Test.Add(lst, p2); Test.Add(lst, p3); Test.Add(lst, p4); Test.Add(lst, p5); // // List source. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; // // Optimize. // AssertWhere(src, p => 1 == 1, 5, "Boolean optimization failed (1)."); AssertWhere(src, p => 1 == 0, 0, "Boolean optimization failed (2)."); AssertWhere(src, p => p.FirstName == "Bart" && 1 == 1, 2, "Boolean optimization failed (3)."); AssertWhere(src, p => p.FirstName == "Bart" && 1 == 0, 0, "Boolean optimization failed (4)."); AssertWhere(src, p => p.FirstName == "Bart" || 1 == 1, 5, "Boolean optimization failed (5)."); AssertWhere(src, p => p.FirstName == "Bart" || 1 == 0, 2, "Boolean optimization failed (6)."); }
public void NullChecks() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = null, LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; People p2 = new People() { ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder" }; Test.Add(lst, p1); Test.Add(lst, p2); // // List source. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; // // Test queries. // AssertWhere(src, p => p.FirstName == null, 1, "Invalid IsNull result"); //AssertWhere(src, p => p.FirstName.Equals(null), 1, "Invalid IsNull result (.Equals)"); AssertWhere(src, p => null == p.FirstName, 1, "Invalid IsNull result (inverse)"); AssertWhere(src, p => p.FirstName != null, 1, "Invalid IsNotNull result"); //AssertWhere(src, p => !p.FirstName.Equals(null), 1, "Invalid IsNotNull result (.Equals)"); AssertWhere(src, p => null != p.FirstName, 1, "Invalid IsNotNull result (inverse)"); AssertWhere(src, p => !(p.FirstName == null), 1, "Invalid IsNotNull result 2"); AssertWhere(src, p => !(null == p.FirstName), 1, "Invalid IsNotNull result 2 (inverse)"); // // Use of variable. // string s = null; AssertWhere(src, p => p.FirstName == s, 1, "Invalid IsNull result (variable)"); AssertWhere(src, p => s == p.FirstName, 1, "Invalid IsNull result (variable) (inverse)"); AssertWhere(src, p => p.FirstName != s, 1, "Invalid IsNotNull result (variable)"); AssertWhere(src, p => s != p.FirstName, 1, "Invalid IsNotNull result (variable) (inverse)"); }
public void ComplexProjection() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; People p2 = new People() { ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder" }; Test.Add(lst, p1); Test.Add(lst, p2); // // List source. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; // // Complex projection. Should trigger recursive parsing of the projection expression to find view fields. // var res = (from p in src where p.Age == 24 select new { p.FirstName, Ages = new double[] { p.Age }, Ages2 = new List <double>() { p.Age }, DoubleAge = p.Age * 2, Member = p.IsMember ? p.IsMember : p.IsMember, NoMember = !p.IsMember, NameLower = (p.FirstName + " " + p.LastName).ToLower(), LastName = new String(p.LastName.ToCharArray()), CharactersInBio = Helper(p.ShortBio) }).AsEnumerable().First(); Assert.IsTrue(res.FirstName == "Bart" && res.Ages[0] == 24 && res.Ages2[0] == 24 && res.DoubleAge == 48 && res.Member == true && res.NoMember == false && res.NameLower == "bart de smet" && res.LastName == "De Smet" && res.CharactersInBio == 15); }
public void Nullable() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, SecondAge = 24, IsMember = true, ShortBio = "Project founder" }; People p2 = new People() { ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, SecondAge = null, IsMember = false, ShortBio = "Microsoft Corporation founder" }; People p3 = new People() { ID = 3, FirstName = "William", LastName = "Gates", Age = 52, SecondAge = null, IsMember = false, ShortBio = "Microsoft Corporation founder" }; Test.Add(lst, p1); Test.Add(lst, p2); Test.Add(lst, p3); // // List source. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; // // Test queries. // AssertWhere(src, p => p.SecondAge.HasValue, 1, "Invalid result for nullable query (1)"); AssertWhere(src, p => !p.SecondAge.HasValue, 2, "Invalid result for nullable query (2)"); AssertWhere(src, p => p.SecondAge != null, 1, "Invalid result for nullable query (3)"); AssertWhere(src, p => p.SecondAge == null, 2, "Invalid result for nullable query (4)"); AssertWhere(src, p => p.SecondAge == 24, 1, "Invalid result for nullable query (5)"); AssertWhere(src, p => p.SecondAge.Value == 24, 1, "Invalid result for nullable query (6)"); AssertWhere(src, p => p.SecondAge >= 25, 0, "Invalid result for nullable query (7)"); }
public void Contains() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; People p2 = new People() { ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder" }; Test.Add(lst, p1); Test.Add(lst, p2); // // List source. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; // // Contains empty string. // AssertWhere(src, p => p.ShortBio.Contains(""), 2, "Contains with empty string failed"); // // Contains with valid parameter. // AssertWhere(src, p => p.ShortBio.Contains("Corp"), 1, "Contains with valid parameter failed"); // // Contains without results. // AssertWhere(src, p => p.ShortBio.Contains("azerty"), 0, "Empty Contains failed"); }
public void Junk() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; People p2 = new People() { ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder" }; Test.Add(lst, p1); Test.Add(lst, p2); // // List source. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; // // Test. // //var res = (from p in src select p.Age).First(); //24.0 //var res = (from p in src where p.Age > 100 select p.Age).First(); //empty sequence //var res = (from p in src select p.Age).First(p => p > 50); //52.0 //var res = (from p in src select p).First(); //Bart /* * TODO: coalescing of two or more adjacent where clauses; last where clause can't be translated in this case * * var res = from p in src where p.Age == 24 where p.FirstName == "Bart" orderby p.LastName where p.IsMember select p; */ }
public void Take() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; People p2 = new People() { ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder" }; Test.Add(lst, p1); Test.Add(lst, p2); // // List source. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; // // Take operation. // var res1 = (from p in src select p).Take(1).AsEnumerable(); Assert.IsTrue(res1.Count() == 1, "Take failed (1)."); var res2 = (from p in src select p).Take(0).AsEnumerable(); Assert.IsTrue(res2.Count() == 0, "Take failed (2)."); var res3 = (from p in src select p).Take(3).AsEnumerable(); Assert.IsTrue(res3.Count() == 2, "Take failed (3)."); }
public void TestWsAndSp() { /* * Temporary test to check ws results against sp results. */ // // Create list People. // var lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; Test.Add(lst, p1); // // Sources. // SharePointDataSource <People> sp = new SharePointDataSource <People>(site); sp.CheckListVersion = false; SharePointDataSource <People> ws = new SharePointDataSource <People>(url); ws.CheckListVersion = false; // // Test. // AssertWsEqualsSp <People>(ws, sp, p => p.FirstName.StartsWith("B"), "WS and SP data source did not return the same results."); }
public void AndOr() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; People p2 = new People() { ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder" }; People p3 = new People() { ID = 3, FirstName = "Bart", LastName = "Simpson", Age = 15, IsMember = false, ShortBio = "Funny guy" }; People p4 = new People() { ID = 4, FirstName = "Ray", LastName = "Ozzie", Age = 52, IsMember = false, ShortBio = "Chief Software Architect at Microsoft Corporation" }; People p5 = new People() { ID = 5, FirstName = "Anders", LastName = "Hejlsberg", Age = 47, IsMember = true, ShortBio = "C# language architect" }; Test.Add(lst, p1); Test.Add(lst, p2); Test.Add(lst, p3); Test.Add(lst, p4); Test.Add(lst, p5); // // List source. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; // // And. // AssertWhere(src, p => p.FirstName == "Bart" && p.Age >= 24, 1, "And failed (1)."); AssertWhere(src, p => p.ShortBio.Contains("Microsoft") && p.Age == 52, 2, "And failed (2)."); AssertWhere(src, p => p.FirstName.StartsWith("B") && p.IsMember && p.ShortBio.Contains("founder"), 1, "And failed (3)."); // // Or. // AssertWhere(src, p => p.Age == 24 || p.Age == 52, 3, "Or failed (1)."); AssertWhere(src, p => p.Age == 52 || p.FirstName == "Bart", 4, "Or failed (2)."); AssertWhere(src, p => p.Age >= 40 || p.Age <= 20 || p.Age == 24, 5, "Or failed (3)."); // // Mixed. // AssertWhere(src, p => p.FirstName.StartsWith("B") && (p.Age == 24 || p.Age == 52), 2, "And/Or failed (1)."); AssertWhere(src, p => p.FirstName.StartsWith("B") || (p.FirstName == "Anders" && p.Age >= 40), 4, "And/Or failed (2)."); // // De Morgan. // AssertWhere(src, p => !(p.FirstName == "Bart" && p.Age <= 24), 3, "De Morgan failed (1)."); AssertWhere(src, p => !(p.FirstName == "Bill" || p.LastName == "De Smet"), 3, "De Morgan failed (2)."); }
public void Ordering() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; People p2 = new People() { ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder" }; People p3 = new People() { ID = 3, FirstName = "Bart", LastName = "Simpson", Age = 15, IsMember = false, ShortBio = "Funny guy" }; People p4 = new People() { ID = 4, FirstName = "Ray", LastName = "Ozzie", Age = 52, IsMember = false, ShortBio = "Chief Software Architect at Microsoft Corporation" }; People p5 = new People() { ID = 5, FirstName = "Anders", LastName = "Hejlsberg", Age = 47, IsMember = true, ShortBio = "C# language architect" }; Test.Add(lst, p1); Test.Add(lst, p2); Test.Add(lst, p3); Test.Add(lst, p4); Test.Add(lst, p5); // // List source. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; // // Ascending. // var res1 = (from p in src orderby p.FirstName select p).AsEnumerable().ToArray(); Assert.IsTrue(res1.First().FirstName == "Anders" && res1.Last().FirstName == "Ray", "Ascending order failed"); // // Descending. // var res2 = (from p in src orderby p.LastName descending select p).AsEnumerable().ToArray(); Assert.IsTrue(res2.First().LastName == "Simpson" && res2.Last().LastName == "De Smet", "Descending order failed"); // // Multiple. // var res3 = (from p in src orderby p.Age ascending, p.FirstName descending select p).AsEnumerable().ToArray(); Assert.IsTrue(res3.First().LastName == "Simpson" && res3.Last().LastName == "Gates", "OrderBy/ThenBy failed"); }
public void DateTime() { // // Create list DateTimeTest. // var lst = Test.Create <DateTimeTest>(site.RootWeb); // // Add items. // System.DateTime now = System.DateTime.Now; //new System.DateTime(2007, 5, 21, 11, 11, 0); DateTimeTest t1 = new DateTimeTest() { ID = 1, Name = "Yesterday", DateTime = System.DateTime.Today.AddDays(-1) }; DateTimeTest t2 = new DateTimeTest() { ID = 2, Name = "Today", DateTime = System.DateTime.Today }; DateTimeTest t3 = new DateTimeTest() { ID = 3, Name = "Tomorrow", DateTime = System.DateTime.Today.AddDays(1) }; DateTimeTest t4 = new DateTimeTest() { ID = 4, Name = "Now", DateTime = now }; Test.Add(lst, t1); Test.Add(lst, t2); Test.Add(lst, t3); Test.Add(lst, t4); // // List source. // SharePointDataSource <DateTimeTest> src = new SharePointDataSource <DateTimeTest>(site); src.CheckListVersion = false; // // Queries. // var res1 = (from t in src where t.DateTime == now select t).AsEnumerable(); //KNOWN ISSUE with Eq check on hh:MM:ss (2032) Assert.IsTrue(res1.Count() == 2, "DateTime test failure (1)."); var res2 = (from t in src where t.DateTime > System.DateTime.Today select t).AsEnumerable(); Assert.IsTrue(res2.Count() == 1, "DateTime test failure (2)."); var res3 = (from t in src where t.DateTime < System.DateTime.Today select t).AsEnumerable(); Assert.IsTrue(res3.Count() == 1, "DateTime test failure (3)."); var res4 = (from t in src where t.DateTime == System.DateTime.Today select t).AsEnumerable(); Assert.IsTrue(res4.Count() == 2, "DateTime test failure (4)."); var res5 = (from t in src where t.DateTime <= System.DateTime.Today select t).AsEnumerable(); Assert.IsTrue(res5.Count() == 3, "DateTime test failure (5)."); // // TODO: Check for eligible use of Now. // }
public void LtLeqGtGeq() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; People p2 = new People() { ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder" }; Test.Add(lst, p1); Test.Add(lst, p2); // // List source. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; // // Gt // AssertWhere(src, p => p.Age > 50, 1, "Invalid Gt result"); AssertWhere(src, p => 50 < p.Age, 1, "Invalid Gt result (inverse)"); AssertWhere(src, p => !(p.Age <= 50), 1, "Invalid Gt result (negated)"); AssertWhere(src, p => !(50 >= p.Age), 1, "Invalid Gt result (negated) (inverse)"); // // Geq // AssertWhere(src, p => p.Age >= 52, 1, "Invalid Geq result"); AssertWhere(src, p => 52 <= p.Age, 1, "Invalid Geq result (inverse)"); AssertWhere(src, p => !(p.Age < 52), 1, "Invalid Geq result (negated)"); AssertWhere(src, p => !(52 > p.Age), 1, "Invalid Geq result (negated) (inverse)"); // // Lt // AssertWhere(src, p => p.Age < 25, 1, "Invalid Lt result"); AssertWhere(src, p => 25 > p.Age, 1, "Invalid Lt result (inverse)"); AssertWhere(src, p => !(p.Age >= 25), 1, "Invalid Lt result (negated)"); AssertWhere(src, p => !(25 <= p.Age), 1, "Invalid Lt result (negated) (inverse)"); // // Leq // AssertWhere(src, p => p.Age <= 24, 1, "Invalid Leq result"); AssertWhere(src, p => 24 >= p.Age, 1, "Invalid Leq result (inverse)"); AssertWhere(src, p => !(p.Age > 24), 1, "Invalid Leq result (negated)"); AssertWhere(src, p => !(24 < p.Age), 1, "Invalid Leq result (negated) (inverse)"); }
public void StringEquality() { // // Create list People. // lst = Test.Create <People>(site.RootWeb); // // Add items. // People p1 = new People() { ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder" }; People p2 = new People() { ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder" }; Test.Add(lst, p1); Test.Add(lst, p2); // // List source. // SharePointDataSource <People> src = new SharePointDataSource <People>(site); src.CheckListVersion = false; // // Using == // AssertWhere(src, p => p.FirstName == "Bart", 1, "Equality check failed (==)"); AssertWhere(src, p => p.FirstName != "Bart", 1, "Inequality check failed (!=)"); // // Using .Equals // AssertWhere(src, p => p.FirstName.Equals("Bart"), 1, "Equality check failed (.Equals)"); AssertWhere(src, p => !p.FirstName.Equals("Bart"), 1, "Inequality check failed (!.Equals)"); // // Using == inverse order // AssertWhere(src, p => "Bart" == p.FirstName, 1, "Equality check failed (== inverse order)"); AssertWhere(src, p => "Bart" != p.FirstName, 1, "Inquality check failed (!= inverse order)"); // // Using .Equals inverse order (NOT SUPPORTED) // //AssertWhere(src, p => "Bart".Equals(p.FirstName), 1, "Equality check failed (.Equals inverse order)"); // // Using == with .ToString // AssertWhere(src, p => p.FirstName.ToString() == "Bart".ToString(), 1, "Equality check failed (== with .ToString)"); // // Using .Equals with .ToString // AssertWhere(src, p => p.FirstName.ToString().Equals("Bart".ToString()), 1, "Equality check failed (.Equals with .ToString)"); // // Using == with .ToString // AssertWhere(src, p => p.FirstName.ToString() == "Bart".ToString(), 1, "Equality check failed (== with .ToString inverse order)"); // // Using .Equals with .ToString // //AssertWhere(src, p => p.FirstName.ToString().Equals("Bart".ToString()), 1, "Equality check failed (.Equals with .ToString inverse order)"); }