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