public static async Task Run()
{
Console.WriteLine("Creating employee target seed....");
using (var context = new AuditorDbContext(ContextProvider.ContextOptions))
{
List <EmployeeTarget> sources = new List <EmployeeTarget>()
{
new EmployeeTarget()
{
SocialSecurityNumber = "01010101",
FirstName = "Kari",
LastName = "Nordman",
Department = "Support"
},
new EmployeeTarget()
{
SocialSecurityNumber = "0101004",
FirstName = "Esther",
LastName = "Doe",
Department = "Support"
},
new EmployeeTarget()
{
SocialSecurityNumber = "01010102",
FirstName = "Nils",
LastName = "Nilsen",
Department = "Sales"
},
};
foreach (var source in sources)
{
var employeeTarget = await context.EmployeeTargets.FirstOrDefaultAsync(x => x.SocialSecurityNumber == source.SocialSecurityNumber);
if (employeeTarget == null)
{
context.EmployeeTargets.Add(source);
}
else
{
employeeTarget.FirstName = source.FirstName;
employeeTarget.LastName = source.LastName;
employeeTarget.Department = source.Department;
context.EmployeeTargets.Update(employeeTarget);
}
}
await context.SaveChangesAsync();
}
}
public static async Task Run()
{
Console.WriteLine("Creating student target seed....");
using (var context = new AuditorDbContext(ContextProvider.ContextOptions))
{
List <StudentTarget> sources = new List <StudentTarget>()
{
new StudentTarget()
{
StudentId = "01010101",
Name = "Kari Nordman",
Course = "Algorithm"
},
new StudentTarget()
{
StudentId = "0101004",
Name = "Esther Doe",
Course = "Data Structure"
},
new StudentTarget()
{
StudentId = "01010102",
Name = "Nils Nilsen",
Course = "Structure Programming Language"
},
};
foreach (var source in sources)
{
var employeeTarget = await context.StudentTargets.FirstOrDefaultAsync(x => x.StudentId == source.StudentId);
if (employeeTarget == null)
{
context.StudentTargets.Add(source);
}
else
{
employeeTarget.Name = source.Name;
employeeTarget.Course = source.Course;
context.StudentTargets.Update(employeeTarget);
}
}
await context.SaveChangesAsync();
}
}
public static async Task Run()
{
Console.WriteLine("Creating student source seed....");
using (var context = new AuditorDbContext(ContextProvider.ContextOptions))
{
List <StudentSource> sources = new List <StudentSource>()
{
new StudentSource()
{
StudentId = "01010101",
Name = "Kari Nordmann",
Course = "C#"
},
new StudentSource()
{
StudentId = "01010102",
Name = "Jack Jackson",
Course = "Javascript"
},
new StudentSource()
{
StudentId = "01010103",
Name = "Nils Nilsen",
Course = "SQL Server"
},
};
foreach (var source in sources)
{
var studentSource = await context.StudentSources.FirstOrDefaultAsync(x => x.StudentId == source.StudentId);
if (studentSource == null)
{
context.StudentSources.Add(source);
}
else
{
studentSource.Name = source.Name;
studentSource.Course = source.Course;
context.StudentSources.Update(studentSource);
}
}
await context.SaveChangesAsync();
}
}
