How to move from mysql to oracle DB using same EF6 codes

Question

0.00/5 (No votes)

See more:

i created a project with C# & Entity Framework 6 & MySQL..
customer like my project , he want to buy about 20 License if it support Oracle , also 3 customers ask me for the same requirements the previous month.

first i don't have enough money for outer employee or freelancer.

1- i ask if it easy to create or (Convert) My MySQL DB to Oracle DB ?
2- it easy to create Oracle DB and deal With it like MySQL ?
3- i will work with Oracle DB using EF6 with same code & syntactic in MySQL Case. is not it ?
4- it good idea to use the same code (C# & EF6) or write a the code from scratch using another language ? what is more effective and easy ?
5- there are any Software or any thing i must to buy or subscribe in it ?
6- there are any recommendations i should to do?

thanks

What I have tried:

i searched for convert DB but i'm afraid it impossible convert VIEWs & SP.

Posted 9-Jun-19 3:50am

Golden Basim

Updated 16-Jun-19 22:19pm

Add a Solution

Comments

[no name] 9-Jun-19 12:21pm

The fact that you are asking these questions makes me doubt that you developed the code you are referring to or that you understand what an ORM is.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2019-06-16T22:19:00

Solution 1

Please, read this: Configure multiple database Entity Framework 6[^]

For further details, please see:
Entity Framework Multi DB Support[^]
Preparing an Entity Framework model for multi provider support[^]

Posted 16-Jun-19 22:19pm

Maciej Los