CeBeginTransaction question

CeBeginTransaction is documented as taking an "isolevel" parameter with one
of the following three values; CEDB_ISOLEVEL_READCOMMITTED,
CEDB_ISOLEVEL_REPEATABLEREAD and CEDB_ISOLEVEL_SERIALIZABLE. Unfortunately,
it doesn't describe what these levels actually mean. I've searched for these
parameter and have come up completely empty.

Anyone have any ideas what each of these mean?
Thanks,
//Ray

Fabien
Tue Sep 19 14:24:53 CDT 2006

Hi,

Check this :
http://windowssdk.msdn.microsoft.com/en-us/library/system.transactions.isol=
ationlevel.aspx

BR


Fabien Decret
Windows Embedded Consultant

ADENEO (ADESET)
http://www.adeneo.adetelgroup.com/




Ray Marshall a =E9crit :

> CeBeginTransaction is documented as taking an "isolevel" parameter with o=
ne
> of the following three values; CEDB_ISOLEVEL_READCOMMITTED,
> CEDB_ISOLEVEL_REPEATABLEREAD and CEDB_ISOLEVEL_SERIALIZABLE. Unfortunatel=
y,
> it doesn't describe what these levels actually mean. I've searched for th=
ese
> parameter and have come up completely empty.
>=20
> Anyone have any ideas what each of these mean?
> Thanks,
> //Ray

RayMarshall
Tue Sep 19 15:40:02 CDT 2006

Thanks! This creates a few new questions (I'm not exactly sure of these
descriptions) but I think I can get those new answers from reading more about
SQL transactions. I think Serializable is what I assumed would happen during
a transaction (no one can touch the data until a commit) so I get that. I am
not sure about ReadCommited and RepeatableRead.

Thanks again.
//Ray