Stored procedure by table-valued parameters submitted to the database commands,
DataTable table=new ();//in c # to build table-valued parameter
Table. The Columns. The Add (new DataColumn (" key ", typeof (binary)));//this way how the type of binary expression?
Table. The Columns. The Add (new DataColumn (" address ", typeof (string)));
when fill the table foreach (var members assembled in)
{
DataRow line=table. NewRow ();
Line [0]=???????//members. The key is to a byte [32] types of data, how to convert it to a 256 - bit binary number?
Line [1]=members. Address;
Table Rows. The Add (line);
}
will eventually become into such a TABLE in the SQL type
CREATE TABLE [dbo] [TABLE] (
[key] [binary] (256), NULL,
[address]] to [char] (40) NULL
)