public UserRepository(EFContextMySQL context) { _context = context; }
public AddressRepository(EFContextMySQL context) { _context = context; }
private static void SeedFromMySQL(string options) { var stopWatch = new Stopwatch(); stopWatch.Start(); var optionsBuilder = new DbContextOptionsBuilder <EFContextMySQL>(); optionsBuilder.UseMySql(options); using (var context = new EFContextMySQL(optionsBuilder.Options)) using (var dbContextTransaction = context.Database.BeginTransaction()) { var profession = new Profession { AddedDate = DateTime.Now, Name = "Progammer", Description = "Computer Programmer" }; if (!context.Profession.Any()) { context.Profession.Add(profession); profession = new Profession { AddedDate = DateTime.Now, Name = "Analyst", Description = "Computer Analyst" }; context.Profession.Add(profession); profession = new Profession { AddedDate = DateTime.Now, Name = "Project Manager", Description = "Project Manager" }; context.Profession.Add(profession); } context.SaveChanges(); var user = new User { Name = "Jesús", Surname = "Sánchez Corzo", Username = "******", AddedDate = DateTime.Now, Age = 46, BirthDate = new DateTime(1972, 8, 1), Email = "*****@*****.**", Password = "******", ProfessionId = 1 }; if (!context.User.Any()) { context.User.Add(user); } context.SaveChanges(); if (!context.Address.Any()) { context.Address.Add(new Address { AddedDate = DateTime.Now, UserId = user.Id, Street = "Avda. de las Suertes", Number = 55 }); context.Address.Add(new Address { AddedDate = DateTime.Now, UserId = user.Id, Street = "C/ Dehesa de Vicálvaro", Number = 33 }); } context.SaveChanges(); dbContextTransaction.Commit(); stopWatch.Stop(); var ts = stopWatch.Elapsed; Console.WriteLine(""); Console.WriteLine($"Table User -> {context.User.Count()} rows"); Console.WriteLine($"Table Address -> {context.Address.Count()} rows"); Console.WriteLine($"Table Profession -> {context.Profession.Count()} rows"); Console.WriteLine($"\t{ts.Seconds}.{ts.Milliseconds} sg.ms"); Console.WriteLine(""); } }
public WorkRepository(EFContextMySQL context) { _context = context; }
public ProfessionRepository(EFContextMySQL context) { _context = context; }