Giveaways, Technology, Smartphones, Programming and Internet


How to fix the The given key was not present in the dictionary Error

I was just trying to write a tool which can port the BlogEngine blog platform posts to the famous wordpress using C#. As the wordpress is using MySql as the database I used MySqlConnection for the database connectivity. While trying to fetch a value I got the following error

“The given key was not present in the dictionary”

How to fix the The given key was not present in the dictionary Error

The reason for this error was the mysql.data.dll used was an old version. To fix this error what you will have to do is download the latest dll and use it.

1. Visit this link - https://dev.mysql.com/downloads/connector/net/

2. Select .NET &Mono

3. Click download

4. Extract the zip file and copy the mysql.data.dll  to the bin folder or add a new reference using this dll

You will need to login to my oracle web account, if you do not have an account, create one for Free

Related Posts

blog comments powered by Disqus