I have the following method:
public static IEnumerable> GetRowsIter
(this SqlCeResultSet resultSet)
{
// Make sure we don't multi thread the database.
lock (Database)
{
if (resultSet.HasRows)
{
resultSet.Read();
do
{
var resultList = new Dictionary();
for (int i = 0; i < resultSet.FieldCount; i++)
{
var value = resultSet.GetValue(i);
resultList.Add(resultSet.GetName(i), value == DBNull.Value
? null : value);
}
yield return resultList;
} while (resultSet.Read());
}
yield break;
}
I just added the lock(Database) to try and get rid of some concurancy issues. I am curious though, will the yield return free the lock on Database and then re-lock when it goes for the next iteration? Or will Database remain locked for the entire duration of the iteration?
解决方案
No the yield return will not cause any locks to be freed / unlocked. The lock statement will expand out to a try / finally block and the iterator will not treat this any differently than an explicit try / finally in the iterator method.
The details are a bit more complicated but the basic rules for when a finally block will run inside an iterator method is
When the iterator is suspended and Dispose is called the finally blocks in scope at the point of the suspend will run
When the iterator is running and the code would otherwise trigger a finally the finally block runs.
When the iterator encounters a yield break statement the finally blocks in scope at the point of the yield break will run