Last post Jul 27, 2019 03:38 PM by mehmoodahmed...
Jul 27, 2019 01:17 PM|mehmoodahmed...|LINK
Jul 27, 2019 01:44 PM|mgebhard|LINK
I want to know that still database approach considers to be more efficient than directly calling objects through EF objects (LINQ).
Can I directly use my database through store procedures in new EF core.
Previously we were using EDMX to map the database objects. Do we still have it rather than generating EDMX (through reverse engineering in code first) .
EMDX had some issue, now is there anything new in EF Core.
Can anyone guide me about best practices and pattern for EF Core with example?
What would be good if a database have much data and many tables?
This information is openly covered in standard EF Core documentation. I recommend that you at least read the introduction as you'll find quickly that database first does not exist in EF Core.
The What's new section explains "What's new".
Jul 27, 2019 01:58 PM|mehmoodahmed...|LINK
Jul 27, 2019 02:11 PM|mgebhard|LINK
Thank you mgebhard.
One thing has been cleared that EDMX ll not be available and if we lost our database then we can reverse engineer through EF core context classes
It means we ll have to use stored procedure using this new approach and 'll have to keep the database scripts.
Can we reverse engineer the database stored procedure as well?
And we have to use the default data inusing EF core
You're making assumptions before learning the technology.
To answer your stored procedure question, I use Code First migrations to CREATE stored procedures or execute any kind of DDL operation I need. There are several benefits to this standard approach. The stored procedures are under source control along with
the rest of your code. If you run the migration on deployment, as I do, then every time you deploy and start the app, the migrations will run too. No need to have a separate DB deployment.
If your shop requires a DBA to deploy, the you can easily get the SQL deployment script from the migrations using the CLI tools.
I recommend that you and your team spend a few week/months to learn the technology and come up with an SDLC that fits your needs.
Jul 27, 2019 03:38 PM|mehmoodahmed...|LINK