Base solution for your next web application
Open Closed

Abp Framework with PostgreSQL #1550

User avatar
0
pilgrimconsulting created

Hi everyone, I have got a trouble while connecting AspZero Framework with PostgreSQL database. I've digged deeper, decompiled libraries. The problem is with Entity Framework, and several days of investigation showed that the reason is EntityFramework.DynamicFilters, ASP.NET Zero using version 1.4.10.2

We have found EntityFramework.DynamicFilters version 2.2.0. Currently, when trying to redirect to the newer version, we are getting an error that ASP.NET Zero compiled to work with version 1.4.10.2

With the help of DynamicFilters to the range of selected entities extra filter is being injected by current TenantId, but in PostgreSQL realization there is lack of ending brackets in the query and it doesn't depend on PostgreSQL provider, because I've tried several ones, and have got the same problem. But when trying to retrieve entities which do not depend on Tenant - it works.

Hardcoded adding closing brackets while debugging - resolves the problem.

Please, help to resolve the issue, or maybe there is an updated version of portal with a newer version of EntityFramework.DynamicFilters library.

Thanks in advance!

Go to accepted answer
9 Answer(s)
  • User Avatar
    0
    pilgrimconsulting created

    Can anybody help?

  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi,

    Can you try to update EntityFramework.DynamicFilters nuget package to v2.3 and try this issue again ?

  • User Avatar
    0
    pilgrimconsulting created

    Hi, Thanks for a reply.

    Have updated version of EntityFramework.DynamicFilters to v. 2.3

    Now I have the next error:

    Method not found: 'Void EntityFramework.DynamicFilters.DynamicFilterExtensions.Filter(System.Data.Entity.DbModelBuilder, System.String, System.Linq.Expressions.Expression`1<System.Func`3<!!0,!!1,Boolean>>, !!1)'.

    Have googled this and found: #1468@c87d2de9-c334-4ece-9d39-fdf8464e4761

  • User Avatar
    0
    pilgrimconsulting created

    Version 2.0.0 fixes the problem for me. Thanks.

  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi,

    Can you also check that you don't have this issue in your application ? <a class="postlink" href="https://github.com/aspnetboilerplate/aspnetboilerplate/issues/1209">https://github.com/aspnetboilerplate/as ... ssues/1209</a>

    Because there is an important bug and because of that we downgraded from DynamicFilters v2.1 to v1.4.11.0.

  • User Avatar
    0
    pilgrimconsulting created

    Hi, I've done all my best to reproduce something, at the moment - no problems at all. I've fixed present migrations, there were some difference in syntax and indexes names length. Also there were a problem that PostgreSQL working on UTF8, but language names list contains chars not in this encoding. Portal working stable, but will see... if any problems - I'll notify here.

  • User Avatar
    0
    pilgrimconsulting created

    Is it possible to make changes to use the latest version of DynamicFilters? Maybe you know how to fix an error which I've written before?

  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi,

    Actually we haven't tried the latest DynamicFilters, I will try and let you know.

  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi,

    We had to downgrade EntityFramework.DynamicFilters to v1.4 .11 because of some problems. Can you check that if you still have the same problem with EntityFramework.DynamicFilters to v1.4 .11 if you have time for this ? Of course you need to upgrade ABP packages.

    Thanks.

Assignee
No one
Labels
Non yet