public void InsertEntitiesWithOneToManyRelationship(PrincipalEntityByConventionOTM principalEntityByConventionOTM)
{
using (var experimentsDbContext = new ExperimentsDbContext())
{
experimentsDbContext.PrincipalEntityByConventionOTM.AddRange(principalEntityByConventionOTM);
experimentsDbContext.SaveChanges();
}
}
public void UpdateEntitiesWithManyToManyRelationship(MiddleEntityByConventionMTM middleEntityByConventionMTM)
{
using (var experimentsDbContext = new ExperimentsDbContext())
{
experimentsDbContext.MiddleEntityByConventionMTM.UpdateRange(middleEntityByConventionMTM);
experimentsDbContext.SaveChanges();
}
}
public void InsertEntitiesWithOneToOneRelationship(PrincipalEntityByConventionOTO principalEntityByConventionOTO)
{
using (var experimentsDbContext = new ExperimentsDbContext())
{
experimentsDbContext.DependentEntityByConventionOTO.Attach(principalEntityByConventionOTO.DependentEntityByConventionOTO);
experimentsDbContext.PrincipalEntityByConventionOTO.AddRange(principalEntityByConventionOTO);
experimentsDbContext.SaveChanges();
}
}
public void InsertEntitiesWithoutRelationship(PrincipalEntityByConventionMTM principalEntityByConventionMTM,
DependentEntityByConventionMTM dependentEntityByConventionMTM)
{
using (var experimentsDbContext = new ExperimentsDbContext())
{
experimentsDbContext.PrincipalEntityByConventionMTM.AddRange(principalEntityByConventionMTM);
experimentsDbContext.DependentEntityByConventionMTM.AddRange(dependentEntityByConventionMTM);
experimentsDbContext.SaveChanges();
}
}
public void CleanAllRecordsFromPrincipalAndDependentEntitiesByConventionOTM()
{
using (var experimentsDbContext = new ExperimentsDbContext())
{
experimentsDbContext.Database.ExecuteSqlInterpolated($"delete from PrincipalEntityByConventionOTM");
experimentsDbContext.Database.ExecuteSqlInterpolated($"DBCC CHECKIDENT ('PrincipalEntityByConventionOTM', RESEED, 0)");
experimentsDbContext.Database.ExecuteSqlInterpolated($"delete from DependentEntityByConventionOTM");
experimentsDbContext.Database.ExecuteSqlInterpolated($"DBCC CHECKIDENT ('DependentEntityByConventionOTM', RESEED, 0)");
experimentsDbContext.SaveChanges();
}
}
public void InsertEntitiesWithManyToManyRelationship(PrincipalEntityByConventionMTM principalEntityByConventionMTM,
DependentEntityByConventionMTM dependentEntityByConventionMTM)
{
using (var experimentsDbContext = new ExperimentsDbContext())
{
experimentsDbContext.PrincipalEntityByConventionMTM.AddRange(principalEntityByConventionMTM);
experimentsDbContext.DependentEntityByConventionMTM.AddRange(dependentEntityByConventionMTM);
experimentsDbContext.SaveChanges();
var middleEntityByConventionMTM = new MiddleEntityByConventionMTM()
{
PrincipalEntityByConventionMTMId = principalEntityByConventionMTM.Id,
DependentEntityByConventionMTMId = dependentEntityByConventionMTM.Id
};
experimentsDbContext.MiddleEntityByConventionMTM.AddRange(middleEntityByConventionMTM);
experimentsDbContext.SaveChanges();
}
}
