与.NET网络应用程序和.NET移动应用程序共享数据库

// 使用Entity Framework访问数据库
public class ApplicationDbContext : DbContext
{
    public DbSet<User> Users { get; set; }

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

public class UserController : Controller
{
    private readonly ApplicationDbContext _context;

    public UserController(ApplicationDbContext context)
    {
        _context = context;
    }

    public async Task<IActionResult> Index()
    {
        var users = await _context.Users.ToListAsync();
        return View(users);
    }
}

// 使用事务管理
public async Task<IActionResult> UpdateUser(int id, User user)
{
    using (var transaction = await _context.Database.BeginTransactionAsync())
    {
        try
        {
            var existingUser = await _context.Users.FindAsync(id);
            if (existingUser == null)
            {
                return NotFound();
            }

            _context.Entry(existingUser).CurrentValues.SetValues(user);
            await _context.SaveChangesAsync();

            await transaction.CommitAsync();
        }
        catch (Exception)
        {
            await transaction.RollbackAsync();
            throw;
        }
    }
}

// 使用参数化查询
public async Task<IActionResult> GetUserById(int id)
{
    var user = await _context.Users.FromSqlRaw("SELECT * FROM Users WHERE Id = @Id", new SqlParameter("@Id", id)).FirstOrDefaultAsync();
    if (user == null)
    {
        return NotFound();
    }
    return View(user);
}