static void Main(string[] args)
{
try
{
DataBaseInitializer <MessageContext> .InitializedDatabase();
using (BaseContext context = ContextFactory.Create())
{
IUnitOfWork uow = new EFUnitOfWork(context);
IRepository <User> userRepository = uow.GetRepository <User>();
User user1 = new User()
{
Name = "Berkay"
};
User user2 = new User()
{
Name = "Arda"
};
userRepository.Add(user1);
userRepository.Add(user2);
uow.SaveChanges();
IRepository <Message> msgRepository = uow.GetRepository <Message>();
msgRepository.Add(new Message()
{
FromUser = user1, ToUser = user2, Text = $"Selam. Nasılsın?", CreateDate = DateTime.Now
});
msgRepository.Add(new Message()
{
FromUser = user2, ToUser = user1, Text = $"İyiyim", CreateDate = DateTime.Now
});
uow.SaveChanges();
Console.WriteLine("Tüm mesajlar cekiliyor...");
foreach (var msg in msgRepository.GetAll())
{
Console.WriteLine(msg.ToString());
}
Console.WriteLine("Berkay'ın mesajları çekiliyor");
foreach (var msg in msgRepository.GetAll((m) => m.FromUser.Name == "Berkay"))
{
Console.WriteLine(msg.ToString());
}
InvokeUnitySample();
}
Console.ReadLine();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
public void CreateMessage()
{
//DataBaseInitializer<MessageContext>.InitializedDatabase();
using (BaseContext context = ContextFactory.Create())
{
IUnitOfWork uow = new EFUnitOfWork(context);
IRepositoryGeneric <User> userRepository = uow.GetRepository <User>();//Veri tabanımızı oluşturuyoruz. Varsa default değerleri de insertliyoruz.
User user1 = new User()
{
Name = "Berkay"
};
User user2 = new User()
{
Name = "Arda"
};
userRepository.Add(user1);
userRepository.Add(user2);
uow.SaveChanges();
IRepositoryGeneric <Message> msgRepository = uow.GetRepository <Message>();
msgRepository.Add(new Message()
{
FromUser = user1, ToUser = user2, Text = $"Selam. Nasılsın?", CreateDate = DateTime.Now
});
msgRepository.Add(new Message()
{
FromUser = user2, ToUser = user1, Text = $"İyiyim", CreateDate = DateTime.Now
});
uow.SaveChanges();
Console.WriteLine("Tüm mesajlar cekiliyor...");
foreach (var msg in msgRepository.GetAll())
{
Console.WriteLine(msg.ToString());
System.Diagnostics.Debug.WriteLine(msg.Text.ToString());
HttpContext.Current.Response.Write(msg.Text.ToString());
}
Console.WriteLine("Berkay'ın mesajları çekiliyor");
foreach (var msg in msgRepository.GetAll((m) => m.FromUser.Name == "Berkay"))
{
Console.WriteLine(msg.ToString());
System.Diagnostics.Debug.WriteLine(msg.Text.ToString());
HttpContext.Current.Response.Write(msg.Text.ToString());
}
}
}
public void AddEmloyee()
{
Category employee = new Category
{
CategoryName = "a",
Description = "a"
};
_uow.GetRepository <Category>().CreateOrUptade(employee);
_uow.Save();
var model = _dbContext.Categories.Find(employee.CategoryID);
Assert.IsNotNull(model);
}
public void NullTeamsSportEventsSaving()
{
ResultDTO r1 = new ResultDTO {
TeamName = "Ворскла", IsHome = false, Score = 0
};
ResultDTO r2 = new ResultDTO {
TeamName = "Металлист", IsHome = true, Score = 4
};
SportEventDTO ev = new SportEventDTO
{
Date = DateTime.Now.Ticks, SportType = "Football", Results = new List <ResultDTO> {
r1, r2
}
};
List <SportEventDTO> events = new List <SportEventDTO>();
events.Add(ev);
IUnitOfWork unit = new EFUnitOfWork(this.databaseSportsContext);
this.eventService.SaveSportEvents(events);
Team team1 =
unit.GetRepository <TeamName>().Get(tn => tn.Name == "Металлист").Select(tn => tn.Team).FirstOrDefault();
Assert.IsNotNull(team1);
Team team2 =
unit.GetRepository <TeamName>().Get(tn => tn.Name == "Ворскла").Select(tn => tn.Team).FirstOrDefault();
Assert.IsNotNull(team2);
Result savedResult1 = unit.GetRepository <Result>().Get(r => r.Team.Id == team1.Id).FirstOrDefault();
Assert.IsNotNull(savedResult1);
Result savedResult2 = unit.GetRepository <Result>().Get(r => r.Team.Id == team2.Id).FirstOrDefault();
Assert.IsNotNull(savedResult2);
SportEvent savedEvent1 = unit.GetRepository <Result>()
.Get(filter: r => r.SportEvent.Id == savedResult1.SportEvent.Id)
.Select(r => r.SportEvent).FirstOrDefault();
Assert.IsTrue(savedEvent1.Results.Contains(savedResult2));
IEnumerable <TempResult> tempResults = unit.GetRepository <TempResult>().Get();
Assert.IsEmpty(tempResults);
IEnumerable <TempSportEvent> tempEvents = unit.GetRepository <TempSportEvent>().Get();
Assert.IsEmpty(tempEvents);
IEnumerable <Conformity> conformities = unit.GetRepository <Conformity>().Get();
Assert.IsEmpty(conformities);
}
public void ResolveNamingNeutralTest()
{
IUnitOfWork unit = new EFUnitOfWork(this.databaseSportsContext);
SportType football = new SportType {
Name = "Football"
};
SportType sport = unit.GetRepository <SportType>()
.Get(x => x.Name.ToUpper() == football.Name.ToUpper())
.FirstOrDefault();
Conformity expConf = new Conformity
{
InputName = "Ст. Этьен",
ExistedName = "Сент-Этьен"
};
Team neutralTeam = new Team
{
Name = "Ст. Этьен",
SportType = sport
};
NamingMatcher matcher = new NamingMatcher(unit);
List <Conformity> neutralConformities = matcher.ResolveNaming(neutralTeam);
Conformity newConf = neutralConformities.FirstOrDefault();
Assert.AreEqual(expConf.InputName, newConf.InputName);
Assert.AreEqual(expConf.ExistedName, newConf.ExistedName);
}
public void EFUnitOfWork_GetRepository_Throwsy()
{
//Arrange, Act
var context = new EFUnitOfWork(ConnectionStringName, null, _cache.Object);
//Act, Assert
Assert.Throws <NotImplementedException>(() => context.GetRepository <Dog>());
}
public void OneConformitySportEventsSaving()
{
ResultDTO r1 = new ResultDTO {
TeamName = "Динамо Киев", IsHome = true, Score = 3
};
ResultDTO r2 = new ResultDTO {
TeamName = "Ст. Этьен", IsHome = false, Score = 1
};
SportEventDTO ev = new SportEventDTO
{
Date = DateTime.Now.Ticks, SportType = "Football", Results = new List <ResultDTO> {
r1, r2
}
};
List <SportEventDTO> events = new List <SportEventDTO>();
events.Add(ev);
IUnitOfWork unit = new EFUnitOfWork(this.databaseSportsContext);
this.eventService.SaveSportEvents(events);
Team team1 =
unit.GetRepository <TeamName>()
.Get(tn => tn.Name == "Динамо Киев")
.Select(tn => tn.Team)
.FirstOrDefault();
Assert.IsNotNull(team1);
Team team2 =
unit.GetRepository <TeamName>().Get(tn => tn.Name == "Ст. Этьен").Select(tn => tn.Team).FirstOrDefault();
Assert.IsNull(team2);
IEnumerable <SportEvent> emptyEvents = unit.GetRepository <SportEvent>().Get(e => e.Results.Count() == 0);
Assert.IsTrue(emptyEvents.Count() == 0);
IEnumerable <SportEvent> oneResultEvents = unit.GetRepository <SportEvent>().Get(e => e.Results.Count() == 1);
Assert.IsTrue(oneResultEvents.Count() == 0);
Conformity conf2 = unit.GetRepository <Conformity>().Get(c => c.InputName == "Ст. Этьен").FirstOrDefault();
Assert.IsTrue(conf2.TempResult != null);
Assert.IsTrue(conf2.TempResult.Team == null);
IEnumerable <TempResult> tempResults = unit.GetRepository <TempResult>().Get();
Assert.IsTrue(tempResults.Count() == 2);
TempResult tempResult1 = unit.GetRepository <TempResult>().Get(r => r.Team != null).FirstOrDefault();
Assert.IsTrue(tempResult1.Team.Name == "Динамо Киев");
Assert.IsTrue(conf2.TempResult.TempSportEvent.Id == tempResult1.TempSportEvent.Id);
}
public void EFUnitOfWork_GetRepository_Returns_Repository()
{
//Arrange, Act
var context = new EFUnitOfWork(ConnectionStringName, null, _cache.Object);
//Act
var rep = context.GetRepository <Dog>();
//Assert
Assert.IsInstanceOf <IRepository <Dog> >(rep);
}
public void BothConformitiesSportEventsSaving()
{
ResultDTO r1 = new ResultDTO {
TeamName = "Маккаби Тель-Авив", IsHome = true, Score = 2
};
ResultDTO r2 = new ResultDTO {
TeamName = "Ст. Этьен", IsHome = false, Score = 1
};
SportEventDTO ev = new SportEventDTO
{
Date = DateTime.Now.Ticks, SportType = "Football", Results = new List <ResultDTO> {
r1, r2
}
};
List <SportEventDTO> events = new List <SportEventDTO>();
events.Add(ev);
IUnitOfWork unit = new EFUnitOfWork(this.databaseSportsContext);
this.eventService.SaveSportEvents(events);
Team team1 =
unit.GetRepository <TeamName>()
.Get(tn => tn.Name == "Маккаби Тель-Авив")
.Select(tn => tn.Team)
.FirstOrDefault();
Assert.IsNull(team1);
Team team2 =
unit.GetRepository <TeamName>().Get(tn => tn.Name == "Ст. Этьен").Select(tn => tn.Team).FirstOrDefault();
Assert.IsNull(team2);
IEnumerable <SportEvent> simpleEvents = unit.GetRepository <SportEvent>().Get(e => e.Results.Count() == 0);
Assert.IsTrue(simpleEvents.Count() == 0);
Conformity conf1 =
unit.GetRepository <Conformity>().Get(c => c.InputName == "Маккаби Тель-Авив").FirstOrDefault();
Assert.IsNotNull(conf1);
Conformity conf2 = unit.GetRepository <Conformity>().Get(c => c.InputName == "Ст. Этьен").FirstOrDefault();
Assert.IsNotNull(conf2);
IEnumerable <TempResult> tempResults = unit.GetRepository <TempResult>().Get();
Assert.IsTrue(tempResults.Count() == 2);
IEnumerable <TempSportEvent> tempEvents = unit.GetRepository <TempSportEvent>().Get();
Assert.IsTrue(tempEvents.Count() == 1);
}
public void GetRepository_Returns_Repository()
{
//Arrange
var mockContext = new Mock <FamilyTreeContext>();
var unitOfWork = new EFUnitOfWork(mockContext.Object);
//Act
var rep = unitOfWork.GetRepository <Individual>();
//Assert
Assert.IsInstanceOf <IRepository <Individual> >(rep);
}
public void EF_CanGetRepositoryBackFromUnitOfWork()
{
using (var uow = new EFUnitOfWork(this.AuthenticationProvider, this.MessageProvider, this.EventDispatcher, this.Connection))
{
// For testing purposes, the in-memory Effort database has to be initialized at the beginning of each test
(new MonolithicRepository(uow)).Database.Initialize(true);
var repo = new ProductRepository(uow);
var repoAgain = uow.GetRepository <ProductRepository>();
Assert.IsNotNull(repoAgain);
Assert.AreEqual(typeof(ProductRepository), repoAgain.GetType());
}
}
public void ResolveNamingPositiveTest()
{
IUnitOfWork unit = new EFUnitOfWork(this.databaseSportsContext);
SportType football = new SportType {
Name = "Football"
};
SportType sport = unit.GetRepository <SportType>()
.Get(x => x.Name.ToUpper() == football.Name.ToUpper())
.FirstOrDefault();
Team positiveTeam = new Team
{
Name = "Краснодар ФК",
SportType = sport,
Names = new List <TeamName> {
new TeamName {
Name = "Краснодар ФК"
}
}
};
NamingMatcher matcher = new NamingMatcher(unit);
List <Conformity> positiveConformities = matcher.ResolveNaming(positiveTeam);
Assert.IsNull(positiveConformities);
Team team = unit.GetRepository <Team>()
.Get((x) => x.Names.Select(n => n.Name)
.Contains(positiveTeam.Name))
.FirstOrDefault();
Assert.IsTrue(team.Names.Select(t => t.Name).Contains("Краснодар"));
Assert.IsTrue(team.Names.Select(t => t.Name).Contains("Краснодар ФК"));
}
public void DoubleConformitySportEventsSaving() //multiple conformities with the same inputName
{
ResultDTO r1 = new ResultDTO {
TeamName = "Динамо", IsHome = true, Score = 0
};
ResultDTO r2 = new ResultDTO {
TeamName = "Манчестер Юнайтед", IsHome = false, Score = 1
};
SportEventDTO ev1 = new SportEventDTO
{
Date = DateTime.Now.Ticks, SportType = "Football", Results = new List <ResultDTO> {
r1, r2
}
};
List <SportEventDTO> events = new List <SportEventDTO>();
events.Add(ev1);
IUnitOfWork unit = new EFUnitOfWork(this.databaseSportsContext);
this.eventService.SaveSportEvents(events);
Team team1 =
unit.GetRepository <TeamName>().Get(tn => tn.Name == "Динамо").Select(tn => tn.Team).FirstOrDefault();
Assert.IsNull(team1);
Team team2 =
unit.GetRepository <TeamName>()
.Get(tn => tn.Name == "Манчестер Юнайтед")
.Select(tn => tn.Team)
.FirstOrDefault();
Assert.IsNotNull(team2);
IEnumerable <SportEvent> simpleEvents = unit.GetRepository <SportEvent>().Get(e => e.Results.Count() == 0);
Assert.IsTrue(simpleEvents.Count() == 0);
IEnumerable <Conformity> confs = unit.GetRepository <Conformity>().Get(c => c.InputName == "Динамо");
Assert.IsTrue(confs.Count() == 2);
IEnumerable <TempResult> tempResults = unit.GetRepository <TempResult>().Get();
Assert.IsTrue(tempResults.Count() == 2);
IEnumerable <TempSportEvent> tempEvents = unit.GetRepository <TempSportEvent>().Get();
Assert.IsTrue(tempEvents.Count() == 1);
}
public void OneTimeInit()
{
this.databaseSportsContext = new SportsContext("SportsContext");
//// Other transactions can't update and insert data
//this.databaseTransaction = this.databaseSportsContext
// .Database.BeginTransaction(IsolationLevel.Serializable);
// 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.eventService = new EventsService(new EFUnitOfWork(this.databaseSportsContext));
this.comparer = new ResultDtoComparer();
AutoMapperConfiguration.Configure();
this.databaseSportsContext.Database.ExecuteSqlCommand(
@"SET IDENTITY_INSERT [dbo].[SportTypes] ON;
INSERT INTO [dbo].[SportTypes] ([Id], [Name])
VALUES
(1, 'Football'),
(2, 'Basketball'),
(3, 'Hockey');
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.Database.ExecuteSqlCommand(
@"SET IDENTITY_INSERT [dbo].[TeamNames] ON;
INSERT INTO [dbo].[TeamNames] ([Id], [Name], [Team_Id])
VALUES
(1, 'Manchester United', 1),
(2, 'Milano', 2),
(3, 'Manchester City', 3),
(4, 'Chelsea', 4),
(5, 'Bayern', 5),
(6, 'Chicago Bulls', 6),
(7, 'Los Angeles Lakers', 7),
(8, 'Phoenix Suns', 8);
SET IDENTITY_INSERT [dbo].[TeamNames] OFF;");
this.databaseSportsContext.Database.ExecuteSqlCommand(
@"SET IDENTITY_INSERT [dbo].[SportEvents] ON;
INSERT INTO [dbo].[SportEvents] ([Id], [Date], [SportType_Id])
VALUES
(1, '20161119 17:00', 1),
(2, '20161028 17:00', 1),
(3, '20161017 18:00', 1),
(4, '20161103 16:00', 1),
(5, '20161105 16:00', 2),
(6, '20161129 16:00', 2),
(7, '20161115 16:00', 2);
SET IDENTITY_INSERT [dbo].[SportEvents] OFF;");
this.databaseSportsContext.Database.ExecuteSqlCommand(
@"SET IDENTITY_INSERT [dbo].[Results] ON;
INSERT INTO [dbo].[Results] ([Id], [Score], [SportEvent_Id], [Team_Id])
VALUES
(1, 2, 1, 1),
(2, 1, 2, 2),
(3, 3, 4, 2),
(4, 1, 1, 3),
(5, 0, 3, 3),
(6, 0, 3, 4),
(7, 2, 4, 4),
(8, 4, 2, 5),
(9, 68, 5, 6),
(10, 52, 6, 6),
(11, 65, 5, 7),
(12, 65, 7, 7),
(13, 64, 7, 8),
(14, 52, 6, 8);
SET IDENTITY_INSERT [dbo].[Results] OFF;");
this.databaseSportsContext.SaveChanges();
IUnitOfWork unit = new EFUnitOfWork(this.databaseSportsContext);
TeamName tn1 = new TeamName {
Name = "Шахтер Д"
};
TeamName tn2 = new TeamName {
Name = "Динамо Бухарест"
};
TeamName tn3 = new TeamName {
Name = "Динамо Киев"
};
TeamName tn4 = new TeamName {
Name = "Сент-Этьен"
};
TeamName tn5 = new TeamName {
Name = "Заря ЛГ"
};
TeamName tn6 = new TeamName {
Name = "Манчестер Юнайтед"
};
TeamName tn7 = new TeamName {
Name = "Манчестер С"
};
TeamName tn8 = new TeamName {
Name = "Маккаби Т. А."
};
TeamName tn9 = new TeamName {
Name = "Краснодар"
};
SportType sport = new SportType {
Name = "Football"
};
Team t1 = new Team {
Name = tn1.Name, Names = new List <TeamName> {
tn1
}, SportType = sport
};
Team t2 = new Team {
Name = tn2.Name, Names = new List <TeamName> {
tn2
}, SportType = sport
};
Team t3 = new Team {
Name = tn3.Name, Names = new List <TeamName> {
tn3
}, SportType = sport
};
Team t4 = new Team {
Name = tn4.Name, Names = new List <TeamName> {
tn4
}, SportType = sport
};
Team t5 = new Team {
Name = tn5.Name, Names = new List <TeamName> {
tn5
}, SportType = sport
};
Team t6 = new Team {
Name = tn6.Name, Names = new List <TeamName> {
tn6
}, SportType = sport
};
Team t7 = new Team {
Name = tn7.Name, Names = new List <TeamName> {
tn7
}, SportType = sport
};
Team t8 = new Team {
Name = tn8.Name, Names = new List <TeamName> {
tn8
}, SportType = sport
};
Team t9 = new Team {
Name = tn9.Name, Names = new List <TeamName> {
tn9
}, SportType = sport
};
SportEvent event1 = new SportEvent {
SportType = sport, Date = DateTime.Now
};
SportEvent event2 = new SportEvent {
SportType = sport, Date = DateTime.Now
};
SportEvent event3 = new SportEvent {
SportType = sport, Date = DateTime.Now
};
SportEvent event4 = new SportEvent {
SportType = sport, Date = DateTime.Now
};
SportEvent event5 = new SportEvent {
SportType = sport, Date = DateTime.Now
};
Result result1 = new Result {
SportEvent = event1, Team = t1, IsHome = true, Score = 1
};
Result result2 = new Result {
SportEvent = event1, Team = t2, IsHome = false, Score = 0
};
Result result3 = new Result {
SportEvent = event2, Team = t3, IsHome = true, Score = 1
};
Result result4 = new Result {
SportEvent = event2, Team = t4, IsHome = false, Score = 1
};
Result result5 = new Result {
SportEvent = event3, Team = t5, IsHome = true, Score = 3
};
Result result6 = new Result {
SportEvent = event3, Team = t6, IsHome = false, Score = 2
};
Result result7 = new Result {
SportEvent = event4, Team = t7, IsHome = true, Score = 0
};
Result result8 = new Result {
SportEvent = event4, Team = t8, IsHome = false, Score = 4
};
Result result9 = new Result {
SportEvent = event5, Team = t9, IsHome = false, Score = 0
};
Result result10 = new Result {
SportEvent = event5, Team = t1, IsHome = true, Score = 0
};
unit.GetRepository <Result>().Insert(result1);
unit.GetRepository <Result>().Insert(result2);
unit.GetRepository <Result>().Insert(result3);
unit.GetRepository <Result>().Insert(result4);
unit.GetRepository <Result>().Insert(result5);
unit.GetRepository <Result>().Insert(result6);
unit.GetRepository <Result>().Insert(result7);
unit.GetRepository <Result>().Insert(result8);
unit.GetRepository <Result>().Insert(result9);
unit.GetRepository <Result>().Insert(result10);
unit.SaveChanges();
}
public Student GetStudentById(int id)
{
return(_uow.GetRepository <Student>().Get(e => e.ID == id));
}
public void OneTimeInit()
{
this.databaseSportsContext = new SportsContext("SportsContext");
IUnitOfWork unit = new EFUnitOfWork(this.databaseSportsContext);
// 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();
TeamName tn1 = new TeamName {
Name = "Шахтер Д"
};
TeamName tn2 = new TeamName {
Name = "Динамо Бухарест"
};
TeamName tn3 = new TeamName {
Name = "Динамо Киев"
};
TeamName tn4 = new TeamName {
Name = "Сент-Этьен"
};
TeamName tn5 = new TeamName {
Name = "Заря ЛГ"
};
TeamName tn6 = new TeamName {
Name = "Манчестер Юнайтед"
};
TeamName tn7 = new TeamName {
Name = "Манчестер С"
};
TeamName tn8 = new TeamName {
Name = "Шальке-04"
};
TeamName tn9 = new TeamName {
Name = "Краснодар"
};
SportType sport = new SportType {
Name = "Football"
};
Team t1 = new Team {
Name = tn1.Name, Names = new List <TeamName> {
tn1
}, SportType = sport
};
Team t2 = new Team {
Name = tn2.Name, Names = new List <TeamName> {
tn2
}, SportType = sport
};
Team t3 = new Team {
Name = tn3.Name, Names = new List <TeamName> {
tn3
}, SportType = sport
};
Team t4 = new Team {
Name = tn4.Name, Names = new List <TeamName> {
tn4
}, SportType = sport
};
Team t5 = new Team {
Name = tn5.Name, Names = new List <TeamName> {
tn5
}, SportType = sport
};
Team t6 = new Team {
Name = tn6.Name, Names = new List <TeamName> {
tn6
}, SportType = sport
};
Team t7 = new Team {
Name = tn7.Name, Names = new List <TeamName> {
tn7
}, SportType = sport
};
Team t8 = new Team {
Name = tn8.Name, Names = new List <TeamName> {
tn8
}, SportType = sport
};
Team t9 = new Team {
Name = tn9.Name, Names = new List <TeamName> {
tn9
}, SportType = sport
};
SportEvent event1 = new SportEvent {
SportType = sport, Date = DateTime.Now
};
SportEvent event2 = new SportEvent {
SportType = sport, Date = DateTime.Now
};
SportEvent event3 = new SportEvent {
SportType = sport, Date = DateTime.Now
};
SportEvent event4 = new SportEvent {
SportType = sport, Date = DateTime.Now
};
SportEvent event5 = new SportEvent {
SportType = sport, Date = DateTime.Now
};
Result result1 = new Result {
SportEvent = event1, Team = t1, IsHome = true, Score = 1
};
Result result2 = new Result {
SportEvent = event1, Team = t2, IsHome = false, Score = 0
};
Result result3 = new Result {
SportEvent = event2, Team = t3, IsHome = true, Score = 1
};
Result result4 = new Result {
SportEvent = event2, Team = t4, IsHome = false, Score = 1
};
Result result5 = new Result {
SportEvent = event3, Team = t5, IsHome = true, Score = 3
};
Result result6 = new Result {
SportEvent = event3, Team = t6, IsHome = false, Score = 2
};
Result result7 = new Result {
SportEvent = event4, Team = t7, IsHome = true, Score = 0
};
Result result8 = new Result {
SportEvent = event4, Team = t8, IsHome = false, Score = 4
};
Result result9 = new Result {
SportEvent = event5, Team = t9, IsHome = false, Score = 0
};
Result result10 = new Result {
SportEvent = event5, Team = t1, IsHome = true, Score = 0
};
unit.GetRepository <Result>().Insert(result1);
unit.GetRepository <Result>().Insert(result2);
unit.GetRepository <Result>().Insert(result3);
unit.GetRepository <Result>().Insert(result4);
unit.GetRepository <Result>().Insert(result5);
unit.GetRepository <Result>().Insert(result6);
unit.GetRepository <Result>().Insert(result7);
unit.GetRepository <Result>().Insert(result8);
unit.GetRepository <Result>().Insert(result9);
unit.GetRepository <Result>().Insert(result10);
unit.SaveChanges();
}
