Connecting multiple database in .NET using C#

Question

I want to give user choice to select database from multiple database(like SqlServer,Oracle,etc) list in the UI. Depending on the user selection, I want to connect to selected database.I can do this by creating interface and implementing that interface by separate class for each database.This approach is explained here
http://thetechstory.com/2012/09/29/connecting-multiple-databases-in-net-using-c-part-1-introduction/

I have also heard that it is possible by using NHibernate also. I don't know much about NHibernate. I have been searching through web.But I am not able to figure out which way is a better way to implement this scenario. Should I go for NHibernate or should code for separate database implementation?

Aymeric · Accepted Answer · 2014-10-30 09:50:04Z

2

Well it depends on what you want to do.

If you want to "code" everything, you can go for the "manual" implementation. But it implies that if someday you want to target another database provider, you will have to create the appropriate interface.

If you want to use an "out-of-the-box" product where this aspect is handle for you can go for NHibernate or other like (CodeFluent Entities).

Anyway there is no right or wrong answer, all depends on what you want to do.

answered Oct 30, 2014 at 9:50

Aymeric

1,2058 silver badges10 bronze badges

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

1 Comment

Antoine Diekmann Over a year ago

This post blog.codefluententities.com/2014/01/29/… show how to handle multiple databases with CodeFluent Entities.

Chaturvedi Dewashish · Accepted Answer · 2014-10-30 09:46:52Z

0

NHibernate will require changes in cofig to connect to database. You might be able to do this at runtime (not sure about this).

Better approach would be if you create adapters for each type of database. See adapter pattern and user strategy pattern to choose one from list of databases.

[Update]
NHibernate is just an ORM, which will convert your table data into objects. You can use both the approaches at the same time.

Use adapter pattern for each database and in each adapter pattern use NHibernate to map objects to database and vice versa.

answered Oct 30, 2014 at 9:46

Chaturvedi Dewashish

1,4692 gold badges15 silver badges39 bronze badges

Collectives™ on Stack Overflow

Connecting multiple database in .NET using C#

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