C#

emran834 wrote:

do I need to lock the mentioned block as I am already using Transaction.

emran834 wrote:

You replied me saying that, database will not be locked, I should use transaction.

emran834 wrote:

Did you mean if I use transaction then SQL will be locked ?

Class A {
	... //omitted code
	private void methodA () {
		using (B b = new B()) {
			... //do something
		} // here B will be automattically disposed
	}
}

Class B : IDisposable {
	... //omitted code
	~B() {
		this.Dispose(); // fallback, in case you forget to call Dispose
	}
	public void Dispose() {
		... // the clean up
	}
}

//Program.cs
using System;
using System.Collections.Generic;
using System.Text;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            SeperateFile.PrintMessage("Hi n' Stuff");
        }
    }
}

//SeperateFile.cs
using System;
using System.Collections.Generic;
using System.Text;

namespace ConsoleApplication1
{
    class SeperateFile
    {
        public static void PrintMessage(string message)
        {
            Console.WriteLine(message);
        }
    }
}

//Program.cs
using System;
using System.Collections.Generic;
using System.Text;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            SeperateFile obj = new SeperateFile();
            obj.PrintMessage("Hi n' Stuff");
        }
    }
}