Thread safe variable in VB.NET

vb.net vb.net-2010
sony picture sony · Oct 12, 2010 · Viewed 10.5k times · Source

Is this the right way of declaration dbreaders when mulitple users access the same page?

public dbReader as system.Data.IDataReader at class level or

Dim dbReader as System.Data.IDataReader in each function inside a class.

What would be the best practice to make the dbReader thread safe in VB.Net?

Does declaring them as static makes it thread safe?

Thanks in Advance,

Answer

Alex Essilfie picture Alex Essilfie · Oct 12, 2010

If you'd like each thread to modify the variable without 'fear' another thread will change it somewhere along the line, it is best you adorn the variable with the ThreadStatic attribute.

The ThreadStatic attribute creates a different instance of the variable for each thread that's created so you're confident there won't be any race conditions.

Example (from MSDN)

Imports System
<ThreadStatic> Shared value As Integer

Related questions

How to dynamically create columns in datatable and assign values to it?

I will have to create columns in datatable during runtime and assign values to it. How can i do it in vb.net. Any sample please...

Read More
How to open child forms positioned within MDI parent in VB.NET?

How do we arrange child forms in a parent MDI window? I'm able to call and display a child form from a menu on the parent, but the child pops up outside the parent - I want it to actually …

Read More
How to open a new form but closing the old one in VB

I have a welcome to my application as it loads up, but then need to have that form close and login form open when the continue button is hit. My code: Me.Close() Dim Login As New Form Login.Show() …

Read More