public static void Reset()
{
using(SportContext context = new SportContext())
{
context.Database.ExecuteSqlCommand("DELETE FROM Player");
context.Database.ExecuteSqlCommand("DELETE FROM Team");
context.Database.ExecuteSqlCommand("DELETE FROM Sport");
}
}
public long GetTeamsForSport(int sportId)
{
Stopwatch watch = new Stopwatch();
watch.Start();
using (SportContext context = new SportContext())
{
var players = context.Teams.AsNoTracking().Include(x=>x.Players).Where(x => x.SportId == sportId).ToList();
}
watch.Stop();
return watch.ElapsedMilliseconds;
}
public long GetPlayersForTeam(int teamId)
{
Stopwatch watch = new Stopwatch();
watch.Start();
using (SportContext context = new SportContext())
{
var players = context.Players.AsNoTracking().Where(x => x.TeamId == teamId).ToList();
}
watch.Stop();
return watch.ElapsedMilliseconds;
}
public long GetPlayerByID(int id)
{
Stopwatch watch = new Stopwatch();
watch.Start();
using (SportContext context = new SportContext())
{
var player = context.Players.Find(id);
}
watch.Stop();
return watch.ElapsedMilliseconds;
}
public long GetPlayerByID(int id)
{
Stopwatch watch = new Stopwatch();
watch.Start();
using (SportContext context = new SportContext())
{
var player = context.Players.AsNoTracking().Single(x => x.Id == id);
}
watch.Stop();
return watch.ElapsedMilliseconds;
}
public long GetTeamsForSport(int sportId)
{
Stopwatch watch = new Stopwatch();
watch.Start();
using (SportContext context = new SportContext())
{
//var tmpFromSportPlayers = context.Sports
//var tmpPlayers = context.Teams.Where(t => t.SportId == sportId).SelectMany(t => t.Players).ToList();
var players = context.Teams.Include(x=>x.Players).Where(x => x.SportId == sportId).ToList();
}
watch.Stop();
return watch.ElapsedMilliseconds;
}
private static void AddSports(List<SportDTO> sports)
{
using (SportContext context = new SportContext())
{
foreach (var sport in sports)
{
context.Sports.Add(new Sport()
{
Id = sport.Id,
Name = sport.Name
});
}
context.SaveChanges();
}
}
private static void AddTeams(List<TeamDTO> teams)
{
using (SportContext context = new SportContext())
{
foreach (var team in teams)
{
context.Teams.Add(new Team()
{
Name = team.Name,
Id = team.Id,
SportId = team.SportId,
FoundingDate = team.FoundingDate
});
}
context.SaveChanges();
}
}
private static void AddPlayers(List<PlayerDTO> players)
{
using (SportContext context = new SportContext())
{
foreach (var player in players)
{
context.Players.Add(new Player()
{
FirstName = player.FirstName,
LastName = player.LastName,
DateOfBirth = player.DateOfBirth,
TeamId = player.TeamId,
Id = player.Id
});
}
context.SaveChanges();
}
}
public void CreateDatabase()
{
try { SportContext context = new SportContext(); }
catch (Exception ex) { }
}
public EntityFrameworkReusingWithQueryContext()
{
_context = new SportContext();
}
public EntityFrameworkReusingContext()
{
_context = new SportContext();
}