SqlServer Schemas with StoredProcs

Topics: Data Access Application Block, Exception Handling Application Block, General discussion, Logging Application Block
May 18, 2010 at 12:04 PM

Does EnterpriseLibrary 4.1 support Sql Server 2005 Schemas other than dbo? I would like to set up an Exceptions schema and have all of the associated tables and stored procs owned by Exceptions instead of dbo. Thanks in advance for any ideas and/or suggestions!

May 19, 2010 at 2:14 AM

Yes, because DAAB is a wrapper for ADO.NET and ADO.NET can work on other schemas.

 

Sarah Urmeneta
Global Technology & Solutions
Avanade, Inc.
entlib.support@Avanade.com

May 19, 2010 at 11:41 AM
Edited May 19, 2010 at 12:44 PM

Thank you Sarah. For the benefit of others, just prefix the stored proc names with the schema name (eg WriteLogStoredProcedureName can be set to YourSchamaName.YourStoredProcName). Where do you go to suggest that a little blurb about referencing non dbo schemas be added to the documentation?

May 20, 2010 at 1:15 AM

In the Issue Tracker, that's where you can log bugs and feature request.  Probably because that's how you will do it in ADO.NET and not something special you need to do in DAAB so it wasn't mentioned in the documentation. 

 

Sarah Urmeneta
Global Technology & Solutions
Avanade, Inc.
entlib.support@Avanade.com