Model

Für weitere Beispielabfragen wird das folgende Modell verwendet.

Natürlich, hier sind die Klassen City, Product, Order, Customer und Service als Markdown-Tabellen mit den jeweiligen Werten:

City

Zipcode	CityName
10115	Berlin
20095	Hamburg
50667	Köln
60311	Frankfurt am Main
80331	München
01067	Dresden
90402	Nürnberg
70173	Stuttgart
20095	Hamburg
33602	Bielefeld
48143	Münster
48153	Münster
48152	Münster
28195	Bremen
76133	Karlsruhe
40213	Düsseldorf
54290	Trier

Product

ProductId	ProductName	Price
1	Apfel	0.5
2	Banane	0.7
3	Birne	0.6
4	Kiwi	0.8
5	Orange	0.9
6	Zitrone	0.3
7	Gurke	1.0
8	Tomate	1.2
9	Kartoffel	0.4
10	Karotte	0.5
11	Zwiebel	0.3
12	Paprika	1.5
13	Brokkoli	2.0
14	Spinat	1.8
15	Kohl	1.3

Order

OrderId	ProductId	Quantity	Shipped
1	1	2	true
2	3	5	false
3	2	1	true
4	4	3	true
5	1	2	false
6	7	1	true
7	6	4	false
8	1	3	true
9	8	2	false
10	10	1	true
11	12	4	true
12	11	2	false
13	13	3	true
14	15	2	false
15	14	1	true

Customer

CustomerId	Firstname	Surname	Orders
1	Anna	Müller	[1, 5, 7, 11, 14]
2	Max	Schmidt	[12, 6, 15]
3	Julia	Fischer	[13]
4	Felix	Weber	[2, 1, 10]
5	Lisa	Schneider	[3, 8, 9]

Service

Die Klasse Service enthält statische Arrays von City, Product, Order und Customer-Objekten, wie in Ihrem ursprünglichen Beispiel angegeben.

Hierfür gibt es eine Serviceklasse die verwendet werden kann.

public class Service
{
    public static City[] Cities => cities;
    public static Product[] Products => products;
    public static Order[] Orders => orders;
    public static Customer[] Customers => customers;

    private static City[] cities = {
        new City { Zipcode = 10115, CityName = "Berlin" },
        new City { Zipcode = 20095, CityName = "Hamburg" },
        new City { Zipcode = 50667, CityName = "Köln" },
        new City { Zipcode = 60311, CityName = "Frankfurt am Main" },
        new City { Zipcode = 80331, CityName = "München" },
        new City { Zipcode = 01067, CityName = "Dresden" },
        new City { Zipcode = 90402, CityName = "Nürnberg" },
        new City { Zipcode = 70173, CityName = "Stuttgart" },
        new City { Zipcode = 20095, CityName = "Hamburg" },
        new City { Zipcode = 33602, CityName = "Bielefeld" },
        new City { Zipcode = 48143, CityName = "Münster" },
        new City { Zipcode = 48153, CityName = "Münster" },
        new City { Zipcode = 48152, CityName = "Münster" },
        new City { Zipcode = 28195, CityName = "Bremen" },
        new City { Zipcode = 76133, CityName = "Karlsruhe" },
        new City { Zipcode = 40213, CityName = "Düsseldorf" },
        new City { Zipcode = 54290, CityName = "Trier" }
    };

    private static Product[] products =
    {
        new Product { ProductId = 1, ProductName = "Apfel", Price = 0.5 },
        new Product { ProductId = 2, ProductName = "Banane", Price = 0.7 },
        new Product { ProductId = 3, ProductName = "Birne", Price = 0.6 },
        new Product { ProductId = 4, ProductName = "Kiwi", Price = 0.8 },
        new Product { ProductId = 5, ProductName = "Orange", Price = 0.9 },
        new Product { ProductId = 6, ProductName = "Zitrone", Price = 0.3 },
        new Product { ProductId = 7, ProductName = "Gurke", Price = 1.0 },
        new Product { ProductId = 8, ProductName = "Tomate", Price = 1.2 },
        new Product { ProductId = 9, ProductName = "Kartoffel", Price = 0.4 },
        new Product { ProductId = 10, ProductName = "Karotte", Price = 0.5 },
        new Product { ProductId = 11, ProductName = "Zwiebel", Price = 0.3 },
        new Product { ProductId = 12, ProductName = "Paprika", Price = 1.5 },
        new Product { ProductId = 13, ProductName = "Brokkoli", Price = 2.0 },
        new Product { ProductId = 14, ProductName = "Spinat", Price = 1.8 },
        new Product { ProductId = 15, ProductName = "Kohl", Price = 1.3 }
    };

    private static Order[] orders = new Order[]
    {
        new Order() { OrderId = 1, ProductId = 1, Quantity = 2, Shipped = true },
        new Order() { OrderId = 2, ProductId = 3, Quantity = 5, Shipped = false },
        new Order() { OrderId = 3, ProductId = 2, Quantity = 1, Shipped = true },
        new Order() { OrderId = 4, ProductId = 4, Quantity = 3, Shipped = true },
        new Order() { OrderId = 5, ProductId = 1, Quantity = 2, Shipped = false },
        new Order() { OrderId = 6, ProductId = 7, Quantity = 1, Shipped = true },
        new Order() { OrderId = 7, ProductId = 6, Quantity = 4, Shipped = false },
        new Order() { OrderId = 8, ProductId = 1, Quantity = 3, Shipped = true },
        new Order() { OrderId = 9, ProductId = 8, Quantity = 2, Shipped = false },
        new Order() { OrderId = 10, ProductId = 10, Quantity = 1, Shipped = true },
        new Order() { OrderId = 11, ProductId = 12, Quantity = 4, Shipped = true },
        new Order() { OrderId = 12, ProductId = 11, Quantity = 2, Shipped = false },
        new Order() { OrderId = 13, ProductId = 13, Quantity = 3, Shipped = true },
        new Order() { OrderId = 14, ProductId = 15, Quantity = 2, Shipped = false },
        new Order() { OrderId = 15, ProductId = 14, Quantity = 1, Shipped = true },
    };

    public static Customer[] customers = new Customer[]
    {
        new Customer { CustomerId = 1, Firstname = "Anna", Surname = "Müller",
            Orders = new Order[]{orders[3], orders[4], orders[6], orders[10], orders[13] }},
        new Customer { CustomerId = 2, Firstname = "Max", Surname = "Schmidt",
            Orders = new Order[]{orders[11], orders[5], orders[14] }},
        new Customer { CustomerId = 3, Firstname = "Julia", Surname = "Fischer",
            Orders = new Order[]{ orders[12] }},
        new Customer { CustomerId = 4, Firstname = "Felix", Surname = "Weber",
            Orders = new Order[]{orders[1], orders[0], orders[9] }},
        new Customer { CustomerId = 5, Firstname = "Lisa", Surname = "Schneider",
            Orders = new Order[]{orders[2], orders[7], orders[8] }},
    };
}

Model​

City​

Product​

Order​

Customer​

Service​

Kommentare