mysql linq 查询超时,使用LINQ to SQL时避免连接超时的最佳实践

最新推荐文章于 2021-02-01 05:20:30 发布

weixin_32093519

最新推荐文章于 2021-02-01 05:20:30 发布

阅读量107

点赞数

文章标签： mysql linq 查询超时

i need to know best practice for avoid connection timeout when using LINQ to SQL in .net applications specially when returning IQueryablefrom data access tiers or layers.

I get "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached." error when testing my asp.net application for webstress tests

解决方案

Link will explain you what will be the reason of Timeouut using LINQ to SQl.You can manually increase the query execution time.By default its 30 sec.

According to Visual studio 2008 Go to

Tools->Database Tools->Query & view

design

Here you will get the option to increase the execution time.

Hope it helps you.

Good Luck