static void Add()
{
using (SoccerContext db = new SoccerContext())
{
// создание и добавление моделей
Team t1 = new Team {
Name = "Барселона"
};
Team t2 = new Team {
Name = "Реал Мадрид"
};
db.Teams.Add(t1);
db.Teams.Add(t2);
db.SaveChanges();
Player pl1 = new Player {
Name = "Роналду", Age = 31, Position = "Нападающий", Team = t2
};
Player pl2 = new Player {
Name = "Месси", Age = 28, Position = "Нападающий", Team = t1
};
Player pl3 = new Player {
Name = "Хави", Age = 34, Position = "Полузащитник", Team = t1
};
db.Players.AddRange(new List <Player> {
pl1, pl2, pl3
});
db.SaveChanges();
// вывод
foreach (Player pl in db.Players.Include("Team"))
{
Console.WriteLine("{0} - {1}", pl.Name, pl.Team != null ? pl.Team.Name : "");
}
Console.WriteLine();
foreach (Team t in db.Teams)
{
Console.WriteLine("Команда: {0}", t.Name);
foreach (Player pl in t.Players)
{
Console.WriteLine("{0} - {1}", pl.Name, pl.Position);
}
Console.WriteLine();
}
}
}
static void Add()
{
using (SoccerContext db = new SoccerContext())
{
// создание и добавление моделей
Team t1 = new Team {
Name = "Basr"
};
Team t2 = new Team {
Name = "Real"
};
db.Teams.Add(t1);
db.Teams.Add(t2);
db.SaveChanges();
Player pl1 = new Player {
Name = "Ronal", Age = 31, Position = "Forward", Team = t2
};
Player pl2 = new Player {
Name = "Messi", Age = 28, Position = "Forward", Team = t1
};
Player pl3 = new Player {
Name = "Havi", Age = 34, Position = "Defence", Team = t1
};
db.Players.AddRange(new List <Player> {
pl1, pl2, pl3
});
db.SaveChanges();
// вывод
foreach (Player pl in db.Players)
{
Console.WriteLine("{0} - {1}", pl.Name, pl.Team != null ? pl.Team.Name : "");
}
Console.WriteLine();
foreach (Team t in db.Teams)
{
Console.WriteLine("Team: {0}", t.Name);
foreach (Player pl in t.Players)
{
Console.WriteLine("{0} - {1}", pl.Name, pl.Position);
}
Console.WriteLine();
}
}
}
static void Delete()
{
using (SoccerContext db = new SoccerContext())
{
db.Database.ExecuteSqlCommand("ALTER TABLE dbo.Players ADD CONSTRAINT Players_Teams FOREIGN KEY (TeamId) REFERENCES dbo.Teams (Id) ON DELETE SET NULL");
//удаление игрока
Player pl_toDelete = db.Players.First(p => p.Name == "Роналду");
db.Players.Remove(pl_toDelete);
// удаление команды
Team t_toDelete = db.Teams.First();
db.Teams.Remove(t_toDelete);
db.SaveChanges();
}
}
static void Change()
{
using (SoccerContext db = new SoccerContext())
{
Player player = db.Players.Where(p => p.Name == "Месси").FirstOrDefault <Player>();
player.Name = "Месси №1";
db.SaveChanges();
foreach (Team t in db.Teams.Include("Players"))
{
Console.WriteLine("Команда: {0}", t.Name);
foreach (Player pl in t.Players)
{
Console.WriteLine("{0} - {1}", pl.Name, pl.Position);
}
Console.WriteLine();
}
}
}
static void Change()
{
using (SoccerContext db = new SoccerContext())
{
Player player = db.Players.Where(p => p.Name == "Месси").First <Player>();
Team team = db.Teams.Where(p => p.Name == "Барселона").First <Team>();
team.Players.Remove(player);
db.SaveChanges();
foreach (Team t in db.Teams.Include("Players"))
{
Console.WriteLine("Команда: {0}", t.Name);
foreach (Player pl in t.Players)
{
Console.WriteLine("{0} - {1}", pl.Name, pl.Position);
}
Console.WriteLine();
}
}
}
