You will have to specify the command time out period explicitly for the SPs running for long time.
Use below code to build the connection and run a stored proc.
CallStoredProcedure.xaml (10.6 KB)
2 Likes