Use timeout using CData ADO.NET Provider for SharePoint
Connection string
This CData ADO.NET Provider for SharePoint connection string can be used for connections to SharePoint.
URL=http://sharepointServerName/;User=myUsername;Password=myPassword;Timeout=60;
If an operation is not complete within the timeout value an exception is thrown.