public async Task Entity_InMemory_BreakForeignKey() { var options = new DbContextOptionsBuilder <SportsDbContext>() .UseInMemoryDatabase(databaseName: "test1") .Options; using (var context = new SportsDbContext(options)) { context.Leagues.Add(LeagueFactory.NewLeague(1)); context.Leagues.Add(LeagueFactory.NewLeague(2)); context.SaveChanges(); } using (var context = new SportsDbContext(options)) { var result = await context.Leagues .Include(x => x.Conferences) .Include(x => x.Divisions) .Include(x => x.Teams) .Include(x => x.Seasons).ThenInclude(x => x.TeamMaps).ToListAsync(); //should be able to get the team maps with the navigation properties Console.WriteLine(result[0].Seasons[0].TeamMaps[0]); } }
protected override CreateLeagueCommand CreateCommand() { var regionmodel = Region.Create("region", "www.test.com"); var model = LeagueFactory.GetModel(20, "LSTN", "LeagueFullTestName", "https://www.flagTest.png", regionmodel); return(new CreateLeagueCommand(model)); }
public LeagueService(IActionHandler handler, ILeagueRepository leagueRepository, LeagueDTOMapper leagueMapper, LeagueFactory leagueFactory, ITelemetryEventService telemetry) : base(handler) { _leagueRepository = leagueRepository; _leagueMapper = leagueMapper; _leagueFactory = leagueFactory; _telemetry = telemetry; }
public FakeFantasyCriticRepo(FakeFantasyCriticUserStore userStore, FakeMasterGameRepo fakeMasterGameRepo) { _userStore = userStore; _fakeMasterGameRepo = fakeMasterGameRepo; _leagues = LeagueFactory.GetLeagues(); _leagueYears = LeagueFactory.GetLeagueYears(); _usersInLeagues = LeagueFactory.GetUsersInLeagues(); _publishers = PublisherFactory.GetPublishers(); _publisherGames = PublisherFactory.GetPublisherGames(); }
public static IEnumerable <TestCaseData> AddSeason_TestCases() { string s = "{m}_"; var league1 = LeagueFactory.NBA(1); var other1 = LeagueFactory.NHL(2); yield return(new TestCaseData(league1, Season.New(league1, 1, NewRange(1))).SetName(s + "Valid").Returns(true)); yield return(new TestCaseData(league1, Season.New(other1, 2, NewRange(4))).SetName(s + "WrongLeague").Returns(false)); yield return(new TestCaseData(league1, Season.New(league1, 3, NewRange(1))).SetName(s + "OverlapRange").Returns(false)); }
public static IEnumerable <TestCaseData> AddTeam_TestCases() { string s = "{m}_"; var league1 = LeagueFactory.NBA(1); var other1 = LeagueFactory.NHL(2); yield return(new TestCaseData(league1, Team.New(league1, 1, "a", "b")).SetName(s + "Valid").Returns(true)); yield return(new TestCaseData(league1, Team.New(league1, 2, "a", "b1")).SetName(s + "NameNotUnique").Returns(false)); yield return(new TestCaseData(league1, Team.New(league1, 3, "a1", "b")).SetName(s + "AbbrNotUnique").Returns(false)); yield return(new TestCaseData(league1, Team.New(other1, 4, "a2", "b2")).SetName(s + "WrongLeague").Returns(false)); }
public void Given_Retrieve_When_PassedValidQuery_Then_Should_ReturnAllLeagues() { var region = Region.Create("regiontest", "www.test.ro"); var leagues = LeagueFactory.GetEntity(20, "LSTN", "LeagueFullTestName", "https://www.flagTest.png", region).ToQueryableCollection(); RepositoryMock.Setup(r => r.GetAll()).Returns(leagues); var models = LeagueFactory.GetModel(leagues.First()).ToReadOnlyCollection(); MapperMock.Setup(m => m.Map <IReadOnlyCollection <LeagueModel> >(leagues)).Returns(models); var result = ExecuteQuery(); result.Should().NotBeNull(); result.Leagues.Should().NotBeNull(); }
public async Task Entity_SqlLite_ForeignKey() { var options = new DbContextOptionsBuilder <SportsDbContext>() .UseInMemoryDatabase(databaseName: "test2") .Options; using (var context = new SportsDbContext(options)) { context.Leagues.Add(LeagueFactory.NewLeague(1)); context.SaveChanges(); } //change the team using (var context = new SportsDbContext(options)) { var league = await context.Leagues.Include(x => x.Teams).FirstAsync(); context.Update(league); league.Teams.First().Name = "abc"; league.Teams.Add(new TeamDao() { Name = "zz" }); context.SaveChanges(); var league2 = await context.Leagues.Include(x => x.Teams).FirstAsync(); //league.Teams.Firs //var result = await context.Leagues // .Include(x => x.Conferences) // .Include(x => x.Divisions) // .Include(x => x.Teams) // .Include(x => x.Seasons).ThenInclude(x => x.TeamMaps).ToListAsync(); //should be able to get the team maps with the navigation properties Console.WriteLine("done"); } }