Xml in Insert causing Fatal error of '?xml' must be defined

0

While running through 3rd party NuGet Package called DbUp

INSERT INTO `portalquery` 
VALUES 
(31,'update portal.Config_PropertyValues set value = \''<?xml version=\"1.0\" encoding=\"utf-8\" ?>\r\n<data></fata>\'' where engineid = \''@engineid\'' and PropertyID = \''459\'';'',''Set Demograhpics node refresh interval to \''1\''',NULL,NULL,6)

I am getting following error:

Script block number: 12; Error code -2147467259; Message: Fatal error encountered during command execution.
MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter '?xml' must be defined.

I know what the issue is here but I am not able to escape "?" mark no matter what I do.

c#
mysql
xml
mysql.data
dbup
asked on Stack Overflow Oct 10, 2017 by Adeel • edited Jun 5, 2020 by Dharman

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0