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.