Auto Create database using EF Core

Question

I'm using EF Core in my Winforms application but I can't generate database automatically without migrations.

I read this articles but It is for asp.net core: auto create database in Entity Framework Core

My DbContext:

    public DbSet<Users> Users { get; set; }
    public DbSet<Accounts> Acc { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer(ConfigurationManager.ConnectionStrings["FreeAcc"].ConnectionString);
    }

Edit: I'm using localdb

You do **need** Migrations to generate the Db automatically. Otherwise you need to create the schema yourself. — DC_AC, Aug 27 '20 at 20:49
You could try using `context.Database.EnsureCreated()`. More information [here](https://learn.microsoft.com/en-us/ef/core/managing-schemas/ensure-created#ensurecreated) — Shoejep, Aug 27 '20 at 20:52
@Shoejep I didn't know about those APIs and been having some experience in EF Core recently. I stand corrected. — DC_AC, Aug 27 '20 at 20:56

score 1 · Accepted Answer · answered Aug 28 '20 at 17:40

You can use context.Database.EnsureCreated() to create the database if it doesn't exist.

EnsureCreated will create the database if it doesn't exist and initialize the database schema. If any tables exist (including tables for another DbContext class), the schema won't be initialized.

EnsureCreated is part of EF Core in Microsoft.EntityFrameworkCore, it's not exclusive to ASP.NET Core.

I suggest you call EnsureCreated when your application starts up or just before you use your DbContext.

EF Core Create and Drop APIs Documentation

Auto Create database using EF Core

1 Answers1

Linked