changing application from sqlserver to oracle

Question

0.00/5 (No votes)

See more:

Hello,

Me and two of my friends (we are all beginners) developpped an application to a client .We used a sqlserver database and linq queries.
Now our client wants the same application with an oracle database.So i have many questions; do we have to redo all the work(as we used linq in the first sol°), and for future use what is the better solution to use ado.net ,linq, entity framework or other ORM.

Thank you in advance:)

Posted 27-Mar-12 5:22am

csprogrammer

Add a Solution

2 solutions

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)

Rahul Rajat Singh · Answer 1 · 2012-03-27T05:41:00

Solution 1

It depends on the design. if yuor application data access is using some ORM and/or there is a separate Data access layer physically (i.e. separate project) then you just have to rework on that part and rest of the application can remain the same.

Posted 27-Mar-12 5:41am

Rahul Rajat Singh

Comments

csprogrammer 28-Mar-12 5:17am

unfortunately no there are no separation between layers all the work is done in the classes methods.If you can suggest me a tutorial about project organization best practices that will be great.

And what about comparing ADO.net , ENTITY FRAMEWORK and LINQ ??

Jörgen Andersson 28-Mar-12 6:56am

If you had asked this two weeks ago, the answer would clearly have been ADO.net. But Oracle released support for Entity Framework and Linq on the 16th of March with the newest ODAC 11.2 Release 4. Now it depends more on how you work.

Rajeev Jayaram 28-Mar-12 8:23am

Refer below link for basic idea on multitier architecture, before you start, it would help you get the idea.
http://en.wikipedia.org/wiki/Multitier_architecture

Rahul Rajat Singh · Answer 2 · 2012-03-28T01:39:00

The code in class methods will give you a big trouble in changing the database. That is why the n-tier architecture is preferred. I can give you 2 links which has n-tier architecture implemented (perhaps you may find them useful.

1. YaBlogEngine - A Tiny Blog Engine written in ASP.NET/C#[^]

2. YaMessaging - A simple e-mail like messaging application[^]