private static async Task Main(string[] args)
{
var options = new DbContextOptionsBuilder <SalerDbContext>();
options.UseOracle(GetConnectionString("OraConn"));
await using var context = new SalerDbContext(options.Options);
//await Write(context);
await Read(context);
}
static async Task Write(SalerDbContext context)
{
var r = await context.SalerInfo.AddAsync(new SalerInfo
{
UserName = "******",
});
await context.SalerScore.AddAsync(new SalerScore
{
SalerId = r.Entity.Id,
Score = 10
});
await context.SalerAddress.AddAsync(new SalerAddress
{
SalerId = r.Entity.Id,
Address = "十里铺"
});
await context.SaveChangesAsync();
}
static async Task Read(SalerDbContext context)
{
//await context.SalerInfo.AsNoTracking().ToListAsync().ContinueWith(t => Console.WriteLine(t.Result.Count));
//await context.SalerScore.AsNoTracking().ToListAsync().ContinueWith(t => Console.WriteLine(t.Result.Count));
await context.SalerAddress.AsNoTracking().ToListAsync().ContinueWith(t => t.Result.ForEach(a => Console.WriteLine(a.Address)));
}
public SalerInfoesController(SalerDbContext context)
{
_context = context;
}
