| Li-fan Chen 2006-11-20, 7:21 pm |
| Hi,
While working on a large asp.net project we have had the great pleasure
of using SQL Server 2005. Unfortunately not all of the asp.net projects
could be upgraded to 2.0 (to match the new database) and we are a little
confused about how to access the large data types introduced in SQL
Server 2005.
One of the feature is XML datatypes. We have some questions about
feeding SQL Server xml datatypes and retrieving xml datatypes:
IN-BOUND
How should we phrase the System.Data 1.1 access calls to feed an
variable containing XML to a SQL Server 2005 stored procedure?
What data type and length should be named on the System.Data 1.1 type?
OUT-BOUND
If returning a table:
Which data type should be used to return the XML datatype in the
select?
On the ADO.NET side, what should we cast the type to? How do we
access it?
If returning a -out or in-out parameter:
Which data type should be used to return the XML datatype
On the ADO.NET side, what should we cast the type to? How do we
access it?
Bonus question:
Not only do we worry about XML datatype, we wonder about varchar(max)
and nvarchar(max).
We are worried we might do this wrong, so we are looking forward to your
expertise and assistance in this situation. Thank you for any help you
can render!! :-)
Best regards,
-- Li-fan
|