Is it just me or is it a little bit strange that Webmatrix has support for connecting to and managing mysql databases while VVD express doesn't (due to limitation on 3rd party extensibility?) ?
is it a little bit strange that Webmatrix has support for connecting to and managing
mysql databases while VWD express doesn't (due to limitation on 3rd party extensibility?) ?
imho, no ... from ScottGu's introductory article*, i'm guessing that WebMatrix was designed
in part to keep web developers within the Microsoft universe:
WebMatrix is a task-focused tool that is designed to make it really easy to get started with web development. It minimizes the number of concepts someone needs to learn in order to get simple things done, and includes and integrates
all of the pieces necessary to quickly build Web sites.
If a project requires either SQL Express or MySQL as a database, and you don’t have them installed, they will show up in the dependencies list below, and WebMatrix will offer to automatically download, install, and configure them
for you.
PHP applications in the web gallery (like WordPress, Drupal, Joomla and SugarCRM – all of which are there) will download and install both PHP and MySQL.
In addition to supporting SQL CE, the WebMatrix database tools below also work against SQL Express, SQL Server, as well as with MySQL.
many articles seem to indicate that support in VWD takes is not as simple, yet not impossible, example:
The SQL Server Express database platform is based on SQL Server. It is also a replacement for Microsoft Desktop Engine (MSDE). Integrated with Visual Studio, SQL Server Express makes it easy to develop data-driven applications that
are rich in capability, secure in storage, and fast to deploy.
SQL Server Express is free and can be redistributed by ISVs (subject to agreement). SQL Server Express is ideal for learning and building desktop and small server applications. This edition is the best choice for
independent software vendors, non-professional developers, and hobbyists building client applications.
*** If you need more advanced database features,
SQL Server Express can be seamlessly upgraded to more sophisticated versions of SQL Server.
B-) Please help me by completing my school survey about computer programmers on my website. Thank you!!! Gerry Lowry +1 705-429-7550 wasaga beach, ontario, canada
I suppose your question on why MySQL over Express was somewhat rhetorical but I'll give my opinion and need. I like developing in Visual Studio and I like the streamlined experience which it provides when setting up a database and modeling entities using
Entity Framework.
Although SQL Exprees is a viable solution for many needs - one area where it seems lacking is in terms of web hosting, when looking at web hosters which support Windows there's usually only mysql included in the offering and MSSQL is an option due to cost
compared to MySQL. And SQl Express is as far as i know not recommended for shared web hosting.
SQL CE is good when developing but I'm not sure if it's the best option when going live with a site - so I kind of feel like VWD Express is great for the web-part of things but somewhat weaker in the database-part of things because there it doesn't seem
like there is anything in the SQL Family from MS which can be centrally hosted in shared intro web hosting scenarios.
In a very specific case I wanted to migrate from a legacy PHP+MySQL solution to MVC+MYSQL and yes it can probably be done manually but I was really hoping that since EF4 is "promoted" everywhere that it could be achieved using Express with the tooling support.
$4.99 for one SQL database up to 200MB (not very big but could work for many applications; they have other options ... my experience with 1&1 was not satisfactory, so i'm just giving it as an example of availability ... this is NOT a recommendation).
i'm sure there's more; there used to be a hosting sub-forum here at forums.asp.net ... looks like it's gone.
g.
B-) Please help me by completing my school survey about computer programmers on my website. Thank you!!! Gerry Lowry +1 705-429-7550 wasaga beach, ontario, canada
krustyfied
Member
7 Points
20 Posts
Server explorer limitation compared to Web Matrix
Feb 28, 2012 07:56 PM|LINK
Hi all,
Is it just me or is it a little bit strange that Webmatrix has support for connecting to and managing mysql databases while VVD express doesn't (due to limitation on 3rd party extensibility?) ?
gerrylowry
All-Star
20525 Points
5713 Posts
Re: Server explorer limitation compared to Web Matrix
Feb 29, 2012 03:04 AM|LINK
@ krustyfied
imho, no ... from ScottGu's introductory article*, i'm guessing that WebMatrix was designed in part to keep web developers within the Microsoft universe:
WebMatrix is a task-focused tool that is designed to make it really easy to get started with web development. It minimizes the number of concepts someone needs to learn in order to get simple things done, and includes and integrates all of the pieces necessary to quickly build Web sites.
* http://weblogs.asp.net/scottgu/archive/2010/07/06/introducing-webmatrix.aspx, also:
If a project requires either SQL Express or MySQL as a database, and you don’t have them installed, they will show up in the dependencies list below, and WebMatrix will offer to automatically download, install, and configure them for you.
PHP applications in the web gallery (like WordPress, Drupal, Joomla and SugarCRM – all of which are there) will download and install both PHP and MySQL.
In addition to supporting SQL CE, the WebMatrix database tools below also work against SQL Express, SQL Server, as well as with MySQL.
many articles seem to indicate that support in VWD takes is not as simple, yet not impossible, example:
http://stackoverflow.com/questions/6004401/how-do-i-connect-to-an-mysql-database-in-visual-web-developer-2010
Question: since you can use SQL Server Express**, why to you wish to use MySQL?
My best guess*** is that MS would prefer you to use SQL Express because of the upgrade path to SQL server.
** http://msdn.microsoft.com/en-us/library/ms144275.aspx
The SQL Server Express database platform is based on SQL Server. It is also a replacement for Microsoft Desktop Engine (MSDE). Integrated with Visual Studio, SQL Server Express makes it easy to develop data-driven applications that are rich in capability, secure in storage, and fast to deploy.
SQL Server Express is free and can be redistributed by ISVs (subject to agreement). SQL Server Express is ideal for learning and building desktop and small server applications. This edition is the best choice for independent software vendors, non-professional developers, and hobbyists building client applications.
*** If you need more advanced database features, SQL Server Express can be seamlessly upgraded to more sophisticated versions of SQL Server.
krustyfied
Member
7 Points
20 Posts
Re: Server explorer limitation compared to Web Matrix
Feb 29, 2012 08:07 AM|LINK
Hi Gerry,
I suppose your question on why MySQL over Express was somewhat rhetorical but I'll give my opinion and need. I like developing in Visual Studio and I like the streamlined experience which it provides when setting up a database and modeling entities using Entity Framework.
Although SQL Exprees is a viable solution for many needs - one area where it seems lacking is in terms of web hosting, when looking at web hosters which support Windows there's usually only mysql included in the offering and MSSQL is an option due to cost compared to MySQL. And SQl Express is as far as i know not recommended for shared web hosting.
SQL CE is good when developing but I'm not sure if it's the best option when going live with a site - so I kind of feel like VWD Express is great for the web-part of things but somewhat weaker in the database-part of things because there it doesn't seem like there is anything in the SQL Family from MS which can be centrally hosted in shared intro web hosting scenarios.
In a very specific case I wanted to migrate from a legacy PHP+MySQL solution to MVC+MYSQL and yes it can probably be done manually but I was really hoping that since EF4 is "promoted" everywhere that it could be achieved using Express with the tooling support.
gerrylowry
All-Star
20525 Points
5713 Posts
Re: Server explorer limitation compared to Web Matrix
Feb 29, 2012 04:40 PM|LINK
@ krustyfied
i went with corenetworks.net to have my own dedicated domain ... not that expensive, especially if one has friends to share in the cost.
however, some hosting providers offer SQL Express and/or SQL (it's not always clear which product) ...
examples: http://order.1and1.com/MsHosting?__lf=Static&linkOrigin=&linkId=hd.nav.hosting.windows
$4.99 for one SQL database up to 200MB (not very big but could work for many applications; they have other options ... my experience with 1&1 was not satisfactory, so i'm just giving it as an example of availability ... this is NOT a recommendation).
http://www.godaddy.com/hosting/web-hosting.aspx?ci=8971 ... also not a recommendation because i've never been a GoDaddy customer.
i'm sure there's more; there used to be a hosting sub-forum here at forums.asp.net ... looks like it's gone.
g.