On Fri, Mar 18, 2011 at 3:15 PM, Fernando Nomellini <[email protected]> wrote: > What he wants to know is in an INSERT situation, the example below is a > Select. this will of course be one connection and only one SQL statement. > > The question is : if I insert 500 new objects customers in my context and > then SaveChanges, how many commands will be send to the Database ? > > In MY opinion, 500 insert comands will be send. But it is only a wild guess. > -----------------------
Your opinion should be backed up with the sql profiler where you can see WHAT IS RUN. If you have multiple tables you needed multiple inserts. If you have one table you can always see that they UNION together. Or at least they did in the early days of LINQ. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell -- 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
