As Ryan mentioned in his post, SalesLogix offers the IDataService class that allows you to retrieve information about the underlying data connection. The class also allows you to fetch a connection to the underlying data source as well and then execute commands directly to the data source rather than going through the provider.
I wanted to talk about the attributes you can retrieve from the IDataService. There are four properties you can retrieve. These include:
- VenderVersion (Even though misspelled but this is the correct property)
Each of these attributes can be accessed the same way, by instantiating the IDataService object and then calling the property, like so:
Sage.Platform.Data.IDataService datasvc = Sage.Platform.Application.ApplicationContext.Current.Services.Get<Sage.Platform.Data.IDataService>() as Sage.Platform.Data.IDataService;
string alias = datasvc.Alias;
string server = datasvc.Server;
string version = datasvc.VenderVersion;
string db = datasvc.Database;
throw new Sage.Platform.Application.ValidationException(“Alias: ” + alias + “<br> Server: ” + server + “<br> DB: ” + db + “<br> Version: ” + version);
This returns the following type of information:
In addition to the above described properties (which all exist in 7.5.2) SalesLogix 7.5.3 also introduces the property “Port”.