Hi,

Maybe someone can help me. If I want to make a read and an update in a table but that I want no one to be able to read the same table while I'm reading/updating, what kind of IsolationLevel should I use? I've read the definition of each type, but even now I'm not sure which one I should use. Thank you

Same table or same records?

IsolationLevel.Serializable is the one you're looking for.

same record. because for certain entities, when I create a new one, I need to show in advance the "futur" id the user. So in my database I keep track of several table counters instead of using identity. but in the tests two people managed to get the same id (in a transaction, I read the next id, then increment it for the next person). So obviously my transaction prevented simultaneous increment part, but not the read part

A serializable transaction will place an exclusive lock on the row. So no-one can read it/access it except when the query specifies teh NOLOCK hint, which is never done in LLBLGen Pro code.

great thanks