public void AddNewSeason(CoreNewSeason season)
{
_context.DbSeasons.Add(new DbSeason {
EndYear = season.EndYear, StartYear = season.StartYear
});
_context.SaveChanges();
}
public void AddTeam(CoreNewTeam coreNewTeam)
{
var dbTeam = new DbTeam()
{
Name = coreNewTeam.TeamName
};
_context.DbTeams.Add(dbTeam);
_context.SaveChanges();
}
static void Main(string[] args)
{
using (var context = new PremierLeagueContext())
{
context.Database.CreateIfNotExists();
var firstPlayer = context.Players.FirstOrDefault(); //get only the columns(properties) from the player class
//var firstPlayerWithPhoto = context.Players.Include(p => p.Photo).FirstOrDefault(); //get the player and playerPhoto columns
//var playerAddress = new PlayerAddress { City = "Varna" };
//var player = new Player
//{
// FirstName = "Ivan",
// LastName = "Ivanov",
// Age = 34,
// Address = playerAddress,
// Photo = new PlayerPhoto() { Photo = new byte[4] {1,2,3,4}, FileName = "aaa.txt" }
//};
//context.Players.Add(player);
//var referee = new Referee
//{
// EGN = "3274723428",
// FirstName = "Howard",
// FamilyName = "Webb",
// RedCardsShowed = 65,
// YellowCardsShowed = 150,
//};
//context.Referees.Add(referee);
context.SaveChanges();
}
}
static void Main(string[] args)
{
using(var context = new PremierLeagueContext())
{
context.Database.CreateIfNotExists();
context.SaveChanges();
}
}
static void Main(string[] args)
{
using (var context = new PremierLeagueContext())
{
context.Database.CreateIfNotExists();
context.SaveChanges();
}
}
public void Save()
{
_Context.SaveChanges();
}
public void Add(Coach entity)
{
_dbContext.Set <Coach>().Add(entity);
_dbContext.SaveChanges();
}
public void Add(Team entity)
{
_dbContext.Set <Team>().Add(entity);
_dbContext.SaveChanges();
}
public void Add(Player entity)
{
_dbContext.Set <Player>().Add(entity);
_dbContext.SaveChanges();
}