Save actual database : Entity Framework Core

Ed Robinson

I am working thru an excellent tutorial:

http://www.entityframeworktutorial.net/efcore/entity-framework-core-console-application.aspx

I can do inserts deletes etc - but to the datacontext.

How can i see these real changes in the actual SQL dbs - on Server Explorer - ie persisted changes so theyll be there when i open my dbs next session.

Thanks in advance

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg7y ago
Accepted answer
Hey Hi Ed. You are correct, Migration applied changes to the schema only. When migration done then all your schema will updated in the database. When you execute db.SaveChanges() then only it will saved those data into the database. Yes you need to look harder and you can put try catch block to check for any errors. Thanks. Cheers.
Ed Robinson7y ago
Thanks

are you saying that if say db is a declared as a context, then

db.SaveChanges(); will save to the actual database as well?

(BTW: I thought Migrations applied changes only to the schema?)

In any caseicant seem to see any change to the SQL database data on Server Explorer.

Maybe i need to look harder?
Salman Beg7y ago
Hi. Basically you are following a code first approach. In the code first approach first you need to create the class and after that you need to do a migration. When you will do the migration then all your classes will effect into the db. After that if you do any kind of insert/update then it will affect in that actual db. Please follow that article and implement all the steps. Let me know if you have any other concerns. Thanks.