How to upgrade MySQL library in a C#program that works with Enterprise Library 6.5

Question

Greetings.

I have a web site program, programmed on C#, MVC, with Enterprise Library 6.5, but it works as database with MySQL 5.7.22. I want to upgrade the MySQL library to the latest one (8.0.41), but during compile process I got an error due Enterprise Library.

How can I upgrade dll library for MySQL, without modify Enterprise Library database objects?, because I only will upgrade the database version, not tables nor database objects. Of course, I want also to upgrade c# framework from 4.5 to 4.8, in order that the latest MySQL library can work in natural way.

Many thanks in advance for your help.

Answer 1

how are you connecting to mysql. the enterprise library does have builtin support except via odbc or older drivers?

Microsoft stopped updating the enterprise library over 10 years ago. There is some community support on GitHub, but that also seems to have died a couple years ago. but .net 4.8 also hasn't had an update in years, so it should still be good.

https://github.com/EnterpriseLibrary

Answer 2

Greetings Bruce. In this case, how can I "broke" the Enterprise Library from my program?, because this library introduces xml files, dll files, and so on. I was thinking in rewrite all classes that work with the database, then I will be able to use the new mysql libraries, but I'm a bit in trouble with that. Perhaps, do you have some suggestion about how to remove the enteprise library from my program?