Collection facility

AnjuSujith · November 20th, 2007, 02:52 AM

Is it possible to save parent and child table data at a time using the class list object

planoie · November 20th, 2007, 12:34 PM

You are going to need to be more specific with this question.

-Peter

AnjuSujith · November 22nd, 2007, 12:36 AM

I need to add details in parent table and child table using transaction. Is it possible to store data in the list of class object and save them at a time

planoie · November 26th, 2007, 10:36 AM

I'm not sure I understand. What do you mean by "save them at a time"? Do you mean you want to save all records simultaneously in a single transaction?

-Peter

AnjuSujith · November 27th, 2007, 07:05 AM

Yes,I want to saave the records in a single transsaction with out using collection

sonishpaul · November 27th, 2007, 01:03 PM

Your question is not clear. Can you give a scenario ?

dparsons · November 27th, 2007, 01:13 PM

Quote:

quote:Originally posted by AnjuSujith
Yes,I want to saave the records in a single transsaction with out using collection

Well now I am really confused. A List<T> is a collection.

And since you have said:

Quote:

quote:Originally posted by AnjuSujith

Is it possible to store data in the list of class object and save them at a time

You could do:

Code:

foreach(<type> t in <List>)
{
  //construct SQL 
}

and you can employ the SqlTransaction class to create a transaction in code as shown here:

http://msdn2.microsoft.com/en-us/lib...ansaction.aspx

This uses Dynamic SQL which i am not a fan of but i think this will solve your problem.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========