Category: Microsoft Stack

  • ASP.NET MVC4 Project + SQL CE 4 limitations

    With the official RTM release of Visual Studio 2012 and the MVC 4 project (also available for VS 2010), I have been using some of the features of new features and out of the box features of hte MVC 4 project to ease the development of my user stories. SQL CE 4 made database backends […]

  • Deploying an ASP.NET Web Application with SQL CE 4 & Entity Framework without installation

    Update – 12/15/2011 As of Visual Studio 2010 SP1, there’s an easier way to do everything below. In the Solution Explorer, right click the project and select ‘Add Deployable Dependencies…’, select the dependencies you want to include, and click OK. This will generate the folderĀ _bin_deployableAssemblies with the proper DLLs. Now when you build your solution, […]

  • Template for SQL Server Stored Procedures

    Talking with our in house DBA, it was mentioned that DROP/CREATE is a bad model to follow when updating stored procedures. However, this is the model used in the stored procedure template provided by Visual Studio 2005/2010. Here is a modified template that creates an empty stored procedure if it doesn’t exist and performs an […]

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