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

Question

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...

Gagan Sikri · Answer

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 .

KUSHAL AGARWAL · Answer

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 cane1213cane1314cane1415 etc.

Nanhe Siddique · Answer

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