i am trying to insert value in error log in postgre
INSERT INTO errorlog (idError,iduser,strMessage,xmlError)
this are coulmn value in strmessage conatin
6307d86b-8af9-41bf-a686-a84a86373703', '', '', '12/5/2023 7:44:51 AM', 'HandlingInstanceID: 907bf805-1512-421b-85bc-73bb066a31a6
An exception of type 'System.Data.Entity.Core.UpdateException' occurred and was caught.
Because of this system I am not able to insert it gave me error as ERROR: syntax error at or near "System" how to put single quote in between where system is used.
What I have tried:
var cmd = context.Database.Connection.CreateCommand();
cmd.CommandType = CommandType.Text;
if (strMessage.Length > 200)
strMessage = strMessage.Substring(0, 200);
string sanitizedExceptionDetails = "$$"+strMessage.ToString()+"$$";
cmd.CommandText = "INSERT INTO mps_errorlog (idError,iduser,strMessage,xmlError) " +
"VALUES ('" + idError + "', '" + null + "', '" + , '" + strMessage + "','"+xmlError+"')";
cmd.Parameters.Add(new Npgsql.NpgsqlParameter(":iduser", NpgsqlTypes.NpgsqlDbType.Uuid)
{ Value = iduser=null });
cmd.Parameters.Add(new Npgsql.NpgsqlParameter(":strAnonymousId", NpgsqlTypes.NpgsqlDbType.Varchar)
{ Value = strAnonymousId });
cmd.Parameters.Add(new Npgsql.NpgsqlParameter(":dtmError", NpgsqlTypes.NpgsqlDbType.Timestamp)
{ Value = dtmError });
cmd.Parameters.Add(new Npgsql.NpgsqlParameter(":strmessage", NpgsqlTypes.NpgsqlDbType.Varchar)
{ Value = sanitizedExceptionDetails});
cmd.Parameters.Add(new Npgsql.NpgsqlParameter(":strPage", NpgsqlTypes.NpgsqlDbType.Varchar)
{ Value = strPage });
cmd.Parameters.Add(new Npgsql.NpgsqlParameter(":xmlError", NpgsqlTypes.NpgsqlDbType.Text)
{ Value = xmlError });
context.Database.Connection.Open();
cmd.ExecuteNonQuery();