Example #1
0
        static void Main(string[] args)
        {
            // Connection string defined in LinqToSqlApp project settings.
            string connectionString = global::LinqToSqlApp.Properties.Settings.Default.PersonDataConnectionString;

            using (PersonService service = new PersonService(connectionString))
            {
                IEnumerable<Person> all = service.GetAllPersons();
                Display("Everyone", all);

                Console.WriteLine();

                const string lastName = "Kowalski";
                const int minAge = 25;
                const int change = 11;

                Display("With last name '" + lastName + "'", service.FilterPersonsByLastName(lastName));

                Console.WriteLine();

                Display("After finishing studies", service.FilterPersonsByMinAge(minAge));
                Display("Forward " + change + " years", service.ChangeAgeThenFilterPersonsByMinAge(change, minAge));
                Display("And back " + change + " years", service.ChangeAgeThenFilterPersonsByMinAge(-change, minAge));
            }
            Console.ReadLine();
        }
Example #2
0
 public void Init()
 {
     service = new PersonService(connectionString);
 }