Ticket T285628
Visible to All Users

Update PostgreSqlConnectionProvider to reflect breaking changes introduced in Npgsql 3.0.1

created 10 years ago

Right now the PostgreSqlConnectionProvider throws an exception:
System.ArgumentException: Keyword not supported: encoding
Parameter name: keyword
This is because the connection string keyword "encoding" is obsolete in Npgsql 3.0.1 (see http://www.npgsql.org/doc/migration-3.0.html)

Comments (1)
Anatol (DevExpress) 10 years ago

    Thank you for your report. Our developers will research this issue.

    Answers approved by DevExpress Support

    created 9 years ago (modified 9 years ago)

    We have implemented the functionality described in this ticket. It will be included in our next update(s).

    Please check back and leave a comment to this response to let us know whether or not this solution addresses your concerns.

      Show previous comments (3)
      Anatol (DevExpress) 9 years ago

        Hello Philippe,

        To process your recent post more efficiently, I created a separate ticket on your behalf: T297300: How can I intercept the connection string created by the wizard. This ticket is currently in our processing queue. Our team will address it as soon as we have any updates.

          Hi

          this seems to be still the case for XPO 20.2.3

          The following:

          C#
          class Program { static void Main(string[] args) { Console.WriteLine(typeof(PostgreSqlConnectionProvider).Assembly.GetName().Version + ": "+ PostgreSqlConnectionProvider.GetConnectionString("server","userid", "password", "database")); } }

          Prints:

          Code
          20.2.3.0: XpoProvider=Postgres;Server=server;User Id=userid;Password=password;Database=database;Encoding=UNICODE;
          DevExpress Support Team 4 years ago

            Hi,

            The GetConnectionString method does not remove the Encoding parameter. We didn't change it. The CreateProviderFromString method removes this parameter from a connection string.

            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.