DAAB SPs w/ or w/o dbo. prefix

Topics: Data Access Application Block
Jul 6, 2007 at 3:35 PM
Is there a performance gain (albeit slight) when calling an SP with the dbo. prefix than without? I know that good coding practices inside of SPs gives you a performance gain when accessing tables and SPs using the dbo prefix but I haven't seen the practice referenced in the App Block samples that I have looked at and thought I would ask. (Sample below)

private Database mdDatabase = null;
DbCommand dcRetrieveCmd = null;
mdDatabase = DataFactory.CreateDatabase();

//Does this line execute slower
dcRetrieveCmd = mdDatabase.GetStoredProcCommand("AcceptContract");

//Than this line with the 'dbo.' prefixed to the SP name when executed against the DB?
dcRetrieveCmd = mdDatabase.GetStoredProcCommand("dbo.AcceptContract");
Jul 6, 2007 at 4:18 PM
Hi,

This is really an ADO.NET question, so you'll probably be more successful asking on the .NET Data Access forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=45&SiteID=1.

Regards,
Fernando