So I took them out for a test drive.
The installation was easy and painless so was connecting to a DB.
The only issue was using the MySQL connectors as a data provider in a SqlDataSource, the code generated by the system was MS SQL centric, but no biggie just take out all the "[" and "]" from your queries.
I haven't tried it out on LINQ yet, but will get to it.
It works just fine on my localhost and I've just deployed it on my own server for deployment testing.
If you don't want to install the connectors on the host, like usual you need to leave the dlls in the bin folder on your website.
In addition to that you need to change the web.config to do this.
<system.data>
<DbProviderFactories>
<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=5.2.2.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
</DbProviderFactories>
</system.data>
If the deployment still doesn't work db wise you might need to set the application to full trust instead of medium trust.
Remember to get the Version as in "Version=5.2.2.0" correct to your connector.
That's about it.
1 comment:
If you're keen on MySQL data access from .NET you could also check out LightSpeed - our .NET O/R Mapper with support for MySQL including LINQ capabilities.
You can also use the design surface for creating your models against MySQL if desired.
http://www.mindscape.co.nz/products/lightspeed/
Just to be clear, I do work for Mindscape but thought it might be of interest to you :-)
Appreciate any feedback you might have.
- JD
Post a Comment