asp.net (C #) +sql Server three-tier architecture data access scheme (i)

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)

FunctionID
Int
4
0
Feature ID

OperationID
Int
4
0
Action ID

Roletypeid
Int
4
0
Identity ID

Bbstypeid
Int
4
0
Forum Category ID

Score
Int
4
0
Number of points

Bb
Int
4
0
Currency number

Buytype
Int
4
0
Purchase type

Functionstate
Int
4
0
0: No, 1: Yes, 2: Buy