Linqpad 5 Slow execution - AsNoTracking

xebedy · April 2023

Hi,

when running a very simple entity frameworks query it takes between 2.4 and 3 seconds to execute and paint the results, I'm trying to use AsNoTracking() but even if I add the namespace for it to the query (System.Data.Entity) the method isn't available.

Simple query:

var test = (from es in TABLEX
where es.PROPERTYX == 1000
select es).AsNoTracking().FirstOrDefault();

test.Dump();

In the above example it doesn't recognise .AsNoTracking()

I can't see what I'm doing wrong?

Thanks in advance.