TableAdapter - fails when database name changed

microsoft.public.dotnet.framework.adonet

26 Oct 2006 2:48 PM

John

Hi,

I have a project that includes a number of Table Adapters. When I publish my
web site on another machine, I am configuring it to point to a database on
that machine. This database has a different name to the one on my
development machine.

I change the connection strings in my web.config, and everything works apart
from the table adapters. The problem appears to be that the generated .xsd
file contains a "DbObjectName" tag which has the database name hardcoded in
as well as the schema and table names.

Is there any way to prevent the generated .XSD file having hardcoded
database names in it?

Thanks
John