Edit Question - KnowledgeHub

Title Body

I have two tables which need to be inserted when my application run. Let's say that I have tables as followed tbl_FirstTable and tbl_SecondTable My problem is data volume. I need to insert over 10,000 rows to tbl_FirstTable and over 500,000 rows to tbl_SecondTable. So fristly, I use entity framework as follow. public bool Save_tbl_FirstTable_Vs_tbl_SecondTable(List<tbl_FirstTable> List_tbl_FirstTable, List<tbl_SecondTable> List_tbl_SecondTable) { bool IsSuccessSave = false; try { using (DummyDBClass_ObjectContext _DummyDBClass_ObjectContext = new DummyDBClass_ObjectContext()) { foreach (tbl_FirstTable _tbl_FirstTable in List_tbl_FirstTable) { _DummyDBClass_ObjectContext.tbl_FirstTable.InsertOnSubmit(_tbl_FirstTable); } foreach (tbl_SecondTable _tbl_SecondTable in List_tbl_SecondTable) { _DummyDBClass_ObjectContext.tbl_SecondTable.InsertOnSubmit(_tbl_SecondTable); } _DummyDBClass_ObjectContext.SubmitChanges(); IsSuccessSave = true; } } catch (Exception ex) { Log4NetWrapper.WriteError(string.Format("{0} : {1} : Exception={2}", this.GetType().FullName, (new StackTrace(new StackFrame(0))).GetFrame(0).GetMethod().Name.ToString(), ex.Message.ToString())); if (ex.InnerException != null) { Log4NetWrapper.WriteError(string.Format("{0} : {1} : InnerException Exception={2}", this.GetType().FullName, (new StackTrace(new StackFrame(0))).GetFrame(0).GetMethod().Name.ToString(), ex.InnerException.Message.ToString())); } } return IsSuccessSave; } </p

Tags (comma-separated) Cancel