rdiframework.net━9.14 Database connection Management ━web section

Rdiframework.net━. NET rapid Information System development framework

9.14 Database connection Management-web section　

　　We can often see a lot of software directly put the database connection string in the software execution directory in the configuration file, which directly put the database connection string (whether encrypted or not) on the client is very insecure. In our framework, we can hook up countless different types of databases, by unifying these connection strings through special processing to the database, the front-end developers only need to call the appropriate database access interface, change the database server address, etc. are very convenient, the database connection management main interface as shown. All database connections are determined uniformly through the connection name.

　　In the database connection management main interface, we can add a new database connection to meet our business needs, if the database changes, we can also modify the existing connection definition, the unused connection can also be deleted.

9.14.1, New database connection

Add a new database connection as shown, the database "connection type" can be set in the data dictionary by default to SQL Server, and the modification and delete operations are similar to others.

9.14.2, modifying database connections

　　The most important benefit of database connection management is that all the databases required by the business system can be managed and defined here, and then the interface calls provided by the framework are applied, and the unified management of the database connection of the business system is achieved. If the database name changes,IP address changes, and so on, the business code does not need to make any changes. As long as the connection name defined in database connection management is not changed. For existing database connections, if there are any changes, you can modify them. Modify the Reiki Library connection interface as follows:

9.14.3, deleting a database connection

　　For database connections that are no longer in use, you can delete them.

Related articles:

Rdiframework.net-based on. NET rapid Information System development Framework-Series catalogue

Erichu
Source: http://blog.csdn.net/chinahuyong
Email:[email protected]
QQ Communication:406590790
Framework Blog:Http://blog.csdn.net/chinahuyong
Http://www.cnblogs.com/huyong
Rdiframework.net, based on. NET of rapid information system development, integration framework, to users and developers the best. NET Framework deployment scenarios.
about senior engineer, information System Project Manager, DBA. Focused on Microsoft platform Project architecture, management and enterprise solutions, multi-year project development and management experience, has organized and developed several large projects, in the object-oriented, service-oriented and database areas have a certain degree of accomplishment. is now mainly engaged in based onrdiframework.netframework of technical development, consulting work, mainly services in finance, health, railways, telecommunications, logistics, Internet of things, manufacturing, retail and other industries.
If you have any questions or suggestions, please enlighten me!
This article is copyright to the author and Csdn, welcome reprint, but without the author's consent must retain this paragraph, and in the article page obvious location to the original connection, if there is a problem, you can contact me by email or QQ, thank you very much.

rdiframework.net━9.14 Database connection Management ━web section