I am looking for a VB.net and SQL server expert to refactor and fix an issue I have with my code.
Currently, the piece of code has got inline SQL written for inserting record in SQL. the problem I am facing is when two people race to insert the record, it inserts same record twice and for one purchase two invoice gets generated.
I need to fix this issue and to detect a deadlock while this happens.
so you need to refactor this code to rewrite the piece of code to check the record exists or someone else has raced to insert the same record, if its inserted, you have [login to view URL] an exception or if not insert it.
also u need to write a logic to check for deadlock.
Solution u provide could be written as stored procedure as well.
let me know if u have any questions before bidding.
11 freelance font une offre moyenne de ₹2546 pour ce travail
I am a Vb and sql server expert and i can do your job. you can check my reviews to see the quality of work i provide.
Hi, I can surely fix the issue. Can we take this further? I'm a Microsoft expert with 10+ Years of Development experience in Microsoft technologies and have executed the various project and skill area are Web Ap Plus
Hello Manager Can you let me know, approx how many places , we need to fix that issue? can we discuss, so we get more idea about estimation. my self Rakesh, i have over 5 years of exp in building website, deskto Plus
I can optimize the query as per the requirement and I can provide you a solution with friendly interface if needed.
I can understand the issue. One doubt is, purchase invoice number is duplicating or not?. Need to set a unique key on purchase invoice table. We can change inline query to a stored procedure. Relevant Skills and Exper Plus
Hello, I would like to express my interest in and enthusiasm for vb.net / sql server code refactoring assignment. i am expert at vb.net and sql server also deadlock insert process I have Microsoft.NET Cer Plus
Hi there,Ashish here we are calling from rudra infotech. and we are specialist in software and web development. we have couple of team to working in vb.net if you have to see our desktop project just ping me. thank yo Plus