ansaurus

Question

C#, Storing HTML pages in an SQLite database

Answer 1

+3 A:

I would expect that if you used a named parameter to do the insert, the query engine would take care of escaping the necessary characters for you; eg(note, I've never used Sqlite, so this is a contrived sample):

var myCommand = SqliteCommand("INSERT INTO HtmlPages(PageName, PageText) VALUES(@PageName, @PageText)");
myCommand.Parameters.AddWithValue("@PageName", "asdf");
myCommand.Parameters.AddWithValue("@PageText", "<html>...</html>");

Chris Shaffer 2009-09-23 13:18:47

ansaurus

tags:

views:

answers:

C#, Storing HTML pages in an SQLite database

related questions