I am using C# and sql server database.
I have an application that uses different databases, I want to include all databases on a single database (each database on a schemat).
currently I use normal connection strings on the web.config to connect to the different database. and on the graphical interface I choose the database to use.
how can I modify the connection strings to specify the schema to be used?
on the other hand, the different databases contain almost the same table names. isn't that a problem?
