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

Question

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 

Answer 1

Data store in DB is depend on network too, where is your database , are you using local database on your machine?

Answer 2

I am using Local datatbase only on my machine