Topics: Data Access Application Block
Jun 15, 2010 at 2:44 PM


In our Oracle environment we access the data via views that have been assigned to roles.  So when we open a connection, we must then issue a SQL statement that assigns the role (dba will not automatically assign roles to the user id when logging in).  Instead of issuing a SQL statement to set the role, is there any way to set the using the Enterprise Library?



Jun 16, 2010 at 2:13 AM

You mean other than executing a DbCommand?  No, there isn't.  Keep in mind that DAAB is just a wrapper of ADO.NET; it can only support what the underlying database providers can support.


Sarah Urmeneta
Global Technology and Solutions
Avanade, Inc.