private static void ReadFromCSVFile() { using (System.IO.StreamReader reader = new System.IO.StreamReader("testdata.csv")) { string line = null; bool firstLine = true; var connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User\Documents\GitHub\C--kursas-20190923\EntityDataBaseFirst\EntityDataBaseFirst\DataBase.mdf;Integrated Security=True"; DataContext db = new DataContext(connectionString); var table = db.GetTable <TestInformation>(); while ((line = reader.ReadLine()) != null) { if (firstLine) { firstLine = false; continue; } var splitData = line.Split(';'); TestInformation setObject = new TestInformation(); TestSetup setUpObject = new TestSetup(); int i = 0; if (string.IsNullOrEmpty(splitData[i])) { continue; } setObject.RunSeq = Convert.ToInt32(splitData[i++]); setObject.SensNo = splitData[i++]; if (string.IsNullOrEmpty(splitData[i])) { continue; } setObject.TestTemp = Convert.ToInt32(splitData[i++]); setObject.Supply = Convert.ToInt32(splitData[i++].Replace(" ", "")); setObject.Exposure = splitData[i++]; setObject.data = new DateTime(day: int.Parse(splitData[i].Split('/')[0]), month: int.Parse(splitData[i].Split('/')[1]), year: int.Parse(splitData[i++].Split('/')[2])); setObject.Laikas = TimeSpan.Parse(splitData[i++]); setObject.AirTemp = NumberExtractor(splitData[i++]); setObject.Humidity = NumberExtractor(splitData[i++]); setObject.Operator = splitData[i++]; setObject.Comment = splitData[i++]; i++; setUpObject.A = double.Parse(splitData[i++]); setUpObject.B = int.Parse(splitData[i++]); setUpObject.C = int.Parse(splitData[i++]); setUpObject.D = double.Parse(splitData[i++]); setUpObject.E = int.Parse(splitData[i++]); setUpObject.F = double.Parse(splitData[i++]); i++; setUpObject.MaxSupply = string.IsNullOrEmpty(splitData[i]) ? 0 : int.Parse(splitData[i++].Replace(" ", "")); setUpObject.MinSupply = string.IsNullOrEmpty(splitData[i]) ? 0 : int.Parse(splitData[i++].Replace(" ", "")); setObject.TestSetups.Add(setUpObject); //db.GetTable<TestSetup>().InsertOnSubmit(setUpObject); table.InsertOnSubmit(setObject); } db.SubmitChanges(); } }
partial void UpdateTestInformation(TestInformation instance);
partial void DeleteTestInformation(TestInformation instance);
partial void InsertTestInformation(TestInformation instance);