Esempio n. 1
0
        static void Main(string[] args)
        {
            List<Person> realList = new List<Person>();

            Person p1 = new Person();
            p1.Age = 11;
            p1.FirstName = "Billy";
            p1.LastName = "Boolean";
            p1.Address.City = "Bla town";
            realList.Add (p1);

            Person p2 = new Person();
            p2.Age = 33;
            p2.FirstName = "Ivar";
            p2.LastName = "Integer";
            p2.Address.City = "SomeVille";
            realList.Add (p2);

            Person p3 = new Person();
            p3.Age = 3;
            p3.FirstName = "Sture";
            p3.LastName = "Gates";
            p3.Address.City = "Sharpston";
            realList.Add (p3);

            Person p4 = new Person();
            p4.Age = 55;
            p4.FirstName = "Bill";
            p4.LastName = "Gates";
            p4.Address.City = "larsson";
            realList.Add (p4);

            Person p5 = new Person();
            p5.Age = 30;
            p5.FirstName = null;
            p5.LastName = "Johansson";
            p5.Address.City = "Somewhere";
            realList.Add (p5);

            ////sort
            //RunQuery("order by LastName desc,FirstName asc", realList);

            ////not null
            //RunQuery("where FirstName != null", realList);

            ////sql like
            //RunQuery("where FirstName like 'b%'", realList);

            ////filter on method result
            //RunQuery("where SomeMethod(Age + 3) != 12", realList);

            //property path
            RunQuery("where Address.MyMethod() like 'LARSSON' order by Address.MyMethod() Asc", realList);

            ////complex
            //RunQuery("where Address.City like 's%' and (FirstName != null or LastName = 'Johansson')", realList);

            Console.ReadLine ();
        }
Esempio n. 2
0
        static void Main(string[] args)
        {
            List <Person> realList = new List <Person>();

            Person p1 = new Person();

            p1.Age          = 11;
            p1.FirstName    = "Billy";
            p1.LastName     = "Boolean";
            p1.Address.City = "Bla town";
            realList.Add(p1);

            Person p2 = new Person();

            p2.Age          = 33;
            p2.FirstName    = "Ivar";
            p2.LastName     = "Integer";
            p2.Address.City = "SomeVille";
            realList.Add(p2);

            Person p3 = new Person();

            p3.Age          = 3;
            p3.FirstName    = "Sture";
            p3.LastName     = "Gates";
            p3.Address.City = "Sharpston";
            realList.Add(p3);


            Person p4 = new Person();

            p4.Age          = 55;
            p4.FirstName    = "Bill";
            p4.LastName     = "Gates";
            p4.Address.City = "larsson";
            realList.Add(p4);

            Person p5 = new Person();

            p5.Age          = 30;
            p5.FirstName    = null;
            p5.LastName     = "Johansson";
            p5.Address.City = "Somewhere";
            realList.Add(p5);



            ////sort
            //RunQuery("order by LastName desc,FirstName asc", realList);

            ////not null
            //RunQuery("where FirstName != null", realList);

            ////sql like
            //RunQuery("where FirstName like 'b%'", realList);

            ////filter on method result
            //RunQuery("where SomeMethod(Age + 3) != 12", realList);

            //property path
            RunQuery("where Address.MyMethod() like 'LARSSON' order by Address.MyMethod() Asc", realList);


            ////complex
            //RunQuery("where Address.City like 's%' and (FirstName != null or LastName = 'Johansson')", realList);



            Console.ReadLine();
        }