CN118210498B

CN118210498B - A method and system for simultaneously referencing multiple versions of MySQL drivers in a C# project

Info

Publication number: CN118210498B
Application number: CN202410385292.9A
Authority: CN
Inventors: 刘德建; 谢佳伟; 李佳
Original assignee: Fujian Tianqing Online Interactive Technology Co Ltd
Current assignee: Fujian Tianqing Online Interactive Technology Co Ltd
Priority date: 2024-04-01
Filing date: 2024-04-01
Publication date: 2025-09-26
Anticipated expiration: 2044-04-01
Also published as: CN118210498A

Abstract

The invention relates to the technical field of computer communication, in particular to a method and a system for simultaneously referring to multi-version Mysql drive by a C# project, wherein the method comprises the following steps of S1, determining Mysql.data driven versions required to be used by two databases with different versions; the method comprises the steps of S2, modifying a digital signature of any Mysql.data driver, marking a driver needing to modify the digital signature as A1 and a driver not needing to modify the digital signature as B, S3, marking the driver after modification as A2, then simultaneously introducing the driver A2 and the driver B into a C# item, S4, selecting a driver with a lower version from the driver A2 and the driver B in the C# item, marking the driver as D, and designating the driver D as V1. The method and the device can solve the problem of drive compatibility caused by the difference of the versions of the databases in the same project, and realize stable and efficient operation in various MySQL database environments.

Description

Method and system for simultaneously referring to multi-version Mysql drive by C# item

Technical Field

The invention relates to the technical field of computer communication, in particular to a method and a system for simultaneously referring to multi-version Mysql drivers by a C# project.

Background

In C#, interfacing with a MySQL database typically requires the use of a driver component named Mysql. It is noted that different versions of mysql.data.dll are each adapted to a specific range of MySQL database versions. For example, version 8.0 drive supports multiple versions of databases 8.0, 5.7, 5.6, etc., whereas version 6.5.4.0 drive is applicable to versions 5.0 to 5.7, version 6.1.3.0 drive is applicable to version 4.0 databases. Under the conventional business scene, the development requirement can be met by selecting a driver with a proper version for a single type of MySQL database.

However, in some special scenarios, a challenge is presented in that the same project can connect both a low version 4.0 database and a high version 5.7 database under a set of code systems, which leads to the problem of drive compatibility. This problem becomes particularly troublesome in view of Visual Studio prohibiting the introduction of DLL files of the same name or having the same signature in a single item.

Disclosure of Invention

In order to solve the technical problems, the invention provides a method and a system for simultaneously referencing multi-version Mysql drivers for C# projects, which can solve the problem of drive compatibility caused by database version differences in the same project and realize stable and efficient operation in various MySQL database environments.

The invention is realized by adopting the following technical scheme:

a method for c# items to reference multi-version Mysql drivers simultaneously, the method comprising the steps of:

s1, determining Mysql.data driven versions required to be used by two databases with different versions;

S2, modifying the digital signature of any Mysql.data driver version, and marking the driver needing to modify the digital signature as A1 and the driver not needing to modify the digital signature as B;

S3, marking the modified drive as A2, and then introducing the drive A2 and the drive B into the C# item at the same time;

s4, in the C# item, selecting a lower version of drive from the drive A2 and the drive B, marking the lower version of drive as D, and designating the drive D as V1;

s5, executing an SQL command through a driver D under an alias V1 to inquire the actual version of the database which is currently connected;

And S6, if the version corresponding to the actual version of the database is the driver B, creating connection and executing the query by using the driver B, and if not, creating connection and executing the query by using the driver A2.

Preferably, the step S2 is further specifically that the digital signature is modified by:

first, a KeyFile file is generated;

secondly, deconstructing the driver A1 to generate a corresponding intermediate language file C;

Then, recombining the file C and combining with KeyFile files;

finally, the modification is completed to obtain a drive A2.

Preferably, the step S4 is further specifically that after the drive D is assigned with the alias V1, the external alias is imported through an external alias V1 instruction so as to facilitate the quote to the drive D in the program;

Then two subdirectories are added under the release catalog of the project and are respectively used for storing the drive A2 and the drive B;

Finally, assemblyIdentity elements and corresponding codeBase subelements are added in the Web config configuration file to define specific loading paths of the driver A2 and the driver B, so that a program can select which driver to call.

A system for simultaneously referencing multi-version Mysql drivers for C# items, comprising a determining module, a modifying module, an introducing module, a specified alias module, a querying module and a using module;

the determining module is used for determining Mysql.data driven versions required to be used by the two databases with different versions;

The modification module is used for modifying the digital signature of any Mysql.data driven version, and the driver needing to modify the digital signature is marked as A1 and the driver not needing to modify the digital signature is marked as B;

the introduction module is used for marking the modified drive as A2, and then introducing the drive A2 and the drive B into the C# item at the same time;

The alias assignment module is used for selecting a lower version of drive from the drive A2 and the drive B in the C# item, marking the lower version of drive as D, and assigning the drive D with the alias of V1;

The query module executes SQL command through the driver D under the alias V1 to query the actual version of the database which is currently connected;

and the using module is used for creating connection and executing query by using the driver B if the version corresponding to the actual version of the database is the driver B, and otherwise, creating connection and executing query by using the driver A2.

Preferably, the modification module further specifically modifies the digital signature by:

first, a KeyFile file is generated;

Then, recombining the file C and combining with KeyFile files;

finally, the modification is completed to obtain a drive A2.

Preferably, the alias assignment module further specifically assigns an alias name V1 to the driver D, and then imports an external alias name through an external alias V1 instruction so as to facilitate the quotation to the driver D in the program;

The invention has the beneficial effects that:

The invention provides a method and a system for simultaneously referring to multi-version Mysql drivers for C# projects, which can systematically comb out all MySQL database versions required by the projects according to the diversity of actual service environments, and accurately select each version MySQL driver required to be integrated into the projects based on the versions. Then, an adaptation strategy of digital signature of the original driving file is adopted, the file is renamed and introduced into the project, and the driving components of any version can be freely switched and called in the single file according to the requirement by means of an external alias mechanism of C#.

Drawings

FIG. 1 is a schematic flow chart of the method of the present invention.

Fig. 2 is a system schematic block diagram of the present invention.

FIG. 3 is a schematic diagram of a software Visual Studio 2017.

FIG. 4 is a schematic diagram of generation KeyFile.

Fig. 5 is a schematic diagram of an intermediate language file.

FIG. 6 is a schematic diagram of generating a new Dll file.

FIG. 7 is a schematic diagram of a new signature of a new Dll file.

Fig. 8 is a schematic diagram of a DLL file referencing two versions simultaneously.

Fig. 9 is a schematic diagram of the alias V1.

Fig. 10 is a schematic diagram of importing external aliases.

FIG. 11 is a diagram of a specific load path defining different versions of Mysql.Data drivers.

Detailed Description

The invention is further described below with reference to the accompanying drawings.

Referring to fig. 1, the present invention provides a method for simultaneously referencing multiple versions of Mysql driver for a c# item, the method comprising the following steps:

The invention is further described with reference to the following specific examples:

A method for simultaneously referencing multi-version Mysql drive by C# items,

Step 1, determining Mysql.data driven versions required to be used by two databases with different versions;

For example, according to the business condition, the Mysql.data driving version needed to be used by the high version library and the low version library is determined. For example, mysql 5.7 version database corresponds to mysql.data.dll 6.5.4.0, mysql4.0 version database corresponds to mysql.data.dll 6.1.3.0;

Step 2, modifying the digital signature of any Mysql.data driver version, and marking the driver needing to modify the digital signature as A1 and the driver not needing to modify the digital signature as B;

The digital signature is modified by:

first, a KeyFile file is generated;

Then, recombining the file C and combining with KeyFile files;

finally, the modification is completed to obtain a drive A2.

For example, select 6.1.3.0 version to modify a driver signature

(1) As in fig. 3, a developer command prompt running Visual Studio 2017 with administrator identity;

(2) As shown in FIG. 4, the command line page, input command sn-k keyPair. Sink, generates one KeyFile;

(3) As shown in FIG. 5, a command line page, input command ildasm D: \level\MySql. Data. Dll/out: D: \level\MySql. Data. Il gets an intermediate language file and outputs to under the D: \level\directory;

(4) As shown in FIG. 6, the command line page, input command ilasm D \level\MySql.data/Dll/key: key Pair.sink, generates a new Dll file using the derived MSIL (MySql.data.il) and the just created KeyFile;

(5) Referring to FIG. 7, a new signed Mysql.Data.dll file is obtained under the file directory, and the signature of the Dll file is modified to 98a540a6f88622c5 by decompilation and viewing;

Step 3, marking the modified drive as A2, and then introducing the drive A2 and the drive B into the C# item at the same time;

For example, as shown in FIG. 8, mysql.Data.6.1.3.0.dll file and 6.5.4.0 Mysql.data.dll file are referenced simultaneously in the project, where both versions of DLL files can be referenced simultaneously.

Step 4, in the C# item, selecting a lower version of drive from the drive A2 and the drive B, marking the lower version of drive as D, and designating the drive D as V1;

after the name of the driver D is designated as V1, the external alias is imported through an external alias V1 instruction so as to be beneficial to the fact that the driver D can be quoted in a program;

For example, (1) as in FIG. 9, alias "V1" is made for the newly referenced Mysql.Data.6.1.3.0. Dll;

(2) In the related operation class, as shown in fig. 10, the external aliases V1 instruction is used to import the external aliases.

(3) And seventhly, adding two subdirectories under the release catalog of the project to respectively store two versions of drive files:

bin/Mysql.Data/6.1.3.0/Mysql.Data.dll;

bin/Mysql.Data/6.5.4.0/Mysql.Data.dll;

(4) As shown in FIG. 11, elements assemblyIdentity and corresponding codeBase subelements are added to a Web.config profile to define specific load paths for different versions of Mysql.Data drivers.

Step 5, executing SQL command through the driver D under the alias V1 to inquire the actual version of the database which is currently connected;

For example, an SQL command, such as select @ @ version, is executed by a driver under the alias "V1" to query the actual version of the database currently connected.

And 6, if the version corresponding to the actual version of the database is the driver B, creating connection and executing query by using the driver B, and if not, creating connection and executing query by using the driver A2.

For example, if version 4.0, a connection is established and a related query operation for MySQL 4.0 database is performed using a driver labeled "V1". If version 5.7, the original 6.5.4.0 version mysql.data.dll driver is used to create a connection and execute the query.

With continued reference to fig. 2, the present invention further provides a system for simultaneously referencing multiple versions of Mysql drivers for a c# item, where the system includes a determining module, a modifying module, an introducing module, an alias assignment module, a query module, and a using module;

first, a KeyFile file is generated;

Then, recombining the file C and combining with KeyFile files;

finally, the modification is completed to obtain a drive A2.

In a word, according to the diversity of the actual service environment, all MySQL database versions required by the project can be systematically carded out, and on the basis of the versions, mySQL drivers which need to be integrated into the project are accurately selected. Then, an adaptation strategy of digital signature of the original driving file is adopted, the file is renamed and introduced into the project, and the driving components of any version can be freely switched and called in the single file according to the requirement by means of an external alias mechanism of C#.

The above description is only of the preferred embodiments of the present application, and should not be construed as limiting the application, but rather as covering all equivalent variations and modifications according to the appended claims.

Claims

1. A method for simultaneously referencing multiple versions of MySQL drivers in a C# project, characterized in that the method comprises the following steps:

Step S1: Determine the version of the Mysql.data driver required for two different versions of databases;

Step S2: Modify the digital signature of any version of the Mysql.data driver. The driver whose digital signature needs to be modified is marked as A1, and the driver whose digital signature does not need to be modified is marked as B.

Step S3: The modified driver is recorded as A2, and then driver A2 and driver B are simultaneously introduced into the C# project;

Step S4: In the C# project, select the driver with the lower version from driver A2 and driver B and record it as D, and assign an alias to driver D as V1;

Step S5: Execute SQL commands through the driver D under the alias V1 to query the actual version of the currently connected database;

Step S6: If the version corresponding to the actual database version is driver B, then use driver B to create a connection and execute the query; otherwise, use driver A2 to create a connection and execute the query.

2. The method for simultaneously referencing multiple versions of MySQL drivers in a C# project according to claim 1, wherein step S2 further comprises modifying the digital signature in the following manner:

First, generate a KeyFile file;

Secondly, deconstruct the driver A1 and generate its corresponding intermediate language file C;

Then, file C is reorganized and combined with the KeyFile file;

Finally, the modification is completed to obtain driver A2.

3. The method for simultaneously referencing multiple versions of MySQL drivers in a C# project according to claim 1, wherein step S4 further comprises: assigning an alias V1 to driver D, and then importing the external alias using the extern alias V1 instruction to facilitate referencing driver D in the program;

Then add two subdirectories under the project's release directory to store driver A2 and driver B respectively;

Finally, in the Web.config configuration file, add the assemblyIdentity element and the corresponding codeBase sub-element to define the specific loading paths of driver A2 and driver B, so that the program can choose which driver to call.

4. A system for simultaneously referencing multiple versions of MySQL drivers in a C# project, characterized in that the system includes a determination module, a modification module, an import module, an alias assignment module, a query module, and a usage module;

Determine the module: Determine the version of the Mysql.data driver required for the two different database versions;

Modify the module: Modify the digital signature of any version of the Mysql.data driver. The driver that needs to modify the digital signature is marked as A1, and the driver that does not need to modify the digital signature is marked as B.

Import module: record the modified driver as A2, and then import driver A2 and driver B into the C# project at the same time;

Specify an alias module: In the C# project, select the driver with the lower version from driver A2 and driver B and record it as D. Specify an alias for driver D as V1.

Query module: executes SQL commands through driver D under alias V1 to query the actual version of the currently connected database;

Use module: If the actual database version corresponds to driver B, use driver B to create a connection and execute the query; otherwise, use driver A2 to create a connection and execute the query.

5. A system for simultaneously referencing multiple versions of MySQL drivers in a C# project according to claim 4, wherein the modification module further specifically modifies the digital signature by:

First, generate a KeyFile file;

Then, file C is reorganized and combined with the KeyFile file;

Finally, the modification is completed to obtain driver A2.

6. The system for simultaneously referencing multiple versions of MySQL drivers in a C# project according to claim 4, wherein the alias assignment module further specifically: after assigning an alias to driver D as V1, imports the external alias via the extern alias V1 instruction, so as to facilitate referencing driver D in the program;