public void GetOneToManyData()
{
using (var context = new OneToManyDbContext())
{
var tents = context.Tenants
.Include(t => t.Currencies)
.Include(t => t.BaseCurrency)
.ToList();
}
}
public void UpdateRelatedData()
{
using (var context = new OneToManyDbContext())
{
var tenat = context.Tenants
.Include(t => t.Currencies)
.Include(t => t.BaseCurrency)
.First();
// https://docs.microsoft.com/en-us/ef/core/saving/related-data
tenat.BaseCurrency = context.Currencies.Single(i => i.Id == 2);
context.SaveChanges();
}
}
public async Task <OneToMany.User> LoadUsers([FromServices] OneToManyDbContext dbContext)
{
var user1 = new OneToMany.User();
var user2 = new OneToMany.User();
var role1 = new OneToMany.Role();
role1.Users.Add(user1);
role1.Users.Add(user2);
await dbContext.Set <OneToMany.Role>().AddAsync(role1);
await dbContext.SaveChangesAsync();
return(await dbContext.Set <OneToMany.User>()
.Include(u => u.Role)
.ThenInclude(r => r.Users)
.FirstAsync());
}
