CYQ. Data lightweight Data layer elegant V1.4 auxiliary tool (10)

Open-source V1.3: The Path to the lightweight Data layer of CYQ. Data. The open-source V1.3 framework

For release of V1.4, see CYQ. Data lightweight Data layer elegant V1.4 now with API help documentation (9)

 

Preface

The auxiliary tool released this time only provides the OutPutData class in the CYQ. Data. SQL namespace to simplify some operations.
The auxiliary tool released this time is also applicable to V1.3.

 

 

It is described as follows:

I. Overall

1: Main Interface During Running

 

2: generate the table enumeration area:

 

3: generate the view enumeration area:

 

4: generate the Stored Procedure enumeration area:

 

5: About

 

Ii. Instructions for use

1: Database Link Configuration

A: Modify and add: Modify the default database link for your project database link, click "test link", and click "save link" when the test passes ".

, A new database link for MessageConn is added. The link will still exist at the next startup.

B: delete: to delete a link, select the link to be deleted and click "Remove link.

Important

All database operations, including enumeration generation, are performed on the currently used Linked database.

 

 

2: select the Database Type

A: select the database type. The generated paging stored procedure is related to this.

B: whether the project has multiple databases depends on the generated enumeration.

Note:Enumeration names generated in multiple databases are generated as agreedFor details, see CYQ. Data lightweight Data layer elegant V1.4 now with API help documentation (9) about enumeration conventions.

 

 

3: one-time operation

A: generate A paging stored procedure: Click it to automatically create A paging stored procedure in the database.

B: generate an exception log table: Click it to automatically create a table in the database [ErrorLogs]

Two steps are required to enable logging:

1: added the deleetting attribute IsWriteLog.
2: add the log database link [ Considering that the logstore may be different from the current database]

The configuration example is as follows:

<Shortettings> <add key = "IsWriteLog" value = "true"/> </shortettings>
<ConnectionStrings>
<Add name = "Conn" connectionString = "Server =.; database = Chat; uid = sa; pwd = 123456"/>
<Add name = "LogConn" connectionString = "Conn"/> // use the Conn method. You can also write the complete link string.
</ConnectionStrings>

 

4: enumeration file storage path

Simply put, the enumeration file you generated is stored in the path of the project and saved for life.

 

 

5: Table/View/Stored Procedure enumeration generation

A: preview: view the generated file.
B: Save the file directly. Click it to save the file. The path is "enumeration file path +" \ "+ file name"
C: Modify: Click to modify the name of the saved file. The new file name will be loaded next time.

 

 

6: About

This is the author's blog address and related instructions.

 

 

Closing statement:

This auxiliary tool is saved for life.
When you modify the database, just open the tool and click the corresponding "Save directly to file" to overwrite the file.
Finally, I wish everyone a happy, safe, and easy-to-use experience.

 

CYQ. Data [V1.4] auxiliary tool: CYQ. Data light-weight Data layer-path bug feedback, optimization suggestions, latest framework download