Accessing data from a VB.NET assembly

Hi,

I'm an old PL/SQL developer who is migrating to the MicroSoft side. My first task is to convert an XML field to relational data, assign the data to variables and call some stored procedures to insert.

I am ready to assign the data to the variables and can't figure out a way to map it in t-sql without doing an "If" statement from hell. I thought I could do something easier in .NET where I could create an object that mapped the data to a variable for me and then I could just query the variable directly from the object in my t-sql code.

My question is - Is this possible? And if so, do I create a collection or can someone give me a short sample of code with a brief explanation?

Any help is greatly appreciated!

Thanks!

Maureen