public void RunSolutions()
{
using (AdultContext ctx = new AdultContext())
{
HowManyAdultsHaveBlackHair(ctx);
}
}
public async Task UpdateAdultsAsync(Adult person)
{
AdultContext dbContext = new AdultContext();
dbContext.Update(person);
await dbContext.SaveChangesAsync();
}
private void HowManyAdultsHaveBlackHair(AdultContext ctx)
{
var result = ctx.Adults.
Where(adult =>
adult.HairColor.Equals("Black")).
ToList();
Console.WriteLine(result.Count);
}
private static void AddUsers(IList <User> users)
{
foreach (User user in users)
{
using (AdultContext fctxt = new AdultContext())
{
Console.WriteLine(user.ToString());
fctxt.Users.AddAsync(user);
fctxt.Entry(user).State = EntityState.Added;
//fctxt.Entry(user).State = EntityState.Detached;
fctxt.SaveChangesAsync();
}
}
}
private static void AddAdults(IList <Adult> adults)
{
foreach (Adult adult in adults)
{
using (AdultContext fctxt = new AdultContext())
{
Console.WriteLine(adult.ToString());
fctxt.Adults.AddAsync(adult);
fctxt.Entry(adult).State = EntityState.Added;
//fctxt.Entry(adult).State = EntityState.Detached;
fctxt.SaveChangesAsync();
}
}
}
public static void Main(string[] args)
{
using (AdultContext adultContext = new AdultContext())
{
//adultContext.RemoveRange(adultContext.Adults);
//adultContext.SaveChanges();
if (!adultContext.Adults.Any())
{
Seed();
}
}
using (AdultContext userContext = new AdultContext())
{
//adultContext.RemoveRange(adultContext.Adults);
//adultContext.SaveChanges();
if (!userContext.Users.Any())
{
SeedUsers();
}
}
CreateHostBuilder(args).Build().Run();
}
public AdultsController(AdultContext context, DatabaseActions databaseActions)
{
_context = context;
dbAction = databaseActions;
}
public AdultService()
{
ctx = new AdultContext();
adults = ctx.Adult.ToList();
}
public AdultsController(AdultContext context)
{
_context = context;
}
public SqLiteGetFamilies(AdultContext ctx)
{
this.ctx = ctx;
}
public SqliteAdultService(AdultContext ctx)
{
this.ctx = ctx;
}
public UserDbService(AdultContext context)
{
ctx = context;
}
public SqlLiteUserService(AdultContext ctx)
{
this.ctx = ctx;
}
public InMemoryUserService(AdultContext ctx)
{
this.ctx = ctx;
}
public AdultDbService(AdultContext adultContext)
{
cxt = adultContext;
}
