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(); }