Devart Forums

How TMSConnection's DisconnectedMode works?

How to check that it works from management studio process explorer? Should i see some users not online?

Why do you say

it may be useful for [...] operating in an unstable or expensive network

?

from https://www.devart.com/sdac/docs/work_d ... ctmode.htm

In disconnected mode a connection is opened for executing requests to the server (if it was not opened already) and is closed automatically if it is not required any more. If the connection was explicitly opened (the Connect method was called or the Connected property was explicitly set to True), it does not close until the Disonnect method is called or the Connected property is set to False explicitly. Therefore, in order for disconnected mode to correctly work, software connection to the server is not required.

Yes, you can check which users are active in Management Studio, for example, by calling the sp_who procedure. If you use disconnected mode, then only active sessions should be displayed in the user list.