[Help] test the forward and reverse functions of xcode v8.0.

Objective: To test the normal reverse function of xcode v8.0.

Forward project: Read schema information from the database and generate entity classes.

Reverse Engineering: constructs the architecture information based on the characteristics of the entity class, generates or modifies the database in reverse mode.

Preparations:

1. provide your own database instance, preferably your own database. to test whether various fields of various databases can be identified as correct. net Type (Forward Engineering), also tested. net type can be converted to the corresponding database type (reverse engineering ). (Supports MSSQL, access, sqlce, SQLite, MySQL, Oracle, PostgreSQL, and Firebird)

2. One copy of the latest xcoder v4.2

 

Start:

1. Configure the connection string in xcoder.exe. config. If this file is not available, run xcoder once to generate it automatically. Xcoder can automatically discover local MSSQL, local directory access and SQLite.

2. Main Interface after startup. The connection is selected from the drop-down list. Check whether templates are available in the template.

3. Select the connection string to be tested and click "Connect ". In this case, xcoder obtains the database architecture through xcode, obtains all the table information, and lists it in the data table.

4. Back up the architecture information and use it later.

5. Select the "entity" template and click "generate all tables" to generate 12 entity classes in 0.3 seconds. Click "Open Directory.

6. Create a console project and reference newlife. Core. dll and xcode. dll (CodeIn the generator ). And copy all the entity classes generated just now.

7. Add an application to configure app. config. Add some configuration information. When we generated the object class, we set the connection name common. In this configuration file, we should configure a connection named common, however, we map the common connection name to another connection name through xcode's connection name ing function.

8. Write a few pieces of code for a try.

9. Modify the connection string and start testing the reverse engineering.

10. RestartProgram. The running result remains unchanged, but it is a little slower. In fact, this is because we have specified a non-existent database common888, and the reverse engineering switch xcode. schema. Enable is enabled in the configuration file. xcode automatically creates databases and data tables.

11. Check the fields in the database to see if the field type is consistent with the original database type. Check whether the index can be correctly created.

12. Test the compatibility between different databases. For example, an entity class is generated from MSSQL and then reverse engineering is generated to SQLite. In this regard, we can do more tests. Testers can also exchange database architecture information (step 1 export) and use xcoder to import data to generate entity classes.

 

The xcode type is based on ADO. net, but there is a large number. net type corresponds to a variety of database types, we can only do a small part of the test, cannot ensure that all types of fields can be correctly identified.

The database providers that need to append the DLL will automatically download it!

Currently, xcode ranks the compatibility of various databases: mssql2008/2005, mssql2000, access, SQLite, Oracle, MySQL, sqlce, PostgreSQL, Firebird, there may be more problems.

For problems other than forward and reverse engineering, you can specify the project to different types of databases for testing.

 

Various problems encountered during the test are reported in the group to correct various bugs in real time.

 

Test materials:Http://xcode.codeplex.com/releases/view/73026