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);