views:

18

answers:

0

I'm having the following problem and I want to know whether it is a Visual Studio bug or if I'm doing something wrong:

I'm using AdventureWorks database in SQL Server 2005 and Visual Studio 2008.

When defining a new DataSource (to be used in a GridView) I select the Product table, defined in the Production schema, but the generated query does not includes the schema:

SELECT [ProductID], [Name] FROM [Product]

Thus it fails. The correct query would be:

SELECT [ProductID], [Name] FROM Production.[Product]

If I select a table in the dbo schema I have no problem.