SEND ON CONVERSATION Fails For Xml Serialized Object

Hi!

We are trying to queue a xml serialized object to a servive broker queue on a conversation.

The object is a simple .net c# class with few properties mostly string, which we serialize for queing and de/serialize after de-queing. Everything works as expected. Except that when the object contains language characters such as Æ Å Ø, the SEND ON CONVERSATION seems to fail. We are using UTF-8 encoding.

Below is part of the code.

public override bool QueueMessage(EmailMessage message)

{

if (message != null)

{

string xml = "";

using (MemoryStream stream = new MemoryStream())

{

System.Xml.Serialization.XmlSerializer x = new System.Xml.Serialization.XmlSerializer(message.GetType());

x.Serialize(stream, message);

xml = ConvertByteArrayToString(stream.ToArray());



}



string sql =

string.Format (@"DECLARE @dialog_handle UNIQUEIDENTIFIER;

BEGIN DIALOG CONVERSATION @dialog_handle

FROM SERVICE [MAINPostingService]

TO SERVICE 'MAINService'

ON CONTRACT [MAINContract] ;

SEND ON CONVERSATION @dialog_handle

MESSAGE TYPE [MAINMessageType]

('{0}') ;

End Conversation @dialog_handle

With cleanup", xml);

string connectionString = ConfigurationManager.ConnectionStrings["MessagingSystemConnectionString2005"].ConnectionString;



SqlConnection conn = new SqlConnection(connectionString);

SqlCommand cmd = null;

try

{

conn.Open();

cmd = conn.CreateCommand();

cmd.CommandText = sql;

cmd.Transaction = conn.BeginTransaction();

cmd.ExecuteNonQuery();

cmd.Transaction.Commit();

conn.Close();

return true;

}

.

.

}

}



//

private string ConvertByteArrayToString(byte[] byteArray)

{

Encoding enc = Encoding.UTF8;

string text = enc.GetString(byteArray);

return text;

}





Kind Regards

BGSK

Bangalore

India