How do I determine which SQLDBType to assign to a parameter depending on the input variable to store in the DB? Is there a GetType equivelant to test with? If IsNumeric(ParameterValue) Then Parameter.SqlDbType = SqlDbType.Float ElseIf IsDate(ParameterValue) Then Parameter.SqlDbType = SqlDbType.DateTime ElseIf IsArray(ParameterV...
I have a stored procedure that accepts an xml parameter (SqlDbType.Xml) that is being called from some .NET/ ADO.NET code. I have tested this through a test harness using a System.XML.XMLReader to read some test XML from a file; Dim xmlParam As SqlParameter = New SqlParameter("@xml", SqlDbType.Xml) xmlParam.Value = New SqlTypes.SqlXml...
What value in the SqlDbType enumeration should I use for the numeric T-SQL data type? ...
From what I can see, SubSonic 2.x stored procedure parameter data types can only be of type System.Data.DbType. Is there a quick way to add System.Data.SqlDbType so we can use System.Data.SqlDbType.Structured to pass tables - ultimately to TVP's? In this particular project, all data caller functions are accessed through StoredProcedu...