Using the Entity Framework 4.0
I have 2 Stored Procedure Calls generated by LLBL which look like this:
public int CallFIRST(System.String userId, System.String clientIds)
{
var cmd = CreateStoredProcCallCommand("[dbo].[usp_ABC]", true);
AddParameter(cmd, "@USER_ID", 64, ParameterDirection.Input, userId);
var toReturn = ExecuteNonQueryCommand(cmd);
return toReturn;
}
public int CallSECOND(System.String userId, System.String clientIds)
{
var cmd = CreateStoredProcCallCommand("[dbo].[usp_123]", true);
AddParameter(cmd, "@USER_ID", 64, ParameterDirection.Input, userId);
var toReturn = ExecuteNonQueryCommand(cmd);
return toReturn;
}
How do I call them both inside 1 transaction?