MySQL for Visual Studio provides access to MySQL objects and data without forcing your developers to leave Visual Studio. Designed and developed as a Visual Studio package, MySQL for Visual Studio integrates directly into Server Explorer providing a seamless experience for setting up new connections and working with database objects.
Design Time Support
MySQL for Visual Studio integrates directly into Visual Studio 2008, 2010, and 2012. Database objects (tables, views, stored routines, triggers, indexes, etc) can be created, altered, or dropped directly inside Server Explorer.
Visual object editors are available complete with help to guide you through the editing process. Standard data views are also available to help you view your data.
Visual Studio’s query design tool is also directly supported. With this tool, users can query and view data from their tables or views while also combining filters, group conditions, and parameters. Stored routines (both with and without parameters) can also be queried.
Stored Routine Debugging
MySQL for Visual Studio allows full debugging of stored routines. Using the environment and controls you are already familiar with you can set breakpoints, add watches, and step into, out of, and over routines and calls. Local variables can be added to the watch window and call stack navigation is also supported. Debugging is started simply by selecting the routine in Server Explorer and choosing Debug from the popup menu.
MySQL for Visual Studio also provides full support for Entity Framework allowing for templated based code generation as well as full support of the model designers and wizards