public void UpdatingBothEventAndMarketsSimultaneouly() { var context = new SportsbookContext();//_connectionString); var market = context.Set<MarketEntity>() .Include("Event").First(); market.Type = new MarketTypeEntity { Id = 1 }; market.Event.Name = "Modified Event Name"; context.SaveChanges(); }
public void AddMarketToEventWithMarket() { var context = new SportsbookContext();//_connectionString); var matchWinner = new MarketTypeEntity { Name = "Match Winner" }; var eventId = context.Set<MarketEntity>() .Select(m => m.Event.Id) .FirstOrDefault(); var existingEvent = new EventWithMarketEntity { Id = eventId, }; var newMarket = new MarketEntity { Event = existingEvent, Type = matchWinner, }; context.Entry(existingEvent).State = EntityState.Unchanged; context.Entry(newMarket).State = EntityState.Added; context.SaveChanges(); }