public async Task <IEnumerable <Vehicle> > GetAll()
{
using (var dbContext = new MssqlContext())
{
return(await dbContext.Vehicles.Include(v => v.Owner).ToListAsync());
}
}
public async Task UpdateRange(IEnumerable <Vehicle> vehicles)
{
using (var dbContext = new MssqlContext())
{
foreach (var v in vehicles)
{
dbContext.Entry(v).State = EntityState.Modified;
}
await dbContext.SaveChangesAsync();
}
}
public static void AddSqlStorage(this IServiceCollection services, string connectionString)
{
MssqlContext.ConnectionString = connectionString;
services.AddTransient <IVehiclesRepository, VehiclesRepository>();
using (var context = new MssqlContext())
{
if (!context.Database.EnsureCreated())
{
return;
}
context.Vehicles.AddRange(TestData.GetVehicles());
context.SaveChanges();
}
}
