To commemorate successful implementation of "database replacement without code"-conversion from access to SQLite

Purpose:

Now, let's take a look and celebrate,

Thank you for your comments.

Background:

Database components have been completed for a long time,

I haven't been doing a good test,

Requirements:

The new system has a large data volume (which may far exceed expectations ),

I planned to update it to MSSQL before, but it was really troublesome. In combination, choose SQLite.

Process:

A: Out-of-system:

1. Data Structure generation is inevitable ,(CodeGenerator completed)

2. It is inevitable to import data. (because it is already an entity class, several lines of code can complete the entire process. Besides the ID of some tables, it is basically a perfect solution)

B: inside the system:

1. web. config is still inevitable to be modified, and there is no real implementation of zero code (CHANGE Part: system. data. oledb-> system. data. SQLite, six bytes ^_^)

C: test:

1. There is no problem with adding or deleting a part.

2. The management part is much faster, and the list, conditions, pages, and no inconsistency appear.

D: conclusion:

Ignore system table generation and data import. The total number of code modifications is six bytes.

Basically, it is "zero code.