How to use single dbml file with different database

Question

I am using LinqToSql. I have different databases for my application(Just database name is different). I pick url value and then use database according to that.

Problem is that there is a single .dbml file, there is one constructor where connection string is picked from web.config file. But I need to use different databases according to query string. Can we use single dbml file with more than 1 databases and how?

Is there possible solution for this?

As you'll need one database at a time, you can change database name in connection string object at runtime. — Imran Rizvi
– Imran Rizvi, Commented Nov 11, 2013 at 10:50

Imran Rizvi · Accepted Answer · 2013-11-11 10:53:32Z

2

You can change database name in the connection string at runtime. Just create context object with new connection string parameter and use it for queries.

DataContext context = new DataContext (newConnectionString);

answered Nov 11, 2013 at 10:53

Imran Rizvi

7,47813 gold badges63 silver badges103 bronze badges

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

Collectives™ on Stack Overflow

How to use single dbml file with different database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related