public void OneTimeInit()
        {
            this.comparer = new TeamDtoComparer();
            AutoMapperConfiguration.Configure();

            this.databaseSportsContext = new SportsContext("SportsContext");

            // Clear tables
            this.databaseSportsContext.TeamNames.RemoveRange(
                this.databaseSportsContext.TeamNames);
            this.databaseSportsContext.Results.RemoveRange(
                this.databaseSportsContext.Results);
            this.databaseSportsContext.SportEvents.RemoveRange(
                this.databaseSportsContext.SportEvents);
            this.databaseSportsContext.Teams.RemoveRange(
                this.databaseSportsContext.Teams);
            this.databaseSportsContext.SportTypes.RemoveRange(
                this.databaseSportsContext.SportTypes);
            this.databaseSportsContext.SaveChanges();

            this.databaseSportsContext.Database.ExecuteSqlCommand(
                @"SET IDENTITY_INSERT [dbo].[SportTypes] ON;
                INSERT INTO [dbo].[SportTypes] ([Id], [Name])
                VALUES
                (1, 'Football'),
                (2, 'Basketball');               
                SET IDENTITY_INSERT [dbo].[SportTypes] OFF;");

            this.databaseSportsContext.Database.ExecuteSqlCommand(
                @"SET IDENTITY_INSERT [dbo].[Teams] ON;
                INSERT INTO [dbo].[Teams] ([Id], [Name], [SportType_Id])
                VALUES
                (1, 'Manchester United', 1),
                (2, 'Milano', 1),
                (3, 'Manchester City', 1),
                (4, 'Chelsea', 1),
                (5, 'Bayern', 1),
                (6, 'Chicago Bulls', 2),
                (7, 'Los Angeles Lakers', 2),
                (8, 'Phoenix Suns', 2);               
                SET IDENTITY_INSERT [dbo].[Teams] OFF;");

            this.databaseSportsContext.SaveChanges();
            this.teamService = new TeamService(new EFUnitOfWork(this.databaseSportsContext));
        }
예제 #2
0
        public void CheckTeamToTeamDtoMapping()
        {
            List <Team>     teams        = this.teams;
            List <TeamDto>  teamsTestDto = new List <TeamDto>();
            List <TeamDto>  mappedDto    = new List <TeamDto>();
            TeamDtoComparer dtoComparer  = new TeamDtoComparer();

            foreach (Team team in teams)
            {
                teamsTestDto.Add(new TeamDto
                {
                    Name = team.Name,
                    Id   = team.Id
                });
                mappedDto.Add(Mapper.Map <Team, TeamDto>(team));
            }

            CollectionAssert.AreEqual(teamsTestDto, mappedDto, dtoComparer);
        }