/*
* Questions:
* - SQL Queries?!?
* - how to call the middle table, joins & middle tables
* - When to use a join statement and when not to
* - creating that table
* - Db schema is different from what you imgined
* - JSON Serialization for APIs....
*
*/
static void Main(string[] args)
{
// Given and AQ NAme, what Aquatic Life is there
var db = new AquaContext();
// WITH The "DEFAULT" Tables
var query1 = db.Aquariums
.Include(i => i.AquaticLife)
.Where(w => w.Name == "Fish Tank");
// WITH 4 TABLES
//var query1 = db.AquariumAquaticLifeOcean
// .Include(i => i.Aquarium)
// .Include(i => i.AquaticLife)
// .Include(i => i.Ocean)
// .Where(w => w.Aquarium.Name == "Fish Tank");
//foreach (var item in query1)
//{
// Console.WriteLine(item.AquaticLife.Name);
//}
}
public AquaController(AquaContext context)
{
Context = context;
}
