Linq query instead of foreach loop

Question

public static void InsertWsdiResult(AppDefinition appdef) { if(appdef.Id == null) throw new ArgumentNullException(appdef.Id); foreach (var connector in appdef.WSDIConnectors) { foreach (var token in connector.DataMapOperations) { using (DbCommand cmd = new CommandBuilder() .SetCommandText(IQ_InsertWsdiTokens) .SetCommandType(CommandType.StoredProcedure) .AddInputParameter (@AppID appdef.Id) .AddInputParameter (@FieldID token.To.Id) .AddInputParameter (@Expression token.Expression.Code) .ToDbCommand()) { cmd.ExecuteNonQuery(); } } } } How to use linq query in above code instead of two foreach loops Thanks

Nilesh Shah · Answer

What you can do is create the objects for table in which you want to insert then insert all at once instead of inserting in a for loop. but I think you will still need for loop for creating the required objects. What I mean is creating ojbects of wsdiTokens in for loop once for loop ends then insert all in one line using  InsertAllOnSubmit  method. somewhat like this var addwsdiToekns = GetAllTokens(); context.wsdiToekns.InsertAllOnSubmit(addwsdiToekns); context.SubmitChanges(); where the GetAllTokens() method will have the for loop logic and it will return List of wsdiToken objects which correspond to your table

Gokhul Varman · Answer

Just refer the link you can get your solution:https://www.codeproject.com/Tips/272542/Replacing-foreach-loop-with-LINQ