private static Quote ParseLine(string line) { string[] values = line.Split(','); string title = values[0]; Console.WriteLine("title: " + title); var quote = new Quote { Title = title }; var body = values[1]; Console.WriteLine("body: " + body); quote.Body = body; return quote; }
private static void SaveToDatabase(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(); } } }