Argh!  I am getting "duplicate parameter" errors with the following
prepared SqlCeCommand:  (The important line is the next to the last line
with @kid_id).

select e.entry_id,    
    convert(nvarchar(10), e.entry_date, 101),    
    e.entry_title,    
    e.entry_text,    
    e.minutes_spent,    
    e.entry_date
from ud_entry as e
where e.entry_date >= @start_date      
    and e.entry_date <= @end_date      
    and exists
        (select *
        from ud_entry_to_kid as iek
        where e.entry_id = iek.entry_id
            and (iek.kid_id = @kid_id or @kid_id = -1) )
order by e.entry_date, e.priority

If I try to run this, I get:
{"Duplicated parameter names are not allowed. [Parameter name =
@kid_id]"}

If I remove the "or @kid_id = -1", the command compiles and runs
correctly.  Apparently, I can only put the @kid_id parameter in the
query once.  From the behavior, this seems like a deliberate limitation.
(!)

Has anyone seen this before?  Suggestions for working around?

Using SQL CE 3.1.

Thanks for any advice.

Matt

partial stack trace:

Duplicated parameter names are not allowed. [  Parameter name = @kid_id
]
  at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
  at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand
(CommandBehavior behavior, String method, ResultSetOptions options)
  at System.Data.SqlServerCe.SqlCeCommand.ExecuteDbDataReader
(CommandBehavior behavior)
  at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader
(CommandBehavior behavior)
  at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
  at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables,
Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
behavior)
  at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)