This Application Block is essential for programs that use the database, using it to reduce a lot of code related to the database. However, the lack of beauty is only provided by the SQL Server version of Helper, so I have to change it myself, let it provide Oracle, OLEDB and ODBC Helper, which is the Data Providers provided by .NET Framework. If you have any other Data Provider, you can also expand.
Very simple, put the SQLHELPER's existing code COPY, then replace it with Oracle, OLEDB, ODBC and other words, there is a corresponding version, but not, in addition to the other Data Provider, ExecutexmlReader, except for SQL Server, so simple It is possible to remove them. What is the current problem is how to implement cross-database?
In fact, this is an old problem, it seems that you can't do 100% cross-database unless your program is very simple. So it is better to write multiple versions for multiple databases, but you can add multiple versions if you don't need to change call, so you can add support for new databases in the future, it seems that it is impossible, actually through good The design is achievable, and if you don't say it, you should vary depending on the project. As a prompt, you can consider this purpose using the combination of factory method patterns and other modes.
