Posted on: 3/29/2012 3:38:12 AM | Views : 352

Hi all,
i am working on developing a  distributed web application and i am using ASP.net(C#) , sql server 2008 db, so in my senerio a customer can add multiple orders at once if any one order  could not inserted than all records must b rollback i did this logic through tranasction but still i am confuse if customers are more than one and they are going to add multiple records at the same time than deadlock occurs so how can i do this .
my code is follows
System.Data.SqlClient.SqlTransaction st = DAL.DataAccessLayer.SqlHelper.GetTransaction("order");
// here begin transaction               
                    DataTable dt = (DataTable)ViewState["Order"];
                    ...

Go to the complete details ...