Connection to SalesLogix DB Without Hard Coding Connection String

Question: I would like to open a connection to the SalesLogix database without hard coding the connection string. Can I somehow get a connection string to the SalesLogix database currently being used in the web client?

Answer: Yes. Use the DataService to get the current connection string or a connection object:

Sage.Platform.Data.IDataService dataService = 
      Sage.Platform.Application.ApplicationContext.Current.Services.Get<Sage.Platform.Data.IDataService>();
 
// get the connection string
string connectionString = dataService.GetConnectionString();

// or get a connection
System.Data.OleDb.OleDbConnection conn = dataService.GetConnection();