MS-SQL Transaction locking whloe table

Well I m using MS-SQL Server and having desktop application. When i applied SqlTransaction to insert a row in table it locks whole table
How its possible to prevent to lock whole table
thanx in advance
Who is Participating?
mAjKoLConnect With a Mentor Commented:

Look at this one and use SqlConnection.BeginTransaction(IsolationLevel)
Set the Isolation Level that will be best for you.

All Courses

From novice to tech pro — start learning today.