Linq Execute Slow?

Question

Hellow guys, i have method which insert rows in db first master table then its detail table, it works fine but through a linq it interted slowly. how can i fast linq q any idea

Joginder Banger · Answer

In a first look you insert data in both table with a single call. For example Category c = new Category(); c.name = "Accessories" ; Product p = new Product(); p.name = "USB Mouse" ; c.Products.Add(p); //and finally db.Categories.Add(c); db.SubmitChanges();

Laxmidhar Sahoo · Answer

Hi In foreach loop each time you call savechanges() method . You can apply bulkInsert method or after addrange use savechanges() List emps = new List (); foreach () { EmpScheduleMaster objempM = new EmpScheduleMaster(); . . emps.add(objempM) } _DB..BulkInsert(emps); For more follow the link https://entityframework-extensions.net/bulk-insert https://weblog.west-wind.com/posts/2013/Dec/22/Entity-Framework-and-slow-bulk-INSERTs

Mohsin Arif · Answer

public async Task Schedule_Save(Array EmpID, int RoasterID, DateTime Startdate, DateTime EndDate) { try { ArrayList ExistCode = new ArrayList(); #region Master PakOman_NedoEntities _Db = new PakOman_NedoEntities(); int itemsCount = EmpID.Length; int i = 0; foreach (var Emp in EmpID) { string[] EmpName = Emp.ToString().Split( '|' ); i++; //Thread.Sleep(10); long empID = long .Parse(EmpName[0].ToString()); var IsExist = await (from m in _Db.EmpScheduleMasters join d in _Db.EmpScheduleDetails on m.ID equals d.MID where m.EmpId == empID && d.AttDate >= Startdate && d.AttDate select m).ToListAsync(); if (IsExist.Count > 0) { ExistCode.Add(IsExist); } else { EmpScheduleMaster objempM = new EmpScheduleMaster(); objempM.GeneralSchedulePKId = RoasterID; objempM.StartDate = Startdate.ToString(); objempM.EndDate = EndDate.ToString(); objempM.CreatedBy = HttpContext.Current.Session[ "UserName" ].ToString(); objempM.CreatedDate = DateTime.Now; objempM.EmpId = int .Parse(EmpName[0].ToString()); _Db.EmpScheduleMasters.Add(objempM); await _Db.SaveChangesAsync(); long MID = objempM.ID; for (var dt = Startdate; dt { EmpScheduleDetail objempD = new EmpScheduleDetail(); var av = await (from q in _Db.ShiftScheduleGeneralMasters join a in _Db.ShiftScheduleGeneralDetails on q.PKId equals a.MID where a.AttDate == dt.Date && q.PKId == RoasterID select new { a.ShiftID }).FirstOrDefaultAsync(); if (av.ShiftID > 0) { objempD.ShiftID = av.ShiftID; } objempD.AttDate = dt.Date; objempD.AttDay = dt.DayOfWeek.ToString(); objempD.MID = MID; _Db.EmpScheduleDetails.Add(objempD); await _Db.SaveChangesAsync(); } } //CALLING A FUNCTION THAT CALCULATES PERCENTAGE AND SENDS THE DATA TO THE CLIENT //Thread T1 = new Thread(delegate () //{ // Functions.SendProgress(EmpName[1].ToString() + ":- schedule update in progress...", i, itemsCount, DataHelper.SessionUserName); //}); //T1.Start(); Functions.SendProgress(EmpName[1].ToString() + ":- schedule update in progress..." , i, itemsCount, DataHelper.SessionUserName); } #endregion return ExistCode; } catch (Exception ex) { ErrorLogging.Add(ex.Message, DateTime.Now, HttpContext.Current.Session[ "UserName" ].ToString(), "ModelScheduleUpdate" , "Schedule_Save" ); return null; } }

Joginder Banger · Answer

share your code dear, without code review we can't understand what's going in linq query.