public static async Task SaveChangesWithIdentityInsertAsync <T>([NotNull] this BackendDBContext context)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
await using var transaction = await context.Database.BeginTransactionAsync();
await context.EnableIdentityInsertAsync <T>();
await context.SaveChangesAsync();
await context.EnableIdentityInsertAsync <T>();
await transaction.CommitAsync();
}
public static async Task SaveChangesWithoutIdentityInsertAsync <T>([NotNull] this BackendDBContext context)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
await using var transaction = await context.Database.BeginTransactionAsync();
await context.EnableIdentityInsertAsync <T>();
try
{
await context.SaveChangesAsync();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
await context.EnableIdentityInsertAsync <T>();
await transaction.CommitAsync();
}