TableAdapters SQL 2005 on tables that have a unique Schema RRS feed

  • Question

  • I'm trying to create table adapters & strongly typed datasets for some basic gridview work. Some of the tables that I am working against have a Schema other then dbo. When the adapters are created and used they seem to not take into account the schema name properly on the autogenerated queries. i.e.

    Code Snippet

    /* GetDataSet() */

    SELECT [IndividualStaging].[AccountName] AS [AccountName] FROM [MySchema].[IndividualStaging]



    Running this query would return: The multi-part identifier "IndividualStaging.AccountName" could not be bound.


    Is there a patch or a known work around for this problem? I can generate the SQL by hand but because of the nature of this project I was hoping to use the built in RAD features of VS2008.





    Tuesday, April 15, 2008 3:56 PM