Hi,
I am trying to filter data after query it from database. Something like this:
var data0 = await this._context.Set(typeof(Entity1)).Where("Id<10").ToDynamicArrayAsync(); //Works
var data1 = await this._context.Set(typeof(Entity1)).ToDynamicArrayAsync(); //Works
var data2 = data1.AsQueryable().Where("Id<10").FirstOrDefault(); //Doesn't work.but I get error:
One or more errors occurred. (Operator '<' incompatible with operand types 'Object' and 'Int32')
I also tried this:
var data0 = await this._context.Set(typeof(Entity1)).Where("Id<10").ToDynamicArrayAsync(); //Works
var data1 = await this._context.Set(typeof(Entity1)).ToDynamicArrayAsync(); //Works
var data2 = data1.AsQueryable().Where("Url=@0", "Test").FirstOrDefault(); //Doesn't work.but I get error:
One or more errors occurred. (Target object is not an ExpandoObject)
Am I doing something wrong, or is this not possible?
Here is also online demo.
Hi,
I am trying to filter data after query it from database. Something like this:
but I get error:
I also tried this:
but I get error:
Am I doing something wrong, or is this not possible?
Here is also online demo.