Search found 11 matches

Go to advanced search

by GATOWARE
Mon 14 Feb 2022 15:11
Forum: dotConnect for PostgreSQL
Topic: Error trying to add Authentication
Replies: 17
Views: 98331

Re: Error trying to add Authentication

On February 2nd you wrote the following:

Kindly be informed that I had a personal conversation with our Dev team and they convince me that in the next week there will be some feedback regarding the solution of the issue.


Where "next week" should have been between Feb. 7 and Feb 13 and no answer has been received from you. So, I am not wrong when I say that Devart lack of communication is a fact. This is also a disrespectful behavior because time is a valuable resource. I have experienced this issue in the past with my customers subscriptions although this is the first time I have had to wait for more than 4 months without getting a solution to a bug.

Last year I wrote a review on G2 about my experience with Devart dotConnect for PostgreSQL and I lightly mentioned about not being very satisfied with tech support answer time. Surely I will modify such review with my real experience.

I am writing to tell you that I have already started to implement another data provider. I bought a dotConnect for PostgreSQL 3 year subscription on June 15, 2021 for about $400.00 US dollars and I have not used it for the first year yet.

With respect,
Jorge Maldonado
by GATOWARE
Wed 02 Feb 2022 15:01
Forum: dotConnect for PostgreSQL
Topic: Error trying to add Authentication
Replies: 17
Views: 98331

Re: Error trying to add Authentication

It is truly incredible the lack of communication from Devart Tech Support, not even to say a simple word. I had never had such a bad experience with any of the software tools I have used for years. My trouble has grown large due to the significant delay in my current project and my customer is really upset to a degree that I have started to search for another option to replace your product. I do not have words to describe my discomfort and my customer´s. Your products are great except for the poor quality of support and communication.

Respectfully,
Jorge Maldonado
by GATOWARE
Fri 28 Jan 2022 15:35
Forum: dotConnect for PostgreSQL
Topic: Error trying to add Authentication
Replies: 17
Views: 98331

Re: Error trying to add Authentication

Hello,

It's been 4 months now since I reported the issue which has caused an important delay in my project. I kindly ask you to let me know if there has been any advance. I really need to know anything about any status so I can provide an explanation to my customer.

Respectfully,
Jorge Maldonado
by GATOWARE
Wed 22 Dec 2021 18:18
Forum: dotConnect for PostgreSQL
Topic: Error trying to add Authentication
Replies: 17
Views: 98331

Re: Error trying to add Authentication

Wow, what a lack of communication from DevArt tech support team !!!
It´s incredible to have to wait (until now) for 3 months to get a solution.

Regards.
by GATOWARE
Tue 21 Dec 2021 19:46
Forum: dotConnect for PostgreSQL
Topic: Error trying to add Authentication
Replies: 17
Views: 98331

Re: Error trying to add Authentication

I see the new version 7.23 has been released.
Does it contain the fix to the issue in this post?

I will very much appreciate your prompt reply. It has been very long since I posted the problem in the forum.

Regards,
Jorge Maldonado
by GATOWARE
Thu 09 Dec 2021 14:48
Forum: dotConnect for PostgreSQL
Topic: Error trying to add Authentication
Replies: 17
Views: 98331

Re: Error trying to add Authentication

Hello again,

It´s been more than 2 months since I reported this issue and I have not received an answer of a solution. My project deadline has been moved several times and I am now in a difficult situation with my customer. I kindly ask you for an estimated date to solve this problem. For the time that has passed, it seems to me that it is a serious issue. Isn´t it?

Respectfully,
Jorge Maldonado
by GATOWARE
Tue 16 Nov 2021 15:44
Forum: dotConnect for PostgreSQL
Topic: Error trying to add Authentication
Replies: 17
Views: 98331

Re: Error trying to add Authentication

Thanks for the update.

Regards,
Jorge Maldonado
by GATOWARE
Wed 10 Nov 2021 15:43
Forum: dotConnect for PostgreSQL
Topic: Error trying to add Authentication
Replies: 17
Views: 98331

Re: Error trying to add Authentication

It´s been some time since I reported this issue, about one month and a half. Are there any news about it? Is this a complex situation?

Respectfully,
Jorge Maldonado
by GATOWARE
Mon 18 Oct 2021 18:55
Forum: dotConnect for PostgreSQL
Topic: Error trying to add Authentication
Replies: 17
Views: 98331

Re: Error trying to add Authentication

Will you let me know about the fix or will you just include it in a new version?

Regards,
Jorge Maldonado
by GATOWARE
Thu 07 Oct 2021 13:49
Forum: dotConnect for PostgreSQL
Topic: Error trying to add Authentication
Replies: 17
Views: 98331

Re: Error trying to add Authentication

Hi,

Is there an estimated date for the solution of this issue?

Respectfully,
Jorge Maldonado
by GATOWARE
Mon 27 Sep 2021 18:35
Forum: dotConnect for PostgreSQL
Topic: Error trying to add Authentication
Replies: 17
Views: 98331

Error trying to add Authentication

Hi,

I have been trying to add Authentication to an ASP.NET Core 5 web application without succes. I am following exactly the instructions in your website: https://www.devart.com/dotconnect/postg ... 1632412803

I have the following versions of Devart:
  • Devart.Data.dll: 5.0.2697.0
  • Devart.Data.PostgreSql.dll: 7.20.1905.0
So, I use NuGet instead of the command below to make sure version 7.20.1905.0 is installed:
install-package Devart.Data.PostgreSql.EFCore
(I also tried running the command to get the latest version)

Every step is done without errors until I reach the end, update-database.
This is the appsettings.json file with the connection string (DefaultConnection)

Code: Select all

{
  "ConnectionStrings": {
    "Anonymous": "host=localhost;database=testwithoutusers;schema=testwithoutusers;port=5432;user id=anonymous;password=anonymous;License Key=n7UBDBU7VZ2bJ2bnpFvq0WiQliEDxJRPtvByFjBXw5SwmZj1oyZg+lVDiR7b0/sTC5EZOf4dUDtrzLJj/RxA+fkRIgcDTtyc3t4oI0il+q//ek8QqTzeIicZUQo2xm0fZdfDk4mYSqxdlesin3VxZ5BR/HLsWzAdukPypvM52xrf0mbVczcWoyEfwah4lb/q/1SZnvgccHWhcIY+IWAXxutlmm1Hg/8aW5hMUUK3HF5gsHzR/YcXz54GGmiq2/E9LSiIZya+Lwv4VboCCP2mI9ZMZ23/GzHd4jGykCqdOnE=",
    "DefaultConnection": "host=localhost;database=testwithoutusers;schema=testwithoutusers;port=5432;user id=postgres;password=passwordhere;License Key=n7UBDBU7VZ2bJ2bnpFvq0WiQliEDxJRPtvByFjBXw5SwmZj1oyZg+lVDiR7b0/sTC5EZOf4dUDtrzLJj/RxA+fkRIgcDTtyc3t4oI0il+q//ek8QqTzeIicZUQo2xm0fZdfDk4mYSqxdlesin3VxZ5BR/HLsWzAdukPypvM52xrf0mbVczcWoyEfwah4lb/q/1SZnvgccHWhcIY+IWAXxutlmm1Hg/8aW5hMUUK3HF5gsHzR/YcXz54GGmiq2/E9LSiIZya+Lwv4VboCCP2mI9ZMZ23/GzHd4jGykCqdOnE="
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*"
}
I have double-checked the connection string content (database name, schema name, port, user id, password)
PostgreSQL database version is 11.
I just upgraded Devart.Data.PostgreSql.EFCore to version 7.21.1985 along with Devart.Data and Devart.Data.PostgreSQL via Nuget Packages (I use NuGet packages in this specific test project).

This is the ConfigureServices method:

Code: Select all

public void ConfigureServices(IServiceCollection services)
        {
            services.AddDbContext<ApplicationDbContext>(options =>
                options.UsePostgreSql(Configuration.GetConnectionString("DefaultConnection")));
            
            services.AddDatabaseDeveloperPageExceptionFilter();

            services.AddDefaultIdentity<IdentityUser>(options => options.SignIn.RequireConfirmedAccount = true)
                .AddEntityFrameworkStores<ApplicationDbContext>();
            services.AddControllersWithViews();
        }
This is the error I get:

PM> update-database
Build started...
Build succeeded.
fail: Microsoft.EntityFrameworkCore.Database.Connection[20004]
An error occurred using the connection to database 'testwithoutusers' on server 'localhost'.
An error occurred using the connection to database 'testwithoutusers' on server 'localhost'.
Devart.Data.PostgreSql.PgSqlException (0x80004005): Unexpected server response.
at ​ .​   (Char , Boolean , Boolean )
at   .​   (Char , Boolean , Boolean )
at ​ .(Boolean , Boolean , Char , Boolean )
at ​ .(Boolean , Boolean )
at ​ .(Boolean )
at ​ .(   , Boolean , Boolean , Boolean )
at ​ .(   , Boolean , Boolean )
at ​ .(   , Boolean )
at   .()
at   .(   , Boolean )
at   .()
at   .   ()
at  .()
at  .(DbConnectionBase )
at  .   (DbConnectionBase )
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.PostgreSql.PgSqlConnection.Open()
at Devart.Common.Entity.c1.Open()
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnection(Boolean errorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)
at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection)
at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String connectionString, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String connectionString, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0()
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
Unexpected server response.


I also get an error when testing with a ASP.NET Core 3.1 web project:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
---> System.TypeLoadException: Could not load type 'Microsoft.EntityFrameworkCore.Internal.SemanticVersionComparer' from assembly 'Microsoft.EntityFrameworkCore, Version=5.0.10.0, Culture=neutral, PublicKeyToken=adb9793829ddae60'.
at Microsoft.EntityFrameworkCore.Design.OperationExecutor..ctor(IOperationReportHandler reportHandler, IDictionary args)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at System.Activator.CreateInstance(Type type, Object[] args)
at Microsoft.EntityFrameworkCore.Tools.ReflectionOperationExecutor..ctor(String assembly, String startupAssembly, String projectDir, String dataDirectory, String rootNamespace, String language)
at Microsoft.EntityFrameworkCore.Tools.Commands.ProjectCommandBase.CreateExecutor()
at Microsoft.EntityFrameworkCore.Tools.Commands.MigrationsAddCommand.Execute()
at Microsoft.EntityFrameworkCore.Tools.Commands.CommandBase.<>c__DisplayClass0_0.<Configure>b__0()
at Microsoft.DotNet.Cli.CommandLine.CommandLineApplication.Execute(String[] args)
at Microsoft.EntityFrameworkCore.Tools.Program.Main(String[] args)
Exception has been thrown by the target of an invocation.


I would like to send a video showing the process I do. Can you tell me how to send it?

I will very much appreciate your support to solve my issue.

Respectfully,
Jorge Maldonado

Go to advanced search