private static Quote ParseLine(string line) { string[] values = line.Split(','); string title = values[0]; var quote = new Quote { Title = title }; Console.WriteLine("title: " + quote.Title); var body = values[1]; quote.Body = body; Console.WriteLine("body: " + quote.Body); return quote; }
private static void InsertQuoteIntoDatabase(Quote quote) { var connectionString = GetConnectionString(); // TODOx: insert into database if doesn't exist already ie title not there using (var connection = new SqlConnection(connectionString)) { using (var cmd = new SqlCommand("INSERT INTO Quotes (Title, Text) VALUES (@Title, @Quote)", connection)) { cmd.Parameters.AddWithValue("@Title", quote.Title); cmd.Parameters.AddWithValue("@Quote", quote.Body); connection.Open(); cmd.ExecuteNonQuery(); } } }