November 14
Talking about BDC ADF and your friend, CDATA
Nice one! Thanks to Paul Galvin for pointing this to the SharePoint community. I am sure there will be few people(including me) writing SQL queries in the BDC definition file as shown in the MSDN documentation. SOME times we ignore to try to take that extra-mile and blindly keep doing in the same way as pointed in the documentation:)
Quote
BDC ADF and your friend, CDATA
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. So, this awkward construction:
<Property Name="RdbCommandText" Type="System.String">
SELECT dbo.MCRS_SETTLEMENT.id, dbo.MCRS_SETTLEMENT.settlement from dbo.MCRS_SETTLEMENT
WHERE (id >= @MinId) AND (id <= @MaxId)
</Property>
can be better represented this way:
<Property Name="RdbCommandText" Type="System.String">
<![CDATA[
SELECT dbo.MCRS_SETTLEMENT.id, dbo.MCRS_SETTLEMENT.settlement from dbo.MCRS_SETTLEMENT
WHERE (id >= @MinId) AND (id <= @MaxId)
]]>
</Property>
</end>
BDC Primer
Intro to BDC