Can't apply the library while using reflection emit with dynamic linq

[KhoiNguyenICT]

Hi!
Today, i use reflection emit for generate dynamic entity for entityframework.
But library cannot support type IQueryable for dynamic query
Can you give me a solution for this problem!
Thank you so much!

[JonathanMagnan]

Hello @KhoiNguyenICT ,

Could you provide a full example of what you would want to do.

It will help my developer to get started with your request as I'm not fully sure to understand it.

Best Regards,

Jon

---

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

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

[KhoiNguyenICT]

Hi @JonathanMagnan
This is example for my issue
In the line 132 to line 134 i try build dynamic entity from my setting
But in the line 135 i use dynamic linq for find item, but library not support query with IQueryable
This is class for job build dynamic type use reflection emit: Link
Thanks @JonathanMagnan

[JonathanMagnan]

Hello @KhoiNguyenICT ,

If you wish we try to find a solution, we will need a full runnable project that contains the minimum code to reproduce it.

[KhoiNguyenICT]

Hi @JonathanMagnan
This is example for use refection emit: Link https://github.com/giangcoi48k/test-assembly-emit
Thanks @JonathanMagnan

[JonathanMagnan]

Hello @KhoiNguyenICT ,

I tried a few examples with System.Linq.Dynamic.Core and Z.Expressions.Eval library and both are working as expected.

_dbContext.Add(obj);
_dbContext.SaveChanges();

var set = _dbContext.Set(type);
//var q2 = set.Where("Name == \"test\"");
//var q2 = set.WhereDynamic("x => x.Name == 'test'");
var q3 = set.SingleOrDefaultDynamic("x => x.Name == 'test'");
return Ok(_dbContext.Set(type));

Both libraries support IQueryable, so I'm not really sure how to reproduce this issue.

[JonathanMagnan]

Hello @KhoiNguyenICT

Since our last conversation, we haven't heard from you.

As mentioned in my previous message, both libraries support IQueryable.

Don't hesitate to provide further information, so that we can help you better.

Best regards,

Jon

[KhoiNguyenICT]

@JonathanMagnan
Thank you so much
I tryed for this. Expression had good for template

var record = _context.Set(type).SingleOrDefaultDynamic($"x => x.Id.Equals(@Id)", new { Id = id });

[KhoiNguyenICT]

@JonathanMagnan
But I have not figured out how to re-initialize runtime Type of ModuleBuilder when DefineType was successful before. Do you have any ideas for this problem?.
Thanks!

[JonathanMagnan]

Sorry @KhoiNguyenICT , I do not understand what you want.

[KhoiNguyenICT]

@JonathanMagnan
My problem has been solved.
Thank you so much!