i have list which has more than 4000 row data,it takes much

Question

However this function working smoothly for small and average data sets which means if number of rows less to 1000  this is loading with much time

 

 

 

NewSaleMasterModel lst = (from newsale in _dbContext.proc_GetAllNewSale()

where newsale.NewSaleID == _modelID

select new NewSaleMasterModel

{

NewSaleID = newsale.NewSaleID,

EmployeeID = newsale.EmployeeID,

ProductID = newsale.ProductID,

EmpName = newsale.EmpName,

ProductName = newsale.ProductName,

Salutation = newsale.Salutation,

FirstName = newsale.FirstName,

MiddleName = newsale.MiddleName,

LastName = newsale.LastName,

AccountHolderName = newsale.AccountHolderName,

NewSaleDate = newsale.NewSaleDate,

PhoneNo = newsale.PhoneNo,

AlternatePhoneNo = newsale.AlternatePhoneNo,

EmailID = newsale.EmailID,

DateOfBirth = newsale.DateOfBirth,

StreetAddress = newsale.StreetAddress,

PostalAddress = newsale.PostalAddress,

PaymentMode = newsale.PaymentMode,

CardHolderName = newsale.CardHolderName,

CardNumber = newsale.CardNumber,

CardExpirymonth = newsale.CardExpirymonth,

CardExpiryYear = newsale.CardExpiryYear,

CVV = newsale.CVV,

CardPayTerm = newsale.CardPayTerm,

CardDabitDate = newsale.CardDabitDate,

BankName = newsale.BankName,

BSBNO = newsale.BSBNO,

AccountNo = newsale.AccountNo,

BankDabitDate = newsale.BankDabitDate,

BankPayTerm = newsale.BankPayTerm,

Isactive = newsale.Isactive,

AudioFile = newsale.AudioFile,

RecordingFile = newsale.recordingfile,

StreetState = newsale.StreetState,

StreetCity = newsale.StreetCity,

StreetPostalCode = newsale.StreetPostalCode,

PostalState = newsale.PostalState,

PostalCity = newsale.PostalCity,

PostalCode = newsale.PostalCode,

Reason = newsale.Reason,

CardBankName = newsale.CardBankName,

AgentNotes = newsale.AgentNotes

}).FirstOrDefault();

return lst;

 

 

and displying in datatable list