Create SQL Database From DBContext EF Core

Question

My pc suddenly got sick and all the data are removed and no way to recover them.

I was working on several projects with .NET 5 using EF core 6 Database first approach.

I cloned my projects from GitHub to get them back but unfortunately I don't have a backup or SQL file for the database.

Is there any way to create the database from the dbContext in the .NET 5 project?

learn.microsoft.com/en-us/ef/core/managing-schemas/migrations/… — Crowcoder
– Crowcoder, Commented Mar 25, 2022 at 19:03

gsharp · Accepted Answer · 2022-03-25 20:54:30Z

3

I do not quite understand the question, is perhaps meant something like this?

//creates an instance of the class where the "database" is
Database db = new Database();

//creates the database if it does not exist
db.Database.EnsureCreated();

edited Mar 25, 2022 at 20:54

gsharp

28k26 gold badges94 silver badges137 bronze badges

answered Mar 25, 2022 at 20:23

Schecher_1

5607 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Schecher_1 Over a year ago

@gsharp It doesn't matter, anyway thanks that I can write comments now (have 59 points) To be honest, I hate this system. I also delete my comments and we act as if it never happened :)

kevintw · Accepted Answer · 2022-03-25 20:19:21Z

1

You should probably use dbContext.Database.EnsureCreated();

With this your DataBase structure will be re-created from the model. Of course, there will be no data, just empty tables, indexes etc.

answered Mar 25, 2022 at 20:19

kevintw

586 bronze badges

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

user15993896 · Accepted Answer · 2022-03-25 20:34:01Z

1

You can re-create the database structure with your existing model. But there is no way to recover the data

answered Mar 25, 2022 at 20:34

user15993896

Comments

shady youssery · Accepted Answer · 2022-03-26 00:36:01Z

1

You can use this code in startup.cs file or program.cs '.net core 6'

`dbContext.Database.Migrate()`

This line will update database with all migrations which not applied on database

answered Mar 26, 2022 at 0:36

shady youssery

4402 silver badges17 bronze badges

Comments

Ammar Ismaeel · Accepted Answer · 2022-03-26 18:48:59Z

1

The fastest way was running these commands:

Add-Migration InitialCreate

and Then:

Update-Database

answered Mar 26, 2022 at 18:48

Ammar Ismaeel

8132 gold badges14 silver badges27 bronze badges

Collectives™ on Stack Overflow

Create SQL Database From DBContext EF Core

5 Answers 5

1 Comment

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related