Suraj Kumbhar

Suraj Kumbhar

  • NA
  • 59
  • 4.4k

How to save large data in Database from c# Windows App

Apr 24 2017 6:03 AM
hello guys,
I am working on ERP project which is being developed in C# Windows Form Application. It is multi-tier application which has UI,Business,Data Access, Data & property layer. When I try to save data like 4 items at a time. It's taking 2.5 seconds time to execute layer in folowing order.
UI --> Business --> DataAccess .
But when it comes to Data Layer it takes more than 6-7 seconds for completing saving process. I am optimizing code which has done by my seniors. I have attatched a sample code file which consist a Save function in Data layer. Please go through it and suggest what code changes should I do to work it faster.
Thanks & Regards,
Suraj 

Attachment: samplecode.rar

Answers (2)