如何创建通用数据访问类以访问任何数据库 [英] How to create common Data access class to access any Database

问题描述

谁能告诉我如何编写一个类来访问不同类型的数据库.
例如，现在我在项目中使用Sqlserver，后来又更改为Oracle或其他.
代码更改应该更少.

Hi ,

Can anybody tell me how to write a class to access different types of databases.
For example now i am using Sqlserver in my project,later i changed to Oracle or other.
the code change should be less.

thanks.

推荐答案

这些已经以IDB*类的形式存在于System.Data中，例如IDBCommand等.请参见:http://www.c-sharpcorner.com/UploadFile/mbouck/GenericDataAccessCompActivator09052005013346AM/GenericDataAccessCompActivator.aspx [ ^ ]

These already exist in the form of IDB* classes in System.Data like IDBCommand etc. see : http://www.c-sharpcorner.com/UploadFile/mbouck/GenericDataAccessCompActivator09052005013346AM/GenericDataAccessCompActivator.aspx[^]

这篇关于如何创建通用数据访问类以访问任何数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！