Accessing data from a VB.NET assembly

Question

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

Mirko Meier · Answer

Do you have a database? I don't realy understand your problem. If you are looking for a simple access to a stored procedure have a look at Invist  which generates code from an exiting database for an easy use of CRUD.

Bechir Bejaoui · Answer

I don't undersand your question but I guess that you need to work with a dataset object to store data then to query it using ADO interface?