asp.net (C #) +sql Server three-tier architecture data access scheme (i)
Source: Internet
Author: User
asp.net|server| Architecture | Data introduction:
Participated in a large-scale community program development, and now the relevant development experience is summed up, and we discuss. The main benefit of this section is to explore a data-reading scenario in which the collection class replaces a dataset that is fetched directly from the database, which can solve the bottleneck of SQL Server throughput. The general small number of programs will not have problems, but the data in 1.001 billion, the database throughput limit will be more obvious. The solution here is in fact the massive data information into a strip, to frequent access to the cost of the library to solve the bottleneck limit, in fact, the burden of the database server to share the Web server. Gossip less, to get to the point, our example is the community program in a configuration table reading, we are based on certain conditions to get data from the database.
First, the database design:
Scoresetting Integral Setting table
Key:scoresettingid
Field Name
Type
Length
Default
Description
Scoresettingid
Int
4
0
Scoresettingid (Automatic numbering)
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.