Error when User Agent contains apostrophes

[clupasq]

When a User Agent contains an apostrophe ('), the Udger client fails with the exception:

System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
unrecognized token: ":"
DataReader.cs(62,0): at Udger.Parser.DataReader.selectQuery(String query)
UdgerParser.cs(106,0): at Udger.Parser.UdgerParser.parseUA(String _userAgent)
UdgerParser.cs(73,0): at Udger.Parser.UdgerParser.parse()
Program.cs(46,0): at ConsoleTest.Program.Main(String[] args)

This is because query parameters are being added to the sql query by concatenation.
SqliteParameters should be used instead. Here are some of the reasons why: http://stackoverflow.com/a/20017707/390819

[mallat]

Fixed