First, we will introduce the architecture of Solution, which is divided into four projects:
Web: front-end application;
BLL: Business processing layer. If you find it troublesome, you can abstract it further and place the code in aspx.cs of the Web layer;
Model: I won’t say much about this, everyone on earth knows it (data entity class)
SqlMaps: Resource class, which packages all configuration files and sql mapper files.
Two folders:
Include: dll file of iBatis.Net architecture
Log: The folder where log files are placed, configured in web.config
1. In some specific environments, one-stop solutions may not be effective. Some or all of the data in the system comes from existing databases. For security reasons, only a few Select SQL (or stored procedures) are provided to the development team to obtain what they need. The data and specific table structure will not be disclosed.
The development specifications require that all database operations involving business logic must be implemented by stored procedures at the database layer. (Most banks have such restrictions)
The system has a huge amount of data processing and extremely demanding performance requirements, which often means that we must use highly optimized SQL statements (or stored procedures) to achieve system performance design indicators.
2.iBATIS is very suitable for small and simple systems
iBATIS itself is small and simple
iBATIS does not impose any impact on the design or database structure of existing applications
iBATIS is very suitable for systems with growth trends
3. iBATIS for large-scale, enterprise-level systems: designed for it
Certain features of iBATIS enable it to handle large data sets efficiently
iBATIS allows you to establish mapping relationships from objects to databases in a variety of ways
MySpace has been applied
4. Used in any type of relational database:
Application database Enterprise database Private database Legacy database Simplicity Performance Clear division of labor Portability: Java, .Net or other open source
5. When not to use iBATIS
When you always have full control When your application requires fully dynamic SQL
When iBATIS doesn't work when you're not using a relational database
The DB is a Sql database. After appending, modify the Sql configuration file of SqlMaps/database.config and compile it to take effect.
Expand
