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. Svo, this awkward construction:
<Eign Nafn="RdbCommandText" Tegund="System.String">
SELECT dbo.MCRS_SETTLEMENT.id, dbo.MCRS_SETTLEMENT.settlement from dbo.MCRS_SETTLEMENT
HVAR (id >= @MinId) AND (id <= @ MaxId)
</Eign>
can be better represented this way:
<Eign Nafn="RdbCommandText" Tegund="System.String">
<![CDATA[
SELECT dbo.MCRS_SETTLEMENT.id, dbo.MCRS_SETTLEMENT.settlement from dbo.MCRS_SETTLEMENT
HVAR (id >= @MinId) AND (id <= @MaxId)
]]>
</Eign>
</enda>
BDC Primer
Intro to BDC