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