Using LINQ to connect with multiple databases

Question

I am developing an ASP.NET application in which I need to provide support for two databases, MySql and MS SQL Server 2005 and 2008 (one database will be used at a time).

How will I configure the ASP.NET app to connect with different databases without reinstalling the app (i.e. using configuration)?
How will I configure LINQ?
Shouldn't I use NHibernate?

Rick · Accepted Answer · 2010-11-22 09:54:21Z

1

Use basic Linq to SQL structures (nothing database specific) and by just changing the connection string should do the trick. Linq expression trees are transformed to SQL by Linq enabled drivers (i.e. they know how to handle the expression tree).

answered Nov 22, 2010 at 9:54

Rick

3,4511 gold badge24 silver badges31 bronze badges

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

1 Comment

Rich Over a year ago

There is a flaw in your suggestion. Linq to SQL (System.Data.Linq) does not support any database except SQL Server. Entity Framework (with a MySql Connector version of 6.x or above) or NHibernate do, though.

bluish · Accepted Answer · 2013-04-08 08:35:08Z

0

Here is better way of doing it: Multiple database support with Entity Framework.

edited Apr 8, 2013 at 8:35

bluish

27.5k28 gold badges126 silver badges185 bronze badges

answered Dec 2, 2010 at 12:53

Abdul Khaliq

2,47312 gold badges41 silver badges65 bronze badges

Collectives™ on Stack Overflow

Using LINQ to connect with multiple databases

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related