Example #1
0
        public Message GetMessage(Guid conversationId, Guid messageId)
        {
            // Create a filter to say Select * from MessageTable where ConversationId = @conversationId AND MessageId = @messageId
            QueryFilter filter = new SelectFilter(
                MessageTable.Instance,
                new AndFilter(
                    new ComparisonFilter(MessageTable.ConversationIdColumn, conversationId, ComparisonOperator.Equal),
                    new ComparisonFilter(MessageTable.MessageIdColumn, messageId, ComparisonOperator.Equal)),
                null);

            List <ITableRow> rows = MessageTable.Instance.QueryRows(filter);

            if (rows.Count != 1)
            {
                return(null);
            }

            return(DataContractToTableRowConverter.ConvertToMessage(MessageTable.Instance, rows[0]));
        }