DAAB - Adjust Connection Properties

Topics: Data Access Application Block
May 26, 2008 at 12:52 PM
Hi, i have a small data access layer based on DAAB for small applications, my primary sql backend is Informix, i need to set for all connections to the backend connection attributes, the isolation level, the lock mode, optimization parameters, etc. all of this can be done with sending SQL sentences but where ?

My layer ends using code like this:

Database db = new GenericDatabase(GetConnString(), OdbcFactory.Instance);

db.ExecuteScalar(CommandType.Text, sql)

How can i make changes to properties of the connection that Database.Execute...  uses ?
How can i preconfigure the each connection that DAAB makes ?