3
Answers

ExecuteNonQuery vs OR in Entity Framework

Sanjay Sharma

Sanjay Sharma

6y
1.9k
1
Friends,
 
What is precise way in EF to achieve below scenario?
 
I have SP - [UpdateUnitStatement] @BatchRunId varchar(10)- The execution of this statement takes some time.
 
So below code using EF, does not wait till SP execution completed and moves to next statement.
 
entity. UpdateUnitStatement (BatchRunId);
//Next Statement
 
Alternatively, I achived this using standard SQLCommand.ExecuteNonQuery
 
int result = SQLCommand.ExecuteNonQuery("Exec UpdateUnitStatement @BatchRunId = " + BatchRunIds, null); 
Answers (3)