SqlDbType and own created SQL Server type

Question

Which type do I have to choose if I want to send a DataTable to SQL Server 2008? Because I created my own type for a table to provide the transfer of the datatable.

SqlCommand cmd = new SqlCommand("dbo.LipperFilesTestingInsertFileRowKey", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@DataTable", SqlDbType.???, 512));

SQL

CREATE TYPE [dbo].[keytable] AS TABLE (key varchar(512))

Stored procedure "short form":

create procedure insertkeys
    @indicater, @keys keytable readonly
as
begin
    insert into dbo.tableA 
        select * 
        from @keys
end

This is covered in the documentation for Table-Valued Parameters — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Jun 24, 2016 at 7:49

Milney · Accepted Answer · 2016-06-24 09:19:13Z

1

The type you should use is; SqlDbType.Structured

answered Jun 24, 2016 at 9:19

Milney

6,4472 gold badges21 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SqlDbType and own created SQL Server type

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related