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<Guid>("@AppID", appdef.Id)

.AddInputParameter<Guid?>("@FieldID", token.To.Id)

.AddInputParameter<string>("@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