Nettiers Connection Timeout Issue - After a while - How do i debug this ?

    I've been using nettiers for a while now. Recently i started using entity datasource controls.
Now when i quickly update/edit data from a formview, after a while i see the dreadful - timeout exception. I can replicate it very easily.

"Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding"

I noticed in profiler - after some calls the connection is not closed. Is this possible - i mean all calls go through the Ent Lib DAB ... i doubt it ... but i am stumped!


If i go on slowly through debugger i dont see this error ... maybe the overloaded SQL DB frees up some connections itself ?

I cant replicate this error with the Generated admin controls ... any pointers on debugging this issue... ?

Do you have the EntityTransactionModule configured in your web.config?  If not, take a look at this post:

http://community.codesmithtools.com/forums/thread/12406.aspx

This entry is included if you are using the GenerateWebsite option.

Hope that helps.

    Worked like a treat! You rock!

    If you have time can you explain what that actually did ?

By default, the entity data source controls are configured to use the EntityTransactionModule to help manage and bind a single TransactionManager object for the duration of each page request.  The error you were receiving was caused by the transaction being left open since the EntityTransactionModule was not in place to close it.

If you need to override this behavior, you can set EnableTransaction="false" on your data source control, and optionally you can set the TransactionManager property as well.

Hope that helps.