c# how to specify wich database to use

Question

HI How can I specify wich database to use ? i'm am making a webapp . each customer get there own database( about 4000 customers). SO I was wundering can I do DECLARE @CLAdatabase = test_db USE @CLAdatabase GO SELECT* from customers

ali tuncer · Answer

Did you try writing the name of Database in front of Table name like Abdu suggested? select * from [Customer1].dbo.Table1

Cassie Mod · Answer

the connection string is probably not the problem. as I was saying. When I do this with 2 or 3 databases  I can du it with the connection string. so let me say it different. You can I use a paramether ( of the database) in the connectionstring ? I don't want to make 4000 connection strings

Cassie Mod · Answer

the connection string is probably not the problem. as I was saying. When I do this with 2 or 3 databases  I can du it with the connection string. so let me say it different. You can I use a paramether ( of the database) in the connectionstring ? I don't want to make 4000 connection strings

Amit Kumar · Answer

Hi Dear Check your connection string in web config file and check Initial catalog contains the database name .

Abdu Rafeeq · Answer

select * from [databasename]..tablename eg: select * from [ test_db ] .. customers