Issue occur when dynamic filter is applied on eager loading with many-to-many relationship entities for MySQL

[Sankartest]

Issue occur when dynamic filter is applied on eager loading with many-to-many relationship entities for MySQL

[Sankartest]

It will be really helpful if we get a solution for this issue. We are eagerly looking forward for your reply.

[JonathanMagnan]

Hello @Sankartest ,

My developer will try to reproduce the issue with your code.

Best Regards,

Jon

---

Sponsorship
Help us improve this library

Performance Libraries
context.BulkInsert(list, options => options.BatchSize = 1000);
Entity Framework Extensions • Bulk Operations • Dapper Plus

Runtime Evaluation
Eval.Execute("x + y", new {x = 1, y = 2}); // return 3
C# Eval Function • SQL Eval Function

[rshaiju]

I have also seen the same issue in my project. It has been working perfectly with SQL Server but is pretty much unusable with MySQL due to this.

[Sankartest]

@JonathanMagnan ,

It would be helpful if we get any update on this.

Thanks
Sankar S

[rshaiju]

I see the error vanish on commenting out the following lines in DynamicFilterQueryVisitorCSpace

[JonathanMagnan]

Thank you @rshaiju ,

We will add an option that will remove those lines if we find out that it makes sense. Not sure how we will name it but at least it will apply your fix and maybe some other fix you find without impacting other people.

[rshaiju]

Sorry. Please keep this open for now. It worked in my POC project but gave the same Unable to cast object of type 'MySql.Data.Entity.SelectStatement' to type 'MySql.Data.Entity.LiteralFragment' with in my real application. still investigating...

[JonathanMagnan]

Sure, we will wait for you