I am currently looking for a C# database gateway that would connect our ASP .NET application to the mySQL database. I’ve started to write a few methods to easily distinguish the separate functions needed in the database gateway class (e.g. connection, retrieve dataset, update data), but I’d like to see how it is being done professionally.
I’ve seen how it is being done, when I was writing a gateway for my ITPM project that was using MS Access 2003. But of course, mySQL has different requirements when it comes to connectivity when compared to MS Access. Furthermore, a web application has different security prerequisites that must be satisfied and it has to be clearly planned before I execute the connection. Well, I’ll keep looking, if I couldn’t find it within a few more hours I’ll continue to finish my code.