Can I change the database with existing linq program?

Question

0.00/5 (No votes)

See more:

Dear all,

I am reading a lot about Linq, but there are some parts that I can't figure out. Can anyone help me answering these questions?

Let say I have a Linq to SQL project and have attached a Access database to this. But in time I need to upgrade to the SQL server or MySql database. Do I then only need to adjust the connection string to the new database or do I need to rewrite the whole project?

Also is it possible to have connections to 2 or more diffent databases (rather same or different types of databases) in 1 project?

I have searching the internet verywhere but can't figure this out. All I can find ios that Linq can work with multiple type of databases, but none that is giving answers to my questions.

thanks,
Hans

What I have tried:

I have searching the internet to try to find the answers, but no luck sofar.

Posted 27-Oct-19 0:43am

Member 13039327

Updated 27-Oct-19 3:05am

Add a Solution

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)

RickZeeland · Answer 1 · 2019-10-27T03:05:00

Solution 1

An ORM (Object Relational Mapper) helps to make your code database-agnostic.
Take a look at the free DevExpress XPO: orms-for-c[^]

If you don't want to use an ORM, read this: Don't hard code your DataProviders[^]
As this is an older article, there is no mention of LINQ, but I think the principles still can be useful nowadays.

About the term database-agnostic:

Quote:
Database-agnostic is a term describing the capacity of software to function with any vendor’s database management system (DBMS).

See: What is database-agnostic? - Definition from WhatIs.com[^]

Posted 27-Oct-19 3:05am

RickZeeland

Updated 27-Oct-19 9:03am

v3

Comments

Member 13039327 27-Oct-19 13:28pm

Hello RickZeeland,

Thanks for the reply. But I'm sorry, I'm not sure what you mean with database-agnostic. Do you mean that when I have used the ORM, I can attached any kind of database to it, without changing any coding (except maybe the connection string) ??

So if I create a project with ORM and use Access Database and later I want to go using a SQLServer database, I only need to change the connection string?

And also thanks for the link, don't hard code your dataProvider. But this is not about Linq, so I am not sure how it is being in Linq. If the code remains the same, regardless the type of database.

Regards,
Hans