Tag: Enterprise Library

  • Enterprise Library Data Access Application Block + SQL Optional Parameters

    The Enterprise Library Data Access Block provides a number of ways of calling a stored procedure. Database _db = DatabaseFactory.CreateDatabase(<Connection String Name>); Let’s now assume that we have a stored procedure usp_MyStoredProc that takes a single parameter @param1. If this is a require parameter, both of the following statement blocks will result in the same […]