static void Main(string[] args)
{
using (CopenhagenAirportH3Entities ctx = new CopenhagenAirportH3Entities())
{
SQLQuery.Query(ctx);
foreach (Airport airport in ctx.Airports)
{
Console.WriteLine("IATA: " + airport.IATA);
Console.WriteLine("Name: " + airport.Name);
foreach (Airline routeOwner in airport.Airlines)
{
Console.WriteLine("Owner: " + routeOwner.Name);
}
foreach (Airline route in airport.Airlines1)
{
Console.WriteLine("Route: " + route.Name);
}
Console.WriteLine("------------");
}
Console.ReadKey();
};
}
public static void Query(CopenhagenAirportH3Entities ctx)
{
Airport cph = new Airport()
{
IATA = "CPH", Name = "Copenhagen"
};
Airport cai = new Airport()
{
IATA = "CAI", Name = "Cairo"
};
Airport aar = new Airport()
{
IATA = "AAR", Name = "Arhus"
};
Airport aal = new Airport()
{
IATA = "AAL", Name = "Aalborg"
};
Airport ams = new Airport()
{
IATA = "AMS", Name = "Amsterdam"
};
Airport lax = new Airport()
{
IATA = "LAX", Name = "Los Angeles"
};
ctx.Airports.Add(cph);
ctx.Airports.Add(cai);
ctx.Airports.Add(aar);
ctx.Airports.Add(aal);
ctx.Airports.Add(ams);
ctx.Airports.Add(lax);
Airline sas = new Airline()
{
Name = "SAS"
};
Airline klm = new Airline()
{
Name = "KLM"
};
Airline nostrum = new Airline()
{
Name = "Air Nostrum"
};
Airline norwegwian = new Airline()
{
Name = "Norwegian"
};
Airline egyptAir = new Airline()
{
Name = "EgyptAir"
};
ctx.Airlines.Add(sas);
ctx.Airlines.Add(klm);
ctx.Airlines.Add(nostrum);
ctx.Airlines.Add(norwegwian);
ctx.Airlines.Add(egyptAir);
ctx.Airports.Find(cph).Airlines.Add(sas);
ctx.Airports.Find(aar).Airlines.Add(sas);
ctx.Airports.Find(aal).Airlines.Add(sas);
ctx.Airports.Find(cai).Airlines.Add(egyptAir);
ctx.Airports.Find(ams).Airlines.Add(klm);
ctx.Airports.Find(lax).Airlines.Add(nostrum);
ctx.Airports.Find(aar).Airlines1.Add(sas);
ctx.Airports.Find(aar).Airlines1.Add(norwegwian);
ctx.Airports.Find(aal).Airlines1.Add(sas);
ctx.Airports.Find(cai).Airlines1.Add(egyptAir);
ctx.Airports.Find(ams).Airlines1.Add(klm);
ctx.Airports.Find(ams).Airlines1.Add(sas);
ctx.Airports.Find(lax).Airlines1.Add(nostrum);
}