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(); } }