Tag: c#

  • 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 […]

  • Adventures in WCF (Windows Communication Foundation)

    My latest project at work has me working with WCF for the first time and it has been an interesting experience. Over the next few weeks, I will be discussing configuration, debugging, and deployment of the WCF service and connecting to it. Microsoft provides a few tools that can help debug your WCF services. WCF […]