changed dbconnection to use properties.