Showing posts with label Visual Web Developer 2010 Express. Show all posts
Showing posts with label Visual Web Developer 2010 Express. Show all posts

Friday, 9 March 2012

VWD + ASP.NET + MySql + parameterized queries

As you'll know, MS-SQL-Server uses parameter names beginning with '@' in parameterized queries, whilst MySql uses a single '?' for each parameter.

Whilst struggling to get Visual Web Designer 2010 Express to recognise parameterized MySql queries, I hit on the following technique:

VWD 2010 Express + MySql Connector/Net

Anyone trying to link the MySql Connector/Net connector into an ASP.NET site using the (free) Visual Web Developer 2010 Express?

Well, I found out the hard way that it is not compatible. Installed the Connector/ODBC version, and I was able to connect successfully.

From dev.mysql.com: "Note that MySQL Connector/Net does not currently support Express versions of Microsoft products, including Microsoft Visual Web Developer."