My question was ,, if there are 500 objects in a collection, then how many time LINQ will round trip from database, it will be 500 or just in a single go.
On Fri, Mar 18, 2011 at 1:21 PM, Reuben Bartolo <[email protected]>wrote: > http://msdn.microsoft.com/en-us/library/bb399378.aspx > > <http://msdn.microsoft.com/en-us/library/bb399378.aspx>LINQ only submits > when you call SubmitChanges. Therefore do your logic before (inserting, > deleting, updating), and then call it once. > > In fact, LINQ might actually not hit the database at all, if it realises > that nothing has changed. (Example, you add row A, and later on you delete > row A before submitting it). > > On 18 March 2011 06:55, [email protected] <[email protected]> wrote: > >> Hi >> >> I am about to make some decision about the LINQ, a question arises >> "Is LINQ hits 500 times to database for 500 objects for insertion or >> in a single shot". Please advice if any one knows. >> >> >> Thanks >> Gaurav >> >> -- >> You received this message because you are subscribed to the Google >> Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML >> Web Services,.NET Remoting" group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en >> or visit the group website at http://megasolutions.net >> > > -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
