public void ReadFile(Account account1) { var fileName1 = "C:\\Source\\acadotnet\\BankWorm\\transactionfile-data.csv"; var fileContents = File.ReadAllLines(fileName1).ToList().Skip(1); foreach (var line in fileContents) { var cells = line.Split(','); var transaction = new Transaction { CreateDate = DateTime.Parse(cells[0]), Memo = cells[1], TransactionTypeId = EnumExtensions.ConvertEFTransactionType(cells[2]), Amount = Convert.ToDecimal(cells[3]), Account = account1 }; _context.Transactions.Add(transaction); } _context.SaveChanges(); }