Migrate entity framework core db first sql server to oracle

Question

I have a .net core project where i am using entity framework db first connecting to sql server which is working fine, now i have similar set of tables in oracle can i just run the project by changing connection string and provider to oracle? Or any major rework is needed to make this work?

Maybe. It depends. How "similar" is "similar"? If the names are identical, if there are no implementation-specific types, you may only have to change the connection string. Have you tried this? — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Oct 7, 2022 at 7:08

ErikEJ · Accepted Answer · 2022-10-07 07:00:54Z

1

You need to regenerate the DbContext mappings using reverse engineering

answered Oct 7, 2022 at 7:00

ErikEJ

42.1k5 gold badges81 silver badges119 bronze badges

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

2 Comments

Panagiotis Kanavos Over a year ago

If the names are identical and the mappings have no SQL Server-specific types or defaults, reverse engineering probably isn't needed

Keep Learning Over a year ago

Thanks, may be in my case its needed but i get it what u mean.

Collectives™ on Stack Overflow

Migrate entity framework core db first sql server to oracle

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related