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

Linq query instead of foreach loop

Answers (2)