Oracle support about entityframework.dynamicfilters HOT 6 CLOSED

I have not tried it myself. But since you are having issues, I'd say the answer is currently No. I'll take a look at it and see what I can do. Can you also post the model & filter that you are using? I'll run it through all my units tests but I'd like to make sure I test it with your filter too. And which version of Oracle are you using?

from entityframework.dynamicfilters.

I'm using the ABP Framework, which use your project :)
This is the one : https://github.com/aspnetboilerplate/module-zero which encapsulate DynamicFilters.

You can download it and switch to oracle with nuget packages; otherwise I already have the project converted with nuget and correct .config file, here :
http://www.rka.be/ORACLE.zip

you can see the domain and the seed method. update-database works fine, but the seed does not.
when I do update-database -verbose; I don't see any related stuff about annotations :\

I use an 11g version of oracle. (12 is also a possibility if it's not possible with 11)

Is it enough infos for you ? :)

from entityframework.dynamicfilters.

Thanks! That should do it. I'll take a look at this over the weekend and let you know what I find.

from entityframework.dynamicfilters.

I'm not able to get your sample project to open up cleanly. It looks like you had manually added the Abp.Zero project source and changed ModuleZeroSampleProject.Core to reference that source directly. But the current source from github is newer than what your sample project seems to be expecting so I can't get anything to compile right and don't know enough about ABP to fix it. I've also removed those direct src references and fixed it to reference the NuGet packages but that just produces different compile errors.

Can you check this with all updated NuGet packages (and no direct src links) and post a new sample project?

I have found some problems in my library when running on Oracle but I'm not sure if it's the same things you are seeing so I'd like to try it against your project. I'm not sure what is failing in your seed method since that should not have anything to do with the filters...

from entityframework.dynamicfilters.

I just pushed changes and updated NuGet for Oracle support. Give that a try and see if that covers everything.

However, the Oracle driver has issues with DateTimes. DateTimeOffset works fine (which is translated to the Oracle TIMESTAMP datatype). If you get errors saying "The member with identity 'Precision' does not exist in the metadata collection" this is why.

It also does not support generating an "in" expression so I had to translate that to a series of equals/or conditions.

from entityframework.dynamicfilters.

I've just tested with the latest abp zero module project, it runs smoothly now 👍

Indeed, it was related to "in" expression.
I'm just at the beginning of my project, i'll provide more info if there is any other issue with oracle.

Thanks for your help and your work ! :)
Have a great day !

from entityframework.dynamicfilters.