Visual Studio 2012 MySql Data Source - MySql .Net Provider

Visual Studio 2012
.Net Framework 4.5


1. Download the link. (If link does not work, download mysql connector version 6.6.7 from oracle)

http://cdn.mysql.com/Downloads/Connector-Net/mysql-connector-net-6.6.7.msi

alternate: http://dev.mysql.com/downloads/connector/net/1.0.html
important: select 6.6.7

2. Restart computer.

Visual Studio Find Text in String RegEx

(("[^"]*[ ]|")entities([ ][^"]*"|"))

Visual Studio Supported Project Type Guid List

Reference from http://shobhap.wordpress.com/2010/10/09/the-project-type-is-not-supported-by-this-installation/

I copy and Paste from

Shobha's Blog

When we open some visual studio and we get the error : project type is not supported.
Solution :
1. Open the .csproj file in edit mode.
2. Look for .
3. Based on this GUID you can find which template this project is created .
4. Install the required template and project will be opened without any error.

Table of GUIDs of project type.

Project Type Description	Project Type Guid
Windows (C#)	{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}
Windows (VB.NET)	{F184B08F-C81C-45F6-A57F-5ABD9991F28F}
Windows (Visual C++)	{8BC9CEB8-8B4A-11D0-8D11-00A0C91BC942}
Web Application	{349C5851-65DF-11DA-9384-00065B846F21}
Web Site	{E24C65DC-7377-472B-9ABA-BC803B73C61A}
Distributed System	{F135691A-BF7E-435D-8960-F99683D2D49C}
Windows Communication Foundation (WCF)	{3D9AD99F-2412-4246-B90B-4EAA41C64699}
Windows Presentation Foundation (WPF)	{60DC8134-EBA5-43B8-BCC9-BB4BC16C2548}
Visual Database Tools	{C252FEB5-A946-4202-B1D4-9916A0590387}
Database	{A9ACE9BB-CECE-4E62-9AA4-C7E7C5BD2124}
Database (other project types)	{4F174C21-8C12-11D0-8340-0000F80270F8}
Test	{3AC096D0-A1C2-E12C-1390-A8335801FDAB}
Legacy (2003) Smart Device (C#)	{20D4826A-C6FA-45DB-90F4-C717570B9F32}
Legacy (2003) Smart Device (VB.NET)	{CB4CE8C6-1BDB-4DC7-A4D3-65A1999772F8}
Smart Device (C#)	{4D628B5B-2FBC-4AA6-8C16-197242AEB884}
Smart Device (VB.NET)	{68B1623D-7FB9-47D8-8664-7ECEA3297D4F}
Workflow (C#)	{14822709-B5A1-4724-98CA-57A101D1B079}
Workflow (VB.NET)	{D59BE175-2ED0-4C54-BE3D-CDAA9F3214C8}
Deployment Merge Module	{06A35CCD-C46D-44D5-987B-CF40FF872267}
Deployment Cab	{3EA9E505-35AC-4774-B492-AD1749C4943A}
Deployment Setup	{978C614F-708E-4E1A-B201-565925725DBA}
Deployment Smart Device Cab	{AB322303-2255-48EF-A496-5904EB18DA55}
Visual Studio Tools for Applications (VSTA)	{A860303F-1F3F-4691-B57E-529FC101A107}
Visual Studio Tools for Office (VSTO)	{BAA0C2D2-18E2-41B9-852F-F413020CAA33}
SharePoint Workflow	{F8810EC1-6754-47FC-A15F-DFABD2E3FA90}
XNA (Windows)	{6D335F3A-9D43-41b4-9D22-F6F17C4BE596}
XNA (XBox)	{2DF5C3F4-5A5F-47a9-8E94-23B4456F55E2}
XNA (Zune)	{D399B71A-8929-442a-A9AC-8BEC78BB2433}
SharePoint (VB.NET)	{EC05E597-79D4-47f3-ADA0-324C4F7C7484}
SharePoint (C#)	{593B0543-81F6-4436-BA1E-4747859CAAE2}
Silverlight	{A1591282-1198-4647-A2B1-27E5FF5F6F3B}

Step by Step installation PHP Tools for Visual Studio and xdebug for windows

1. download "php tools for visual studio" or use Tools->Extensions and Updates

2. install extension

3. download php from http://windows.php.net/download/  ... for iis use non thread safe version

4. unzip and move folder to C:\Program Files (x86)\

5. rename folder as PHP

5.1 find php.ini-developemnt and rename php.ini. (remove -development)

6. run below commands


"C:\Program Files (x86)\IIS Express\appcmd.exe" set config /section:system.webServer/fastCGI /+[fullPath='"C:\Program Files (x86)\PHP\php-cgi.exe"']

"C:\Program Files (x86)\IIS Express\appcmd.exe" set config /section:system.webServer/handlers /+[name='PHP_via_FastCGI',path='*.php',verb='*',modules='FastCgiModule',scriptProcessor='"C:\Program Files (x86)\PHP\php-cgi.exe"',resourceType='Unspecified']


7. open visual studio, Tools->options->PHP Tools->Intepreter->Register New PHP Path

8. select  C:\Program Files (x86)\PHP folder and set php executable

9. go to site http://xdebug.org/download.php

10. download xdebug dll according to php version

11. open php.ini file and paste above code

xdebug.remote_enable=1
xdebug.remote_host=”localhost”
xdebug.remote_port=9000
xdebug.remote_handler=”dbgp”
zend_extension = C:\Program Files (x86)\PHP\ext\php_xdebug-<replace with correct version>.dll

12. hit F5

Enable-Migrations Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

1. if you are using Code First
2. if your DBContext class is in another library and it still references the older v4.1 DLL, you will get the the error. Just check to make sure everything references the same version. Check your all dll's that reference the same entityframework.dll 5.0.0

Prevent Visual Studio Toolbox Installer Package

8 Steps to prevent the visual studio toolbox loading items over and over again on init.

1. Close Visual Studio 2010
2. Go to   %USERPROFILE%\AppData\Local\Microsoft\VisualStudio\10.0
3. Delete all .tbd files
4. Open regedit
5. Find  HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\VisualStudio\10.0\Packages\{2c298b35-07da-45f1-96a3-be55d91c8d7a}\Toolbox
6. Update  "Default Items" value 1 to 0 (prevents the toolbox loading the items on init)
7. Start Visual Studio.
8. Reset the toolbox if needed.