Locking Problem

StrataFrame Forum

Home

Members

Calendar

Who's On

Welcome Guest ( Login | Register )

12 posts, Page 2 of 2

Locking Problem

Author

Message

Tim Dol

Posted 10/23/2006 4:04:32 PM

StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 5:16:01 PM
Posts: 314, Visits: 1,290

Thanks Scott, this solution worked fine, however I'm concerned if this is a work around or standard practice when implementing transactions. Based on the information Ben supplied with respect to isolation levels, the ReadUncommitted should have worked...Actually I tried them all and none of them worked for repeated reads.

Right now I have a FillByItemNumber method in my InventoryBO. I use this anytime I want to retrieve an inventory record. Does this mean I need to create another method FillByItemNumberNoLock and use this anytime I want to update the item muliple time within a transaction?

Post #3820

Scott

Posted 10/23/2006 4:21:59 PM

StrataFrame User

Group: Forum Members
Last Login: 02/04/2008 8:43:02 AM
Posts: 176, Visits: 1,519

That is exactly what happened to me. The only way I could get my import routine to work was with the NOLOCK. I don't know if this is the best way to do it but I couldn't find any other way to get it to work. If you come up with some thing please let me know, I will do the same.

Scott

Post #3821

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Reading This Topic

Active Users: 0 (0 guests, 0 members, 0 anonymous members)

No members currently viewing this topic.

Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

Permissions

All times are GMT -6:00, Time now is 7:15pm

Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.