static void Main()
{
using(var db = new PremierLeagueContext())
{
db.Database.CreateIfNotExists();
//var player = db.Players.FirstOrDefault();
//player.Age = 414;
//db.Entry(player).State = System.Data.Entity.EntityState.Modified;
//db.SaveChanges();
//var newTeam = new Team()
//{
// Name = "Bornemuth",
// Division = "Premier League",
//};
//db.Teams.Add(newTeam);
//db.SaveChanges();
//System.Console.WriteLine(newTeam.DateCreated);
//var refer = new Referee
//{
// Id = 66,
// FullName = string.Empty
//};
//db.Referees.Add(refer);
//db.SaveChanges();
//var users = db.Users.Find(33, "9109184201");
//var players = db.Players.ToList();
//System.Console.WriteLine(users.UserForeignKeys.First().SomeData);
};
}
static void Main()
{
using (var db = new PremierLeagueContext())
{
db.Database.CreateIfNotExists();
//var player = db.Players.FirstOrDefault();
//player.Age = 414;
//db.Entry(player).State = System.Data.Entity.EntityState.Modified;
//db.SaveChanges();
//var newTeam = new Team()
//{
// Name = "Bornemuth",
// Division = "Premier League",
//};
//db.Teams.Add(newTeam);
//db.SaveChanges();
//System.Console.WriteLine(newTeam.DateCreated);
//var refer = new Referee
//{
// Id = 66,
// FullName = string.Empty
//};
//db.Referees.Add(refer);
//db.SaveChanges();
//var users = db.Users.Find(33, "9109184201");
//var players = db.Players.ToList();
//System.Console.WriteLine(users.UserForeignKeys.First().SomeData);
};
}
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();
}
}
static void Main(string[] args)
{
//System.Data.Entity.Database.SetInitializer(new MyInitializer());
using (var db = new PremierLeagueContext())
{
var players = db.Players.ToList();
if(players.Count == 0)
{
System.Console.WriteLine("There are no players in the database");
}
players.ForEach(p => System.Console.WriteLine(p));
}
}
static void Main(string[] args)
{
//System.Data.Entity.Database.SetInitializer(new MyInitializer());
using (var db = new PremierLeagueContext())
{
var players = db.Players.ToList();
if (players.Count == 0)
{
System.Console.WriteLine("There are no players in the database");
}
players.ForEach(p => System.Console.WriteLine(p));
}
}
public PoolRepository(PremierLeagueContext context) : base(context)
{
}
public GameWeekAccess()
{
_context = new PremierLeagueContext();
}
public CoachRepository(PremierLeagueContext dbContext)
{
_dbContext = dbContext;
}
public UnitOfWork(PremierLeagueContext context)
{
this._Context = context;
}
public SeasonAccess()
{
_context = new PremierLeagueContext();
}
public ImageRepository(PremierLeagueContext context) : base(context)
{
}
public TeamRepository(PremierLeagueContext dbContext)
{
_dbContext = dbContext;
}
public PlayerRepository(PremierLeagueContext dbContext)
{
_dbContext = dbContext;
}
public ApplicationUserRepository(PremierLeagueContext context) : base(context)
{
}
public BlogRepository(PremierLeagueContext context) : base(context)
{
}
public GenericRepository(PremierLeagueContext context)
{
this._Context = context;
entities = context.Set <T>();
}
public TeamAccess()
{
_context = new PremierLeagueContext();
}
