How can I pass table valued parameter to a stored procedure?

Asked Apr 10 '15 at 13:08

Active Apr 10 '15 at 13:37

Viewed 3,311 times

How to pass a table valued parameter to a stored procedure in Entity Framework using ExecuteSqlCommand or SqlQuery method?

Following is my code -

DataTable dataTable=new DataTable();

dataTable.Columns.Add("col1", typeof(int));
dataTable.Columns.Add("col2", typeof(bool));

dbContext.Database.ExecuteSqlCommand("exec stored_proc @tvp",
    new SqlParameter() { 
                         SqlDbType = SqlDbType.Structured, 
                         ParameterName = "@tvp", Value = dataTable 
                        });

This throws an exception saying 'The table type parameter '@tvp' must have a valid type name.'

edited Apr 10 '15 at 13:37

Andrey Korneyev

26,353
15
70
71

asked Apr 10 '15 at 13:08

Sumit Kadam

This question is about C# Entity Framework, right? – Oblivious Sage Apr 10 '15 at 13:13
yes. It is Entity Framework. – Sumit Kadam Apr 10 '15 at 13:20
1

possible duplicate of [System.ArgumentException: The table type parameter must have a valid type name](http://stackoverflow.com/questions/17817997/system-argumentexception-the-table-type-parameter-must-have-a-valid-type-name) – default.kramer Apr 10 '15 at 13:46

How can I pass table valued parameter to a stored procedure?

0 Answers0