This question is locked. New answers and comments are not allowed.
Hi,
i have created a database schema in my Mysql database.
Now I want get the classes from that database. So I create a new data access class library.
I logged into my database and select the schema. On the next screen where I can select the tables i got an error:
Could not load file or assembly 'MySql.Data, Version=6.6.6.0,...'
I have installed the latest .Net MySqlConnector. Added the dll manually to my project and added it via NuGet.
I use C# and wpf in my app.config I have:
Is it possible to reference the newer version of mysql.data.dll?
Regards Markus
i have created a database schema in my Mysql database.
Now I want get the classes from that database. So I create a new data access class library.
I logged into my database and select the schema. On the next screen where I can select the tables i got an error:
Could not load file or assembly 'MySql.Data, Version=6.6.6.0,...'
I have installed the latest .Net MySqlConnector. Added the dll manually to my project and added it via NuGet.
I use C# and wpf in my app.config I have:
<system.data> <DbProviderFactories> <remove invariant="MySql.Data.MySqlClient" /> <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" /> </DbProviderFactories> </system.data>Is it possible to reference the newer version of mysql.data.dll?
Regards Markus
6 Answers, 1 is accepted
0
Hi Markus,
Based on the provided information I was trying to reproduce the reported behavior. Though without being able to do so.
Can you please check if you have the respective DbProviderFactories entry in your machine.config? This is needed when using the Visual Designer to obtain the schema information.
During runtime you can nevertheless use the version provided via the nuget package.
I hope this information is helpful for you.
Do not hesitate to contact us again in case you have any other question.
Regards,
Ralph Waldenmaier
Telerik
Based on the provided information I was trying to reproduce the reported behavior. Though without being able to do so.
Can you please check if you have the respective DbProviderFactories entry in your machine.config? This is needed when using the Visual Designer to obtain the schema information.
During runtime you can nevertheless use the version provided via the nuget package.
I hope this information is helpful for you.
Do not hesitate to contact us again in case you have any other question.
Regards,
Ralph Waldenmaier
Telerik
OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
0
Jon
Top achievements
Rank 1
Rank 1
answered on 21 Dec 2014, 11:26 AM
I have this in my machine.config:
but i encounter the same problem.
<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />but i encounter the same problem.
0
Hello Jon,
Can you please provide more details about your setup?
- What Visual Studio are you using?
- What version of Telerik Data Access are you using?
- What MySQL drivers are installed on your system?
- What did you do to receive an error?
I am looking forward to hearing from you and getting this solved with you.
Regards,
Ralph Waldenmaier
Telerik
Can you please provide more details about your setup?
- What Visual Studio are you using?
- What version of Telerik Data Access are you using?
- What MySQL drivers are installed on your system?
- What did you do to receive an error?
I am looking forward to hearing from you and getting this solved with you.
Regards,
Ralph Waldenmaier
Telerik
OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
0
Jon
Top achievements
Rank 1
Rank 1
answered on 23 Dec 2014, 04:05 PM
Latest version of Visual Studio 2013 community edition
Latest Telerik DA
Latest Mysql 64bit for Win
I try to setup a new Domain Model.
Latest Telerik DA
Latest Mysql 64bit for Win
I try to setup a new Domain Model.
0
Hello Jon,
Thank you for the additional information.
On our side, we setup a machine that corresponds to the provided description, and tested the creation of a new domain model. During this process we created a video with the result. You can find it attached to the post. The outcome is that the model was successfully generated, without any errors. Does the video demonstrate something different than the workflow you do? I there a chance that Visual Studio 2013 Community was installed after the driver was installed (if so, you may need to re-run the installer on your side)?
I am looking forward to your feedback.
Regards,
Doroteya
Telerik
Thank you for the additional information.
On our side, we setup a machine that corresponds to the provided description, and tested the creation of a new domain model. During this process we created a video with the result. You can find it attached to the post. The outcome is that the model was successfully generated, without any errors. Does the video demonstrate something different than the workflow you do? I there a chance that Visual Studio 2013 Community was installed after the driver was installed (if so, you may need to re-run the installer on your side)?
I am looking forward to your feedback.
Regards,
Doroteya
Telerik
OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
0
Klemens
Top achievements
Rank 1
Rank 1
answered on 11 Feb 2015, 10:23 AM
Hi,
after I have added:
to the machine.config file I reinstalled the MySql .Net Provider and now everything is alright.
Regards Markus
after I have added:
<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />to the machine.config file I reinstalled the MySql .Net Provider and now everything is alright.
Regards Markus