c# - EntityFramework taking a long time to run select

Question

I have a WPF desktop app that uses Entity framework (code first) to connect and store data on SQL Server.

When ever I try to select my objects from the context, it takes an extremely long time to load, about 2 to 5 minutes. Even for cases where I am selecting just 1 item using the ID.

When I run the SQL query on it's own, it only takes about 10-50ms.

I've tried checking the answers in the other similar threads and also tried to create Model cache but it still doesn't seem to make any difference.

    "<add name="LocalDB" connectionString="Data Source= 
   (LocalDB)MSSQLLocalDB;Initial Catalog=IdentityManagerDB;Integrated 
    Security=True"
    providerName="System.Data.SqlClient" />"

containers = await context.Containers.Where(c => !c.IsClosed )

In this object, IsClosed is just a bool.

Any help with this would be much appreciated

Answer 1

Likely your problem is related to fetching a special field and most likely a string filed!

I suggest you to fetch data column by column and compare the time.