DatabaseDataSet.StartConnect Method
Starts a connection to the database, without waiting for it to complete.
StartConnect()
Starts a connection to the database, without waiting for it to complete.Syntax
public void StartConnect ()Remarks
This method will start making a connection to the database server, but will not wait for it to complete. You can later on call Initialize or some other method that causes the dataset to be initialized; that call will wait until the connection is established (or fails).
This can be useful when you have multiple datasets connecting to databases, and each connection may take some time to complete. Instead of creating each connection and waiting for it to complete before starting the next, you can call this method on each of the datasets first. This way all datasets will connect in parallel, instead of serially, one after the other.
This also works together with the ConnectTimeout property. The timeout for each dataset connection will be counted from the time this method was called. So for example, if you have 10 datasets, all with a 10 second timeout, and your database server doesn't respond, calling this method first will make all of them time out after 10 seconds. Otherwise it could take 100 seconds before they all time out.
This only has effect for the initial connect. If the dataset is already connected, or have been connected but lost its connection, calls to this method will be ignored.
.
Example
// Make all database datasets connect to server in parallel. The configuration
// with the view should have been loaded with DataSetInitialization = Delayed
public static void ConnectDatabases(View view)
{
// Locate all database datasets, and start making connections. All connections
// will be done in parallel.
var allObjects = view.GetChildObjects();
foreach (EngineObject eo in allObjects)
{
var db = eo as DatabaseDataSet;
if (db != null)
db.StartConnect();
}
// Optional, wait for initialization to complete. Otherwise datasets will be initialized
// automatically when they are used.
foreach (EngineObject eo in allObjects)
{
var ds = eo as DataSet;
if (ds != null)
ds.Initialize();
}
}
Platforms
Windows, Linux, Android