how to specify table schema (owner) when using tableadapters?

Question

Hello,

I'd like to connect to an sql server 2005 database using tableadapters.
When I add a tableadapter to my dataset in my project, the tableadaptersConfiguration Wizard (in Visual Studio 2005) easily lets me create a Fill() and GetData() method to populate the dataset with the SQL data.

=> In the automatically created designer.cs file, I notice that the datable's owner is added to the sql commandstring.
=> However, the datatable schema (owner) (dbo, or something else) is different in development and production environment...

For example:

(in development)

SELECT FirstName, LastName
FROM dbo.Employees

(in production environment)

SELECT FirstName, LastName
FROM HumanResources.Employees


The tableadapter isn't able to fill the data in production, since the specified table schema (owner)in the designer file is the one from development.
=> How can I parameterize the table schema (owner)?
    So that the correct table schema (owner) is used in development environment as well as in production environment?

Thanks a lot.
Lieven.

Answer 1

Discussion in Data Platform Development

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.