We added a new column to SQL Server user defined table with a default value. So I am expecting the old code to work and use default value but I got an error back from ado.net
System.Data.SqlClient.SqlException (0x80131904): Trying to pass a table-valued parameter with 8 column(s) where the corresponding user-defined table type requires 9 column(s).
_typeSqlMetaData = Create table schema - old table structure
SqlDataRecord record = new SqlDataRecord(_typeSqlMetaData);
record.SetInt16(0, someData);
record.SetGuid(1, someGuid);
record.SetDecimal(2, Amount);
.
.
.
record.SetBoolean(7, someflag);
User contributions licensed under CC BY-SA 3.0