+1  A: 

Use the app.config (or web.config) file to add a entry. Be sure the specify the provider= attribute correctly with the MySQL provider.

Eric Falsken
do you know exactly how that might be done?
Ben McCormack
Here is an example for JET: http://msdn.microsoft.com/en-us/library/ms243192.aspx
Henk Holterman
+1  A: 

There is no support for third-party extensions in Visual C# 2008 Express Edition SP1.

This is mentioned in this blog post by Dan Fernandez.

More information about the difference between Express and Professional editions is available here in the Visual Studio 2008 Product Comparison article.

Devart
Does the MySQL ADO.NET Connector constitute a 3rd party extension? I think it's just a series of assemblies in the Global Assembly Cache when installed, but perhaps I'm incorrect.
Ben McCormack
Apparently the MySQL Connector does in fact install "Visual Studio Integration" when it is installed. I suppose that keeps MySQL from showing up in the Database explorer. Is there no way to set it up manually without going through all of the dialog boxes then?
Ben McCormack
Visual C# 2008 Express Edition does not allow even to create a design-time connection to the MS SQL Server instance. This is a limitation of a free product. <br />So, neither MySQL ADO.NET Connector/NET, nor Devart dotConnect for MySQL cannot be used in design time in bundle with the Express version. <br />You can try to work around the situation - try the console tool like <a href="http://msdn.microsoft.com/en-us/library/bb387165.aspx">EdmGen</a> or <a href="http://code.msdn.microsoft.com/EdmGen2">EdmGen2</a>
Devart
correct links: http://msdn.microsoft.com/en-us/library/bb387165.aspxand http://code.msdn.microsoft.com/EdmGen2
Devart