c# how to specify wich database to use

select *
from [Customer1].dbo.Table1 

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

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

Hi Dear,

Check your connection string in web config file and

check Initial catalog contains the database name .

select * from [databasename]..tablename

 

 

eg: select * from [test_db ] ..customers