I’ve noticed some awkward and unnecessary hand-encoding of RdbCommandText in some examples (including MSDN documentation).

I wanted to point out to newcomers to BDC that commands can be wrapped inside a CDATA tag in their "natural" form. Тако, this awkward construction:

<Имовина Име="РдбЦоммандТект" Тип="Систем.Стринг">
  SELECT dbo.MCRS_SETTLEMENT.id, dbo.MCRS_SETTLEMENT.settlement from dbo.MCRS_SETTLEMENT 
    ГДЕ (ид &гт;= @MinId) И (ид &То;= @ МакИд)
</Имовина>

can be better represented this way:

<Имовина Име="РдбЦоммандТект" Тип="Систем.Стринг">
<![ЦДАТА[
SELECT dbo.MCRS_SETTLEMENT.id, dbo.MCRS_SETTLEMENT.settlement from dbo.MCRS_SETTLEMENT
ГДЕ (ид >= @MinId) И (ид <= @MaxId)
]]>
</Имовина>

</крај>

BDC Primer

Intro to BDC