Hello,
I have developed a simple data provider that shares the same API to
access SQL Server (also SQL Server 2005 Express Edition), MySQL and MS
Access.
The intention is to reduce the amount of code to get datasets,
datareaders, insert, update or delete data and to have, as mentioned
before, the same API.
MS Access example:
Provider provider = new Provider("MS Access", "connection string");
provider.ExecuteNonQuery(command);
MySQL example:
Provider provider = new Provider("MySQL", "connection string");
provider.ExecuteNonQuery(command);
MS SQL Server example:
Provider provider = new Provider("MS SQLServer", "connection string");
provider.ExecuteNonQuery(command);
The .Net DatabaseHandler 1.1 is available obviously for free and you can
download it at http://www.webdp.net.
Any feedback is more than appreciated!
Have a nice day,
joel