WPF中使用EF6 Code First创建应用目录本地数据库求助

Hey there! I’ve helped tons of folks work through this exact issue—getting EF6 Code First to create a database right in your WPF app’s output directory isn’t hard once you nail the connection string and a couple key settings. Let’s walk through it step by step.

1. Correct Connection String in App.config #

First, let’s get the connection string right. We’ll use LocalDB (the lightweight SQL Server instance that comes with Visual Studio) and the |DataDirectory| placeholder to point to your app’s execution folder. Here’s the exact config you need:

<configuration>
  <connectionStrings>
    <!-- Replace "MyAppDbContext" with your DbContext class name -->
    <add 
      name="MyAppDbContext" 
      connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\MyAppDatabase.mdf;Integrated Security=True" 
      providerName="System.Data.SqlClient" 
    />
  </connectionStrings>
</configuration>

• name must match the name of your DbContext class (or the name you pass to its constructor).
• |DataDirectory| is a special placeholder that we’ll map to your app’s bin/Debug/Release folder next.

2. Set DataDirectory to Your App’s Execution Folder #

By default, |DataDirectory| might point to a hidden AppData folder instead of your app’s visible output directory. Fix this by setting it explicitly in your App.xaml.cs:

using System;
using System.Data.Entity;
using System.Windows;

namespace YourWpfAppNamespace
{
    public partial class App : Application
    {
        protected override void OnStartup(StartupEventArgs e)
        {
            // Map DataDirectory to the app's running directory (bin/Debug/Release)
            AppDomain.CurrentDomain.SetData("DataDirectory", AppDomain.CurrentDomain.BaseDirectory);

            // Optional: Ensure EF creates the database if it doesn't exist
            Database.SetInitializer(new CreateDatabaseIfNotExists<MyAppDbContext>());

            // Trigger database initialization on app start
            using (var db = new MyAppDbContext())
            {
                db.Database.Initialize(false);
            }

            base.OnStartup(e);
        }
    }
}

3. Configure Your DbContext #

Make sure your DbContext uses the connection string we defined. The simplest way is to pass the connection string name to the base constructor:

using System.Data.Entity;

namespace YourWpfAppNamespace
{
    public class MyAppDbContext : DbContext
    {
        // Use the connection string named "MyAppDbContext" from App.config
        public MyAppDbContext() : base("MyAppDbContext")
        {
        }

        // Add your DbSet properties here (example below)
        public DbSet<Customer> Customers { get; set; }
        public DbSet<Order> Orders { get; set; }
    }

    // Example entity classes
    public class Customer
    {
        public int Id { get; set; }
        public string Name { get; set; }
    }

    public class Order
    {
        public int Id { get; set; }
        public int CustomerId { get; set; }
        public Customer Customer { get; set; }
    }
}

4. Common Pitfalls to Avoid #

• Permission Issues: If your app is installed in Program Files, it might not have write access. For development, stick to the bin/Debug/Release folder (which has full permissions).
• Mismatched Names: Double-check that the connection string name matches the name passed to your DbContext constructor.
• LocalDB Not Installed: Most VS installs include LocalDB, but if you get a "cannot connect" error, verify it’s installed via the Visual Studio Installer (look for "SQL Server Express LocalDB").

5. Verify the Database is Created #

After running your app:

1. Navigate to your project’s bin/Debug (or bin/Release) folder. You should see MyAppDatabase.mdf and MyAppDatabase_log.ldf files.
2. Open Visual Studio’s SQL Server Object Explorer, expand (LocalDB)\MSSQLLocalDB, and you’ll see your new database listed.

If you still run into errors, share the exact exception message you’re getting—I can help troubleshoot further!

内容的提问来源于stack exchange，提问作者Nicolò