i have some C# code that basically calls two stored procs.
objThing.Get() -> this calls stored proc usp_Thing_Get, which is a basic SELECT *
objThing.Money = 100 + intNewAmount;
objThing.Set() -> this calls stored proc usp_THING_Set, which UPDATES a row.
now, i need to lock the row in the GET, and then UNLOCK IT after i do a set ....
any suggestions please? i have NO idea how this can be done :(
thanks in advance.