public void AlreadyExistingEntityWithDbGeneratedKeyShouldNotBeInserted()
{
using (var db = new DbGeneratedTeamContext())
{
var team1 = new DM.Teams.UsingDbGeneratedGuidKeys.Team
{
Name = "Team #1",
};
db.BulkInsertAll(new BulkInsertRequest <DM.Teams.UsingDbGeneratedGuidKeys.Team>
{
Entities = new[] { team1 }.ToList()
});
Assert.AreEqual(1, db.Teams.Count());
db.BulkInsertAll(new BulkInsertRequest <DM.Teams.UsingDbGeneratedGuidKeys.Team>
{
Entities = new[] { team1 }.ToList()
});
Assert.AreEqual(1, db.Teams.Count());
}
}
public void SelectNotExistingFromTableWithDbGeneratedGuidAsPrimaryKeyShouldWork()
{
using (var db = new DbGeneratedTeamContext())
{
var teams = new List <DM.Teams.UsingDbGeneratedGuidKeys.Team>();
for (int i = 0; i < 10; i++)
{
teams.Add(new DM.Teams.UsingDbGeneratedGuidKeys.Team {
Name = $"Team #{i}"
});
}
db.BulkInsertAll(new BulkInsertRequest <DM.Teams.UsingDbGeneratedGuidKeys.Team>
{
Entities = teams
});
for (int i = 10; i < 20; i++)
{
teams.Add(new DM.Teams.UsingDbGeneratedGuidKeys.Team {
Name = $"Team #{i}"
});
}
var existingTeams = db.BulkSelectNotExisting <DM.Teams.UsingDbGeneratedGuidKeys.Team, DM.Teams.UsingDbGeneratedGuidKeys.Team>(new BulkSelectRequest <DM.Teams.UsingDbGeneratedGuidKeys.Team>(new [] { "Id" }, teams));
Assert.AreEqual(10, existingTeams.Count);
for (int i = 0; i < 10; i++)
{
Assert.AreEqual(teams[i + 10].Id, existingTeams[i].Id);
Assert.AreEqual(teams[i + 10].Name, existingTeams[i].Name);
}
}
}
protected void CleanupTeamContext()
{
var db1 = new UserGeneratedTeamContext();
db1.Database.ExecuteSqlCommand(@"DELETE FROM [dbo].[Player]");
db1.Database.ExecuteSqlCommand(@"DELETE FROM [dbo].[Coach]");
db1.Database.ExecuteSqlCommand(@"DELETE FROM [dbo].[Team]");
db1.Database.ExecuteSqlCommand(@"DELETE FROM [dbo].[CoachTeams]");
var db2 = new DbGeneratedTeamContext();
db2.Database.ExecuteSqlCommand(@"DELETE FROM [dbo].[Player]");
db2.Database.ExecuteSqlCommand(@"DELETE FROM [dbo].[Coach]");
db2.Database.ExecuteSqlCommand(@"DELETE FROM [dbo].[Team]");
db2.Database.ExecuteSqlCommand(@"DELETE FROM [dbo].[CoachTeams]");
}
public void SelectNotExistingFromTableWithDbGeneratedGuidAsPrimaryKeyShouldWork()
{
using (var db = new DbGeneratedTeamContext())
{
var teams = new List <DM.Teams.UsingDbGeneratedGuidKeys.Team>();
// Add ten teams to the database (Team 0 - Team 9)
for (int i = 0; i < 10; i++)
{
teams.Add(new DM.Teams.UsingDbGeneratedGuidKeys.Team {
Name = $"Team #{i}"
});
}
// Save the ten first teams to the database.
db.BulkInsertAll(new BulkInsertRequest <DM.Teams.UsingDbGeneratedGuidKeys.Team>
{
Entities = teams
});
// Add another ten teams (Team 10 - Team 19) to
// the list but not to the database.
for (int i = 10; i < 20; i++)
{
teams.Add(new DM.Teams.UsingDbGeneratedGuidKeys.Team {
Name = $"Team #{i}"
});
}
// The only teams we should get back out of the 20 teams (Team 0 - Team 19)
// are the last ten that we did not save to the database.
var existingTeams = db.BulkSelectNotExisting <DM.Teams.UsingDbGeneratedGuidKeys.Team, DM.Teams.UsingDbGeneratedGuidKeys.Team>(new BulkSelectRequest <DM.Teams.UsingDbGeneratedGuidKeys.Team>(new[] { "Id" }, teams));
Assert.AreEqual(10, existingTeams.Count);
for (int i = 0; i < 10; i++)
{
Assert.AreEqual(teams[i + 10].Id, existingTeams[i].Id);
Assert.AreEqual(teams[i + 10].Name, existingTeams[i].Name);
}
}
}
