I am using the sqldataadapter to create stored procedures. The tables have
been created using "User Defined Data Types". When the tool creates the
Insert, Update, and Delete procedures the parameters are defined as
nvarchar(50) for all of the fields in the table that have character user
defined data types. It does however create the command parameters correctly.
command parameter example: Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@ELIGIBLEORGID ",
System.Data.SqlDbType.VarChar, 15, "ELIGIBLEORGID"))
proc def: @eligibleorgid nvarchar(50),
The problem that I have is if the user defined data type is longer than 50
characters the proc is created with the nvarchar(50).
The question that I have is has anybody found a resolution for this? How
can the procs be created with the correct datatype?
Thanks.