ASP.NEt with MySQL?

[c0smic]

Hey i need some advise:

I have been migrating more towards .NET just to really get an idea of the new capabilities it offers, as I have been coding in PHP up till now. My question is, can anyone tell me how efficient MySQL runs with ASP.NET vs access? I really prefer to use MySQL with the ado connections, but im wondering if Access might run smoother being that it interfaces so easily with .NET (obviously). I really want to stay away from access if i can. Just hoping to get some different opinions.

 

[HJB417]

i've used both access and mysql for .net. Mysql is great, but the only thing I hate about it is their odbc driver doesn't support named parameters. I'd make my own .net data provider if their network protocol was documented.

access is good too, but remember, it's a file database and no remote connections.

 

[UCJefe]

Access doesn't run well with anything.

But yeah, you'll be stuck with the generic ODBC driver for MySQL. I'm surprised nobody has written a data provider for MySQL yet. Reverse enginering network protocols can be fun!!

 

[RZaakir]

You'd think that reverse engineering wouldn't be necessary since MySQL is open source.

If you really want to leverage the power of .NET use SQL Server or MSDE. Access and MySQL are practically toys compared to them.

 

[drag]

You mean MS SQL Server?

And Access should be avoided for everything and anything.

And if you want to move up from PHP, check out Python and Zope. They have capabilities that only recently ASP.NEt have aquired... Lots of community support and lots of prototype applications and code you can use for free.

Generally Microsoft stuff only works with other Microsoft stuff....

But if you want a free SQL server don't forget about PostgreSQL, people generally regard it to be much more "professional" then mysql.

 

[torpid]

http://sourceforge.net/projects/mysqlnet/