[C #] Zdbviewcs: cross-platform Database viewer. Supports SQL Server, Oracle, MySQL and other databases

zyl910

I. Description

This tool is suitable for use in the following situations-

* Quickly view data and table structure information in the database.
* Test the wording of the connection string under ADO.
* Help analyze the ADO database operation.

Second, usage

Run this program.
Select the data provider factory in the Provider drop-down box. (if not, try adding the data provider factory configuration to the Zdbviewcs.exe.config).
Fill in the connection string in the "ConnectionString" text box.
Click the "Open" button to open the data.

After you open the database. You will find tables in the table and view in the "table" page on the left. The data in the data table is shown in the "Data" page on the right.
Click on another table in the table, and the Data on the right will also transform the content.
In fact, when you click in the "Table" table, the SQL statement is automatically generated from the drop-down box to the right of "table" and the "Exec" button is automatically clicked.
You can also write your own SQL statement in the "SQL" text box and click the "Exec" button. Note that the text box to the left of "Exec" is a record number limit, and if set to 0, all records are obtained.

Click "Dataschema" on the right side to view the table structure table.

Click on the right "datainfo" to view the property information for each object at the time of the query.

Source code Download--
Https://github.com/zyl910/zdbviewcs

[C #] Zdbviewcs: cross-platform Database viewer. Supports SQL Server, Oracle, MySQL and other databases