Context.Set<T>().Find(keyValues) And Use Context.Filter<Interface>() after,

[dragonlus]

Context.Set().Find(keyValues) And Use Context.Filter() after,

from entityframework.dynamicfilters.

[dragonlus]

I use MiniProfiler trace the sql,like this:
first client_id =1, excute Context.Set.Find("201908021506517490038605f1cc986") the sql is :
SELECT
[Extent1].[modl_id] AS [modl_id],
[Extent1].[modl_type] AS [modl_type],
[Extent1].[modl_code] AS [modl_code],
[Extent1].[modl_name] AS [modl_name],
FROM [dbo].[Module] AS [Extent1]
WHERE ([Extent1].[client_id] = 1) AND modl_id='201908021506517490038605f1cc986'
when I changed client_id=2 ,excute Context.Set.Find("201908021506517490038605f1cc986") the sql still is：
SELECT
[Extent1].[modl_id] AS [modl_id],
[Extent1].[modl_type] AS [modl_type],
[Extent1].[modl_code] AS [modl_code],
[Extent1].[modl_name] AS [modl_name],
FROM [dbo].[Module] AS [Extent1]
WHERE ([Extent1].[client_id] = 1) AND modl_id='201908021506517490038605f1cc986'
I excute Context.Set().take(1).ToList(),the sql is:
SELECT
[Extent1].[modl_id] AS [modl_id],
[Extent1].[modl_type] AS [modl_type],
[Extent1].[modl_code] AS [modl_code],
[Extent1].[modl_name] AS [modl_name],
FROM [dbo].[Module] AS [Extent1]
WHERE ([Extent1].[client_id] = 2) AND modl_id='201908021506517490038605f1cc986'
why？

[dragonlus]

I use EntityFramework 6.2.0
Z.EntityFramework.Plus.EF6 1.8.21

[JonathanMagnan]

Hello @dragonlus ,

Do you think you could provide a project sample with this issue?

It will help my developer investigate the issue more efficiently.

We now always ask for a project sample even if the issue is easy to reproduce. As a free product, we must find some way to save time to offer an overall better experience for everyone and release fixes faster.

You can send it to: [email protected] if you need to keep the source private

Best Regards,

Jonathan

---

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