使用设计模式构建通用数据库访问类_c#（Build generic database access class _c # using design patterns）.doc

使用设计模式构建通用数据库访问类_c#（Build generic database access class _c # using design patterns） Build generic database access class _C # using design patterns Database access is very important in application design, and we typically need to focus on database access to ensure good encapsulation and maintainability. I, database access, for Microsofts own SqlServer and other databases (supporting OleDb), USES different access methods, which are distributed in the system.data.sqlclient and system.data.oledb namespace. Microsoft later introduced a class library specifically for accessing Oracle databases. We hope that at the time of writing application system, not affected by so many kind of different, can try to be database has nothing to do, when the backstage database is changed, dont need to change the client code. Sometimes, for performance and other reasons, we also want to provide a cache of database access, especially database connections. While Microsoft has built-in database caching for us, it is undoubtedly more flexible and efficient to control the cache itself. This requires that these database access classes be encapsulated again in the actual development process. Here, we introduce a real strategy that has a very good effect in practical application. The Factory and Silgleton design patterns are the primary means of use. Lets take a look at the meaning of Factory first: define an interface for creating objects and let the subclass decide which class to instantiate. Factory Method delays the instantiation of a class to its subclasses. Here could we deal with for a variety of database operations, therefore, need to first define a manipulation of the database interface, and then, depending on the database, by the class is instantiated to decide which class factory. Next, we first define this access interface. To illustrate the problem, weve defined fewer methods for this class, and other methods are easy to reference. Also note that I use the abstract class to define thi