Requirement and introduction of ACCESS Database booster, access Database

Requirement and introduction of ACCESS Database booster, access Database

0. Requirements

0.1 questions about cs Encapsulation

In this thesis, access database is used, and MVC design mode is used for design. data entities must be encapsulated into classes and too many tables must be set, it is very troublesome to encapsulate one by one (you need to open the view designer to view the field name and field type.

0.2 questions about access Table Structure

In this paper, we need to design databases. In order to directly obtain the attributes of the table structure and copy them to the word, we can think of this requirement. access does not provide direct export of table structure attributes, the access Property Document Manager generates too many reports, which make it inconvenient to copy the required items to the word format.

1.CsEncapsulationClassStructure

1.1 read the access file, read each table, judge the field type, field description, and generate the encapsulated C # class.

1.2 select an access File

1.3 The selected file path is prompted

1.4 set the location for saving the cs File

1.5 The system prompts you to set the storage location. The default storage location is "My documents".

1.6 Select generate cs File

1.7 prompt that the cs file is generated completely

1.8 list of generated cs files

1.9 example of the generated cs File

2 . Export access Database Table Structure in

2.1 Main Interface

2.2 select an access database file

2.3 select the table on the left to export the table structure

2.4 select a save location

2.5 browse table structure

2.6 export the selected table structure to an excel file

2.7 Exported Files

2.8 you can also separate the selected tables and export the table structure, named after the table name.

2.9 export result

2.10 example

3. existLimitations

3.1 unknown exceptions may exist

3.2 asynchronous operations are not used, occupying CPU

3.3 and other undiscovered exceptions

Students in need ,:
Http://download.csdn.net/detail/u010570551/8487313