mvc web forms data flow to database

tarun janveja

my client is facing one problem .let me explain please help me its urgent

there are two server one is sql server 2014 database server and other one is application server on which normal registration application is hosted . application is made in mvc using entity framework.some times what happens when request is send from application server to database server on click of button suddenly network goes down.now client says half data is gone in table half not .is this possible as per me once button is clicked full form data is posted on database server not half data am i correct or not please let me know

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg7y ago
Hey. You can put try catch block and if you got any kind of error then insert into the db. So that you can easily find out the exact error. Thanks.
0
Madan Shekar7y ago
1) check your network bandwidth
2) are u sending huge amount of data
3) check is der any sql timeout exception (for this you need to right log )
check this blog for writing logs
https://www.c-sharpcorner.com/blogs/use-log4net-in-c-sharp-console-application

4) make asynch cals in case of huge data sending .

as i guess like you are facing sql timeout exception .

If it helps you mark as the answer.
0