使用设计模式构建通用数据库访问类_c#（Using design patterns to build generic database access classes _c#）.docVIP

使用设计模式构建通用数据库访问类_c#（Using design patterns to build generic database access classes _c#） Using design patterns to build generic database access classes _C# Access to databases is very important in the design of applications, and we usually need to focus on access to the database in order to ensure good encapsulation and maintainability. In.Net, the database access to Microsofts own SqlServer and other databases (OleDb), using different access methods, these are distributed in the System.Data.SqlClient and System.Data.OleDb namespaces. Microsoft later launched a library dedicated to accessing Oracle databases. We hope that in the preparation of the application system, not because of so many kind of different affected, can try unrelated to the database when the change occurred when the background database, the client code does not need to change. Sometimes, for performance and other reasons, we also want to provide caching for database access, especially caching of database connections. Although Microsoft built a database cache for us, it would undoubtedly provide greater flexibility and efficiency by controlling the cache itself. This requires us to encapsulate the database access classes once again in the actual development process. Here, we introduce a practical strategy which has achieved very good results in practical applications. Factory and Silgleton design patterns are the main methods of use. Lets take a look at the meaning of Factory: define an interface for creating objects, and let subclasses decide which class to instantiate. Factory Method delays the instantiation of a class to its subclasses. We may be dealing with a wide variety of databases here, so you need to first define an interface to manipulate the database, and then decide which class to instantiate by the class factory, depending on the database. Next, lets first define the access interface. To illustrate the problem, we define fewer methods for this class, and other methods are easy to refer