Invoking C # class application instances in SQL

This article will share a method in a C # class is called in SQL Server. That's it. I in the. NET program to manipulate data in some field data encryption, which is common to many systems, one of the Delphi program also need to use, and need to decrypt the data, because I in the. NET encryption in a more special way, in the Delphi program decryption is more cumbersome and to consume a lot of time, so have to let Sqlser Ver calls the assembly in a way that resolves the problem. For specific reference . net/c# Course [4]:SQLServer Basic application Development Tutorial.

The following is just an example of sticking out to share.

Create a Dll,class, code such as below:

650) this.width=650; "src=" http://183.61.143.148/group1/M00/02/5A/tz2PlFRCEVOASpQnAABGkMYsbig515.jpg "/>

onto the database server.

then run the following T-SQL code:

650) this.width=650; "src=" http://183.61.143.148/group1/M00/02/5A/tz2PlFRCEWqQriTAAADrOHE_3og829.jpg "height=" 637 "Width=" 453 "/>

You can then call this function in T-SQL.

The code is as follows:

650) this.width=650; "src=" http://183.61.143.148/group1/M00/02/5A/tz2PlFRCEZrRyT2WAAARojjuZus844.jpg "/>

the above is a personal summary of some of the content can refer to, want to learn more Database Tutorials knowledge can be landed on E mentor Network.

This article is from the "Add Language" blog, please make sure to keep this source http://yuguotianqing.blog.51cto.com/9292883/1565804

Invoking C # class application instances in SQL