public void Initialize()
{
var db1Adapter = new DB1Adapter();
db1Adapter.ExecuteSqlCommand("delete from [Student]");
db1Adapter.ExecuteSqlCommand("delete from [Group]");
var db2Adapter = new DB2Adapter();
db2Adapter.ExecuteSqlCommand("delete from [Event]");
}
public void Initialize()
{
var db1Adapter = new DB1Adapter();
db1Adapter.ExecuteSqlCommand("delete from [Student]");
db1Adapter.ExecuteSqlCommand("delete from [Group]");
var db2Adapter = new DB2Adapter();
db2Adapter.ExecuteSqlCommand("delete from [Event]");
}
public void GetStudentsCountForGroupFromEvent()
{
#region Mock.DB_1_Entities.Groups Initialize
var group1 = new Mock.DB1_Context.Group()
{
Id = Guid.NewGuid(),
Name = "Group1"
};
var group2 = new Mock.DB1_Context.Group()
{
Id = Guid.NewGuid(),
Name = "Group2"
};
#endregion
#region Mock.DB_1_Entities.Students Initialize
var student1 = new Mock.DB1_Context.Student()
{
Id = Guid.NewGuid(),
Name = "Student1",
Group = group1
};
var student2 = new Mock.DB1_Context.Student()
{
Id = Guid.NewGuid(),
Name = "Student2",
Group = group1
};
var student3 = new Mock.DB1_Context.Student()
{
Id = Guid.NewGuid(),
Name = "Student3",
Group = group2
};
#endregion
var db1Adapter = new DB1Adapter();
db1Adapter.AddEntity<Group>(group1);
db1Adapter.AddEntity<Group>(group2);
db1Adapter.AddEntity<Student>(student1);
db1Adapter.AddEntity<Student>(student2);
db1Adapter.AddEntity<Student>(student3);
db1Adapter.SaveChanges();
#region Mock.DB_2_Entities.Events Initialize
var event1 = new Mock.DB2_Context.Event()
{
Id = Guid.NewGuid(),
Name = "eventForGroup1",
GroupName = group1.Name
};
var event2 = new Mock.DB2_Context.Event()
{
Id = Guid.NewGuid(),
Name = "eventForGroup2",
GroupName = group2.Name
};
#endregion
var db2Adapter = new DB2Adapter();
db2Adapter.AddEntity<Event>(event1);
db2Adapter.AddEntity<Event>(event2);
db2Adapter.SaveChanges();
var cqContext = new CQContext(null, db1Adapter, db2Adapter);
var result = cqContext.GetEntities<Mock.DomainModel.Event>().Where(e => e.ID == event1.Id).SelectMany(e => e.Group.Students).Count();
Assert.AreEqual(2, result);
}
public void GetEventByGroupID_GroupFromDB1_EventFromDB2()
{
#region Mock.DB_1_Entities.Groups Initialize
var group1 = new Mock.DB1_Context.Group()
{
Id = Guid.NewGuid(),
Name = "Group1"
};
var group2 = new Mock.DB1_Context.Group()
{
Id = Guid.NewGuid(),
Name = "Group2"
};
#endregion
var db1Adapter = new DB1Adapter();
db1Adapter.AddEntity<Group>(group1);
db1Adapter.AddEntity<Group>(group2);
db1Adapter.SaveChanges();
#region Mock.DB_2_Entities.Events Initialize
var event1 = new Mock.DB2_Context.Event()
{
Id = Guid.NewGuid(),
Name = "eventForGroup1",
GroupName = group1.Name
};
var event2 = new Mock.DB2_Context.Event()
{
Id = Guid.NewGuid(),
Name = "eventForGroup2",
GroupName = group2.Name
};
#endregion
var db2Adapter = new DB2Adapter();
db2Adapter.AddEntity<Event>(event1);
db2Adapter.AddEntity<Event>(event2);
db2Adapter.SaveChanges();
var mapper = new Mapper.Mapper();
mapper.CreateConfiguration<Mock.DB1_Context.Group, Mock.DomainModel.Group>()
.AddMap(s => s.Id, d => d.ID)
.AddMap(s => s.Name, d => d.Name);
mapper.CreateConfiguration<Mock.DB2_Context.Event, Mock.DomainModel.Event>()
.AddMap(s => s.Id, d => d.ID)
.AddMap(s => s.Name, d => d.Name);
var cqContext = new CQContext(mapper, db1Adapter, db2Adapter);
var result = cqContext.GetEntities<Mock.DomainModel.Event>().FirstOrDefault(e => e.Group.ID == group1.Id);
Assert.IsNotNull(result, "Event not found");
Assert.AreEqual(event1.Id, result.ID, "Wrong event");
}
public void GetStudentsCountForGroupFromEvent()
{
#region Mock.DB_1_Entities.Groups Initialize
var group1 = new Mock.DB1_Context.Group()
{
Id = Guid.NewGuid(),
Name = "Group1"
};
var group2 = new Mock.DB1_Context.Group()
{
Id = Guid.NewGuid(),
Name = "Group2"
};
#endregion
#region Mock.DB_1_Entities.Students Initialize
var student1 = new Mock.DB1_Context.Student()
{
Id = Guid.NewGuid(),
Name = "Student1",
Group = group1
};
var student2 = new Mock.DB1_Context.Student()
{
Id = Guid.NewGuid(),
Name = "Student2",
Group = group1
};
var student3 = new Mock.DB1_Context.Student()
{
Id = Guid.NewGuid(),
Name = "Student3",
Group = group2
};
#endregion
var db1Adapter = new DB1Adapter();
db1Adapter.AddEntity <Group>(group1);
db1Adapter.AddEntity <Group>(group2);
db1Adapter.AddEntity <Student>(student1);
db1Adapter.AddEntity <Student>(student2);
db1Adapter.AddEntity <Student>(student3);
db1Adapter.SaveChanges();
#region Mock.DB_2_Entities.Events Initialize
var event1 = new Mock.DB2_Context.Event()
{
Id = Guid.NewGuid(),
Name = "eventForGroup1",
GroupName = group1.Name
};
var event2 = new Mock.DB2_Context.Event()
{
Id = Guid.NewGuid(),
Name = "eventForGroup2",
GroupName = group2.Name
};
#endregion
var db2Adapter = new DB2Adapter();
db2Adapter.AddEntity <Event>(event1);
db2Adapter.AddEntity <Event>(event2);
db2Adapter.SaveChanges();
var cqContext = new CQContext(null, db1Adapter, db2Adapter);
var result = cqContext.GetEntities <Mock.DomainModel.Event>().Where(e => e.ID == event1.Id).SelectMany(e => e.Group.Students).Count();
Assert.AreEqual(2, result);
}
public void GetEventByGroupID_GroupFromDB1_EventFromDB2()
{
#region Mock.DB_1_Entities.Groups Initialize
var group1 = new Mock.DB1_Context.Group()
{
Id = Guid.NewGuid(),
Name = "Group1"
};
var group2 = new Mock.DB1_Context.Group()
{
Id = Guid.NewGuid(),
Name = "Group2"
};
#endregion
var db1Adapter = new DB1Adapter();
db1Adapter.AddEntity <Group>(group1);
db1Adapter.AddEntity <Group>(group2);
db1Adapter.SaveChanges();
#region Mock.DB_2_Entities.Events Initialize
var event1 = new Mock.DB2_Context.Event()
{
Id = Guid.NewGuid(),
Name = "eventForGroup1",
GroupName = group1.Name
};
var event2 = new Mock.DB2_Context.Event()
{
Id = Guid.NewGuid(),
Name = "eventForGroup2",
GroupName = group2.Name
};
#endregion
var db2Adapter = new DB2Adapter();
db2Adapter.AddEntity <Event>(event1);
db2Adapter.AddEntity <Event>(event2);
db2Adapter.SaveChanges();
var mapper = new Mapper.Mapper();
mapper.CreateConfiguration <Mock.DB1_Context.Group, Mock.DomainModel.Group>()
.AddMap(s => s.Id, d => d.ID)
.AddMap(s => s.Name, d => d.Name);
mapper.CreateConfiguration <Mock.DB2_Context.Event, Mock.DomainModel.Event>()
.AddMap(s => s.Id, d => d.ID)
.AddMap(s => s.Name, d => d.Name);
var cqContext = new CQContext(mapper, db1Adapter, db2Adapter);
var result = cqContext.GetEntities <Mock.DomainModel.Event>().FirstOrDefault(e => e.Group.ID == group1.Id);
Assert.IsNotNull(result, "Event not found");
Assert.AreEqual(event1.Id, result.ID, "Wrong event");
}
