Loading

How can we use linq in asp.net with multiple database....

KUSHAL AGARWAL

11y1.2kLINQ

Hello Mam,

I m using asp.net with my project and in this project database changes according to login ...so my database is dynamic...so how i use linq for this because we have to select database for using linq...

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

KUSHAL AGARWAL11y ago
thankxx...but my question is not for differnet type of database...but my question is related to multiple database of same type as like sqlserver....ex:-database name cane1213,cane1314,cane1415 etc.
0
Gagan Sikri11y ago
Hi Kushal

To access data from different databases using LINQ from Microsoft SQL Server you can use multiple data contexts and use data context according to your application where you need data. For more details refer to this article; Click Here.
0
Nanhe Siddique11y ago
read this link

http://www.codeproject.com/Articles/23303/LinqToSQL-Query-Multiple-Databases-in-One-LINQ-Exp

http://weblogs.asp.net/scottgu/linq-to-sql-part-3-querying-our-database

it may help you
0