Sanjay Sharma

Sanjay Sharma

  • 1.3k
  • 413
  • 27.7k

ExecuteNonQuery vs OR in Entity Framework

Jul 28 2018 1:39 AM
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)