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);
