如何为C# WPF项目创建并连接云数据库？附步骤与代码

Got it, let's break this down step by step—since you’re already up and running with a local SQL Server and WPF, shifting to a cloud SQL database (I’ll use Azure SQL Database here, as it’s the most seamless fit for C#/.NET projects) is totally doable once you know the right steps. I’ll walk you through everything from creating the cloud DB to updating your WPF code.

• Head to the Azure Portal, search for "SQL Databases", and click Create.
• Fill in the basic details:
  • Select your Azure subscription and resource group (create one if you don’t have it).
  • Name your database, then create a new server (choose a unique server name, set an admin username/password—make sure to save these credentials, you’ll need them later).
• For compute and storage, pick a tier that fits your needs: for testing, the free "Basic" tier or Serverless option works great.
• Finish the setup and wait for the database to deploy (takes a few minutes).

By default, cloud SQL databases block external connections—you need to whitelist your local machine’s IP:

• Go to your newly created SQL Database page, select Networking from the left menu.
• Under "Public access", choose Selected networks.
• Click Add your client IPv4 address to automatically add your current machine’s IP, then save the rules.
• Optional: Check "Allow Azure services and resources to access this server" if you plan to deploy your WPF app to Azure later.

First, grab the correct connection string from Azure:

• On your SQL Database page, select Connection strings from the left menu.
• Copy the ADO.NET template, then replace {your_username} and {your_password} with the admin credentials you set earlier.

For .NET Framework WPF Projects (uses App.config) #

Update the connectionStrings section:

<connectionStrings>
  <add name="CloudDbContext" 
       connectionString="Server=tcp:your-server-name.database.windows.net,1433;Initial Catalog=your-db-name;Persist Security Info=False;User ID=your-admin-username;Password=your-admin-password;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;" 
       providerName="System.Data.SqlClient" />
</connectionStrings>

For .NET 5+ WPF Projects (uses appsettings.json) #

Add/modify the ConnectionStrings section:

{
  "ConnectionStrings": {
    "CloudDbContext": "Server=tcp:your-server-name.database.windows.net,1433;Initial Catalog=your-db-name;Persist Security Info=False;User ID=your-admin-username;Password=your-admin-password;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
  }
}

Example 1: Basic ADO.NET Connection & Query #

If you’re using raw ADO.NET, update your existing code to use the cloud connection string:

using System.Data.SqlClient;
using System.Windows;

private void TestCloudConnection()
{
    // Pull connection string from config
    string connString = System.Configuration.ConfigurationManager.ConnectionStrings["CloudDbContext"].ConnectionString;

    try
    {
        using (SqlConnection conn = new SqlConnection(connString))
        {
            conn.Open();
            MessageBox.Show("Successfully connected to cloud database!");

            // Example: Fetch sample data
            string query = "SELECT TOP 5 * FROM YourExistingTableName";
            using (SqlCommand cmd = new SqlCommand(query, conn))
            {
                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        // Process data (e.g., add to a UI list)
                        string item = reader["YourColumnName"].ToString();
                        YourListBox.Items.Add(item);
                    }
                }
            }
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show($"Connection failed: {ex.Message}");
    }
}

Example 2: Entity Framework Core Integration #

If you’re using EF Core, update your DbContext to use the cloud connection string:

using Microsoft.EntityFrameworkCore;
using System.Configuration;

public class CloudDbContext : DbContext
{
    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        string connString = ConfigurationManager.ConnectionStrings["CloudDbContext"].ConnectionString;
        optionsBuilder.UseSqlServer(connString);
    }

    // Define your DbSets (match your existing entities)
    public DbSet<Product> Products { get; set; }
}

// Usage in WPF code
private async Task FetchCloudData()
{
    try
    {
        using (var context = new CloudDbContext())
        {
            var products = await context.Products.Take(10).ToListAsync();
            // Bind to a DataGrid or other UI control
            ProductDataGrid.ItemsSource = products;
            MessageBox.Show("Data fetched from cloud successfully!");
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show($"Error: {ex.Message}");
    }
}

• Firewall blocks connection: Wait 1-2 minutes after saving firewall rules, or double-check that your IP is correctly listed.
• Invalid credentials: Triple-check the username/password in your connection string (server admin credentials, not local SQL credentials).
• Encryption errors: Ensure Encrypt=True and TrustServerCertificate=False are in your connection string—Azure SQL requires encrypted connections.
• Missing tables: Use the Azure Portal’s Query editor to verify your tables exist in the cloud database (you can also run migrations if using EF Core).

内容的提问来源于stack exchange，提问作者limshi rashmika