Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
3.1k views
in Technique[技术] by (71.8m points)

c# - EntityFramework taking a long time to run select

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

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.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...