// Visar upp den första athelten som finns i databasen. public static async Task <Athlete> ShowFirstAthelte() { var cont = new SnowboardAppContext(); var result = await cont.Athletes.FirstAsync <Athlete>(); return(result); }
public static void UpdateMany() { { var context = new SnowboardAppContext(); string contestEventName = "OS"; var contests = _context.Contests.Where(c => c.EventName.StartsWith(contestEventName)).ToList(); contests.ForEach(c => c.StartDate = new DateTime(2018, 04, 11)); contests.ForEach(c => c.EndDate = new DateTime(2018, 04, 12)); _context.SaveChanges(); } }
public static void AddAthleteHomeResort() { var context = new SnowboardAppContext(); AthleteHomeResort athleteHomeResort1 = new AthleteHomeResort() { AthleteId = 1, HomeResortId = 1 }; context.AthleteHomeResort.Add(athleteHomeResort1); context.SaveChanges(); }
public static void AddAthleteToContest() { var context = new SnowboardAppContext(); AthleteContest athleteContest = new AthleteContest { AthleteId = 3, ContestId = 1, }; _context.AthleteContest.Add(athleteContest); _context.SaveChanges(); }
public static void AddHomeResort() { var _context = new SnowboardAppContext(); HomeResort homeResort1 = new HomeResort { Name = "Oslo Tryvann Vinterpark", Country = "Norway", VerticalMeters = 1470 }; _context.HomeResorts.Add(homeResort1); _context.SaveChanges(); }
private static void AddManyToManyObject() { var context = new SnowboardAppContext(); var athlete = new Athlete { FirstName = "Torsten", LastName = "Horgmo", Age = 28, BirthCountry = "Norway", }; var contest = context.Contests.Find(1); context.Add(athlete); context.Add(new AthleteContest { Athlete = athlete, Contest = contest }); context.SaveChanges(); }
public static void AddSnowboard() { var _context = new SnowboardAppContext(); Snowboard snowboard1 = new Snowboard { Brand = "Rome", Name = "Ståle pro", Length = 155, AthelteId = 12, }; _context.Snowboards.Add(snowboard1); _context.SaveChanges(); }
public static void AddAthletes() { var _context = new SnowboardAppContext(); Athlete athlete1 = new Athlete { FirstName = "Ståle", LastName = "Sandbeck", Age = 25, BirthCountry = "Norway" }; Athlete athlete2 = new Athlete { FirstName = "Xavier", LastName = "Delarue", Age = 32, BirthCountry = "France", }; _context.Athletes.AddRange(athlete1, athlete2); _context.SaveChanges(); }
private static void AddSnowboardsToAthelte() { var context = new SnowboardAppContext(); var snowboard = new Snowboard { Brand = "Rome", Length = 150, Name = "SKS", AthelteId = 14 }; context.Add(snowboard); context.SaveChanges(); var snowboard1 = new Snowboard { Brand = "Brädan1337", Length = 1337, Name = "ELIT", AthelteId = 14 }; context.Add(snowboard1); context.SaveChanges(); }
public static void AddContest() { var _context = new SnowboardAppContext(); Contest contest1 = new Contest { StartDate = new DateTime(2018 - 01 - 12), EndDate = new DateTime(2018 - 01 - 16), EventLocation = "Italy", EventName = "Nine Knights", FirstPlace = "Ståle Sandbeck", SecondPlace = "Mark McMorris", ThirdPlace = "Travis Rice" }; _context.Contests.Add(contest1); _context.SaveChanges(); }
public static void FindAthleteContest() { var context = new SnowboardAppContext(); var contests = context.Contests .Include(c => c.Athletes) .ThenInclude(ct => ct.Athlete) .ToList(); foreach (var contest in contests) { Console.WriteLine(contest.EventName); foreach (var athlete in contest.Athletes) { Console.WriteLine(athlete.Athlete.LastName); } } }