C# (CSharp) eu.sig.training.ch02 Query.AddColumn Exemples

AddColumn() public méthode

public AddColumn ( string s ) : Query
s	string
Résultat	Query

Exemple #1

Fichier : Employees.cs Projet : ishara/building_maintainable_software

 // tag::printDepartmentEmployees[]
 public static void PrintDepartmentEmployees(string department) {
     Query q = new Query();
     foreach (Employee e in q.AddColumn("FamilyName")
         .AddColumn("Initials")
         .AddColumn("GivenName")
         .AddColumn("AddressLine1")
         .AddColumn("ZIPcode")
         .AddColumn("City")
         .AddTable("EMPLOYEES")
         .AddWhere("EmployeeDep='" + department + "'")
         .Execute()) {
         Console.WriteLine("<div name='addressDiv'" + e.FamilyName
             + ", " + e.Initials + "<br />" + e.AddressLine1
             + "<br />" + e.ZipCode + e.City + "</div>");
     }
 }

Exemple #2

Fichier : Employees.cs Projet : oreillymedia/building_maintainable_software

 // tag::printDepartmentEmployees[]
 public static void PrintDepartmentEmployees(string department)
 {
     Query q = new Query();
     foreach (Employee e in q.AddColumn("FamilyName")
         .AddColumn("Initials")
         .AddColumn("GivenName")
         .AddColumn("AddressLine1")
         .AddColumn("ZIPcode")
         .AddColumn("City")
         .AddTable("EMPLOYEES")
         .AddWhere($"EmployeeDep='{department}'")
         .Execute())
     {
         Console.WriteLine($@"<div name='addressDiv'>
             {e.FamilyName}, {e.Initials}<br />" +
             "{e.AddressLine1}<br />{e.ZipCode}{e.City}</div>");
     }
 }

Exemple #3

        // tag::printDepartmentEmployees[]
        public static void PrintDepartmentEmployees(string department)
        {
            Query q = new Query();

            foreach (Employee e in q.AddColumn("FamilyName")
                     .AddColumn("Initials")
                     .AddColumn("GivenName")
                     .AddColumn("AddressLine1")
                     .AddColumn("ZIPcode")
                     .AddColumn("City")
                     .AddTable("EMPLOYEES")
                     .AddWhere($"EmployeeDep='{department}'")
                     .Execute())
            {
                Console.WriteLine($@"<div name='addressDiv'>
                    {e.FamilyName}, {e.Initials}<br />" +
                                  "{e.AddressLine1}<br />{e.ZipCode}{e.City}</div>");
            }
        }

Exemple #4

Fichier : Employees.cs Projet : wilecoyote1/building_maintainable_software

        // tag::printDepartmentEmployees[]
        public static void PrintDepartmentEmployees(string department)
        {
            Query q = new Query();

            foreach (Employee e in q.AddColumn("FamilyName")
                     .AddColumn("Initials")
                     .AddColumn("GivenName")
                     .AddColumn("AddressLine1")
                     .AddColumn("ZIPcode")
                     .AddColumn("City")
                     .AddTable("EMPLOYEES")
                     .AddWhere("EmployeeDep='" + department + "'")
                     .Execute())
            {
                Console.WriteLine("<div name='addressDiv'" + e.FamilyName
                                  + ", " + e.Initials + "<br />" + e.AddressLine1
                                  + "<br />" + e.ZipCode + e.City + "</div>");
            }
        }