Linq query instead of foreach loop

Satish

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gokhul Varman9y ago
Just refer the link you can get your solution:https://www.codeproject.com/Tips/272542/Replacing-foreach-loop-with-LINQ
Nilesh Shah9y ago
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