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!
9 Answer(s)
-
0
Can anybody help?
-
0
Hi,
Can you try to update EntityFramework.DynamicFilters nuget package to v2.3 and try this issue again ?
-
0
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
-
0
Version 2.0.0 fixes the problem for me. Thanks.
-
0
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.
-
0
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.
-
0
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?
-
0
Hi,
Actually we haven't tried the latest DynamicFilters, I will try and let you know.
-
0
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.
