Bug Report T293008
Visible to All Users

The IDataStoreSchemaExplorer.GetStorageTables method obtains database tables with no primary key information

created 9 years ago (modified 9 years ago)

Hi,

We are using XPO for getting data from an existing database . But when i try to get the schema information (for any table) we get no primary information. The code below shows the point where we get the problem :

DBTable[] tables = ((IDataStoreSchemaExplorer)s).GetStorageTables(tableName);
DBTable table = tables[0];
-- the table.PrimaryKey is always null no matter what are the real keys in database table.

I'm sending a little project with a complete code, the database I use to test is in a SQL Server , follows the configuration: Microsoft SQL Server Enterprise (64-bit), OS: Microsoft Windows NT 6.2 (9200), Plat. NT x64, Version 11.0.2100.60, Language English (EUA).

Thanks and Best Regards.

Comments (1)
DevExpress Support Team 9 years ago

    Hello Francisco.

    Thank you for your report. I have replicated the issue and passed it to our developers for further research. We will update this ticket once we have any result.

    Answers approved by DevExpress Support

    created 9 years ago (modified 9 years ago)

    We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.

    Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.

      Show previous comments (2)
      DevExpress Support Team 9 years ago

        We appreciate this.

        Do hot hesitate to contact us in case of further difficulty.

        Regards

          hi,
          In version 16.1. 7, this bug is not fixed.

          DevExpress Support Team 8 years ago

            @Wei Tang:

            I've just tested the sample project posted at the beginning of this thread with version 16.1.7 of our libraries. It works correctly on my side. If you faced an issue in another scenario, please create a new ticket and provide us with a small sample project demonstrating it.

            Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

            Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.