Implementing Concurrency in BugBase

vbmanms · May 22nd, 2008, 02:29 PM

Hi,
can anybody please provide tips on implementing/dealing with concurrency in the BugBase?

Thank you.

Imar · May 22nd, 2008, 03:21 PM

Hi there,

You would do that the way you would do it in any other application: keep track of what has changed.

One solution is to use a WHERE clause for an UPDATE statement that includes all fields. Then when the number of affected rows is zero, you know someone else has updated the record as not all columns match anymore. You can then requery, show the user the old and new values and let them decide what to do.

In a similar approach you can use a SQL Server TimeStamp column. Then use that in the UPDATE statements to keep track of changes.

Searching for "TimeStamp sql server concurrency" should give you some interesting results.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

vbmanms · May 23rd, 2008, 10:27 AM

Imar,
As usual, your response is instant. Thank you for the attention.

Thank you for the tips, and you guided me where to start.

I will research more about this topic and build my knowledge.

Imar · May 23rd, 2008, 11:33 AM

You're welcome. Good luck.

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

vbmanms · May 23rd, 2008, 02:13 PM

Imar,
after researching on this topic and with your guide, I think I've built solid understanding.

Using your first approach, I can apply this universally (to any database back-end, SQl Server, Oracle, and you name it...). I may solve most of concurrency issues for the company projects that I will work on where Oracle is the data store.

Using the alternative way, I could implement this timestamp approach in the BugBase project as this feature applies to SQL server environment.

Again, I am gaining invaluable information from you.

Having equipped the knowledge from the chapters on your book plus your guides on this forum, I will be able to develop ASP.NET applications rapidly. Hopefully, I can exceed my managers' expectation to complete the projects early so that I can prove ASP.NET development time is comparable to tools such as Oracle APEX. (in the scales of Intranet applications)

I wish good luck in your projects and hope to see more great works from you!

Regards,

Imar · May 23rd, 2008, 06:01 PM

Excellent. Thanks for the follow up.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
While typing this post, I was listening to: Dead by Pixies (Track 6 from the album: Doolittle) What's This?