<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">From the Web Platform Installer 3.0, I'm assuming that I would download MySQL Windows 5.1 and MySQL Connector/Net 6.2.3
correct? </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Then I will be able to use MySQL instead of SQL Management Studio? on SQL Server 2008?</div>
From the Web Platform Installer 3.0, I'm assuming that I would Add MySQL Windows 5.1 and MySQL Connector/Net 6.2.3 correct?
Then I will be able to use MySQL instead of SQL Management Studio on SQL Server 2008? I'm not exactly sure what windows database system I will be replacing if I use MySQL.
Is this how I would set it up though? and do most people use MySQL with ASP.NET?
I recommend sql workbench over heidisql. Also, you can use ado.net entity models and never write a line of sql. Instead you use linq. Pretty awesome and seamless. Also, mysql hosting is less and expensive and amazon rds is cloud based with sizes up to a terabyte.
Cloud hosted MySql. There are tiered levels for growth. The main thing here is that Amazon handles the setup, backups, etc. There are options for setting the the data center region or multi-region. Basically, if you use an ORM then this takes most of
the DBA work off your plate.
jackryder
Member
6 Points
8 Posts
Setting up MySQL with ASP.NET?
Feb 14, 2011 12:53 PM|LINK
From the Web Platform Installer 3.0, I'm assuming that I would Add MySQL Windows 5.1 and MySQL Connector/Net 6.2.3 correct?
Then I will be able to use MySQL instead of SQL Management Studio on SQL Server 2008? I'm not exactly sure what windows database system I will be replacing if I use MySQL.
Is this how I would set it up though? and do most people use MySQL with ASP.NET?
Any advice would be greatly appreciated.
Thanks
Rajneesh Ver...
All-Star
36791 Points
6749 Posts
Re: Setting up MySQL with ASP.NET?
Feb 14, 2011 01:19 PM|LINK
Yes its right way also you can use MysqlYog (a third party software) to run queries and be able to use mysql as mssql.
I think no! most of ASP.NET developers uses MS Sql only.
www.rajneeshverma.com
Keep Forums Clean || Use Alert Moderators.
er.tushar
Member
366 Points
87 Posts
Re: Setting up MySQL with ASP.NET?
Feb 15, 2011 03:01 AM|LINK
Hi,
You can use either MySql Workbench (similar to MS SQL Server Management Studio) or a web admin tool like phpMyAdmin.
Few people use MySql with ASP.NET. Majority of them use SQL Server along with ASP.NET
Tushar
HRStop.com - A web based hosted HR Management System.
Beejak.com - A web based hosted Online Invoicing and Billing Software
wreck_of_u
Member
224 Points
119 Posts
Re: Setting up MySQL with ASP.NET?
Feb 15, 2011 07:12 AM|LINK
With MySQL Connector/NET 6.xx and MySQL 5 and above, it's just as easy to use MySQL with ASP.NET just like MS SQL Server.
If you're used to MS SQL Server + Management Studio, you can use:
MySQL + HeidiSQL (they're both free)
With MySQL Connector/NET 6.xx + MySQL 5, you can use ASP.NET SQLDataSource the way you use it with MS SQL Server.
I am using MySQL with ASP.NET out of necessity. The database in my office is MySQL and I'm an ASP.NET programmer.
MySql Connector/Net
tmessbauer
Member
595 Points
209 Posts
Re: Setting up MySQL with ASP.NET?
Feb 16, 2011 07:18 AM|LINK
Technical architect
Rajneesh Ver...
All-Star
36791 Points
6749 Posts
Re: Setting up MySQL with ASP.NET?
Feb 16, 2011 07:25 AM|LINK
Hi, tmessbauer
can you give more idea about this.......
www.rajneeshverma.com
Keep Forums Clean || Use Alert Moderators.
tmessbauer
Member
595 Points
209 Posts
Re: Setting up MySQL with ASP.NET?
Feb 16, 2011 02:40 PM|LINK
Cloud hosted MySql. There are tiered levels for growth. The main thing here is that Amazon handles the setup, backups, etc. There are options for setting the the data center region or multi-region. Basically, if you use an ORM then this takes most of the DBA work off your plate.
http://aws.amazon.com/rds/
Technical architect