异步保存到单个SQL Server数据库中的多个表

using System;
using System.Threading.Tasks;
using Microsoft.EntityFrameworkCore;

public class MyDbContext : DbContext
{
    public DbSet<User> Users { get; set; }
    public DbSet<Order> Orders { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("YourConnectionStringHere");
    }
}

public class User
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public class Order
{
    public int Id { get; set; }
    public int UserId { get; set; }
    public DateTime OrderDate { get; set; }
}

public class Program
{
    public static async Task Main(string[] args)
    {
        using (var context = new MyDbContext())
        {
            var user = new User { Name = "John Doe" };
            var order = new Order { UserId = 1, OrderDate = DateTime.Now };

            context.Users.Add(user);
            context.Orders.Add(order);

            await context.SaveChangesAsync();
        }
    }
}

public static async Task SaveDataWithRetry(DbContext context, int maxRetries = 3)
{
    for (int attempt = 0; attempt < maxRetries; attempt++)
    {
        try
        {
            await context.SaveChangesAsync();
            break;
        }
        catch (DbUpdateException ex)
        {
            if (attempt == maxRetries - 1)
                throw;
            await Task.Delay(100 * (attempt + 1)); // Exponential backoff
        }
    }
}