public static void Fix() { string SIMcontext = @"Data Source=85.214.244.19;Initial Catalog=ALSI_SIM;User ID=SimLogin;Password=boeboe;MultipleActiveResultSets=True"; var dc = new AlsiSimDataContext(SIMcontext); foreach (var v in dc.tblResult_5Min_SSPOPs) { var c = v.Sequence.IndexOf(','); var x = v.Sequence.Substring(c + 1); var q = new tblResult_5Min_SSPOP() { Notes = "New", Sequence = x, Profit = v.Profit, }; try { dc.tblResult_5Min_SSPOPs.InsertOnSubmit(q); dc.SubmitChanges(); } catch (Exception ex) { Debug.WriteLine("Skipping " + q.Sequence); } } }
public static void Fix() { string SIMcontext = @"Data Source=85.214.244.19;Initial Catalog=ALSI_SIM;User ID=SimLogin;Password=boeboe;MultipleActiveResultSets=True"; var dc = new AlsiSimDataContext(SIMcontext); foreach (var v in dc.tblResult_5Min_SSPOPs) { var c = v.Sequence.IndexOf(','); var x = v.Sequence.Substring(c + 1); var q = new tblResult_5Min_SSPOP() { Notes = "New", Sequence = x, Profit = v.Profit, }; try { dc.tblResult_5Min_SSPOPs.InsertOnSubmit(q); dc.SubmitChanges(); } catch (Exception ex) { Debug.WriteLine("Skipping " + q.Sequence); } } }
partial void DeletetblResult_5Min_SSPOP(tblResult_5Min_SSPOP instance);
partial void UpdatetblResult_5Min_SSPOP(tblResult_5Min_SSPOP instance);
partial void InserttblResult_5Min_SSPOP(tblResult_5Min_SSPOP instance);
partial void DeletetblResult_5Min_SSPOP(tblResult_5Min_SSPOP instance);
partial void UpdatetblResult_5Min_SSPOP(tblResult_5Min_SSPOP instance);
partial void InserttblResult_5Min_SSPOP(tblResult_5Min_SSPOP instance);