How to send a full class into the stored procedure in the form of XML?

Question

How to convert c # inline queries into stored procedure written in transact sql?

Answer 1

You can use xml data type as parameter in the sp.

.AddParam("Name ofParameter",size,me.xml("className")) // from backgroun coding

declare @handle int
declare @XML xml = '2013-01-012013-01-02'
exec sp_xml_preparedocument @handle out, @XML
select * from openxml(@handle, '/ROOT/ids', 2) with (id Date)
exec sp_xml_removedocument @handle