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
meharmahmoodAsked:
Who is Participating?
 
mAjKoLConnect With a Mentor Commented:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataSqlClientSqlConnectionClassBeginTransactionTopic2.asp

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

HTH
0
All Courses

From novice to tech pro — start learning today.