Access database enhancer Requirements and introduction

0. Requirements

0.1 about the issues with CS encapsulation

graduation thesis used the Access database, design need to use MVC design pattern You need to encapsulate the data entities into classes, set too many table One to complete the encapsulation is a hassle (requires Open View Designer, view Field name this requirement

0.2 about Access table Structure of the problem

Graduation Thesis database design, in order to be able to directly get the properties of the table structure can be copied directly into Word, only to think of this requirement, access does not provide direct table structure property export, Access property document manager Build the report content is too much, need things on the surface inconvenient, and formatting inconvenience to copy to Word in .

1.CS Encapsulation class construction

1.1 Reading an Access file , each table is read out, the field type is judged , the field Description , Generate packaged Well of C # class

1.2 Selection Access File

1.3 Tips Select the file path

1.4 Setting CS files Saved by location

1.5 hints where to save settings , The default save location is " My Documents "

1.6 Selection Build CS File

1.7 Hints CS File Build Complete

1 . 8 Build List of CS files

1.9 Generation Example of CS file

2 . Export an Access database the table structure in

2.1 Main Interface

2.2 Select Access Database Files

2.3 in the left Select table to export table structure

2.4 Select Save Location

2.5 Browse Table Structure

2.6 Export The selected table structure into an Excel file

2.7 Export of the file

2.8 can also will be selected Table structure is separated by table name

2.9 Export the results

2.10 of which An example of

3. Presence the deficiencies

3.1 Possible exist Unknown the exception

3.2 Async Not used Operation , occupy CPU

3.3 and Other exceptions not found

students who are in need:
http://download.csdn.net/detail/u010570551/8487313

Access database enhancer Requirements and introduction