public static void TickBulkCopy(string InstrumentName, DateTime Start)
{
DateTime _start = DateTime.Now.AddDays(-10);
DateTime UseThisDate = Start > _start ? _start : Start;
AlsiDBDataContext dc = new AlsiDBDataContext();
var tickData = HistData.GetHistoricalTICK_FromWEB(_start, DateTime.UtcNow.AddHours(2), InstrumentName);
DataTable RawTicks = new DataTable("TickData");
RawTicks.Columns.Add("N", typeof(long));
RawTicks.Columns.Add("Stamp", typeof(DateTime));
RawTicks.Columns.Add("Price", typeof(int));
foreach (var p in tickData) RawTicks.Rows.Add(1, p.TimeStamp, p.Close);
dc.CleanTick();
#region BulkCopy
DataSet tickDataSet = new DataSet("AllTicks");
tickDataSet.Tables.Add(RawTicks);
SqlConnection myConnection = new SqlConnection(AlsiUtils.Data_Objects.GlobalObjects.CustomConnectionString);
myConnection.Open();
SqlBulkCopy bulkcopy = new SqlBulkCopy(myConnection);
bulkcopy.DestinationTableName = "RawTick";
bulkcopy.WriteToServer(RawTicks);
Debug.WriteLine("Tick Bulk Copy Complete");
RawTicks.Dispose();
myConnection.Close();
dc.CleanUp();
#endregion
}
