Visual Studio

SQL71501: User has an unresolved reference to Login in Visual Studio 2012 Database Project

If you create application specific logins (which you should) then you are going to come across this error when trying to build your solution. UPDATE: 15th May 2013 - Jim commented a fix for this - "I have resolved this, it's quite simple to add the logins. You have

Visual Studio

Custom HttpHandler returns 404 after migrating to Vs2012

After migrating an asp.net web forms app to visual studio 2012 we started to observe some odd behaviour. The custom http handler used across the site to render images was returning a 404. The framework version had not been changed, nor had any configuration been updated. I decided to

Visual Studio

Working with Visual Studio Database Projects

Visual Studio keeps a SQL file for each and every object in the database, and it can be cumbersome to have to maintain these manually, especially when working with tables. A more productive process is to have visual studio create a database locally for you, make your modifications in SQL

Visual Studio

Visual Studio 2012 - Generating SQL Data Inserts

Want to generate insert statements for a set of data in a SQL Server table? Open the table, and click the single script button... and out pops a batch of inserts, complete with IDENTITY_INSERT statements…

Visual Studio

Dont forget to manually delete your bin directory after changing namespaces in an asp.net project

If you change the default application name on the web tab of the project properties in your asp.net project, and you have previously compiled your project, you may find some strange errors when you next build your project. This is because the dll names that the build outputs in

Visual Studio

Unable to find the requested .Net Framework Data Provider. It may not be installed

This usually means that a provider specified in one of your web.config connection strings is not installed on your machine. In my specific case the offender was this… <add name="MyContext" connectionString="Data Source=|DataDirectory|myDatabase.sdf" providerName="System.Data.SqlServerCe.4.0&