You are creating a Business Data Catalog (BDC) definition for a bookstore application.
The application stores information about books in a Microsoft SQL Server 2005 database table named Books.
You need to retrieve all the book names from the Books table.
Which XML fragment should you use?
A.
<Entity Name=” GetBooks “>
<Properties>
<Property Name=”Title” Type=” System.String “>
Books
</Property>
<Property Name=” DefaultAction ” Type=” System.String “>
SELECT * FROM Books
</Property>
</Properties>
</Entity>
B.
<Method Name=” GetBooks “>
<Properties>
<Property Name=” RdbCommandText ”
Type=” System.String “> SPGetBooks </Property>
<Property Name=” RdbCommandType ”
Type=” System.String “> StoredProcedure </Property>
</Properties>
<!– Additional information goes here –>
</Method>
</Methods>
C.
<Parameter Direction=”In” Name=” GetBooks “>
< TypeDescriptor Name=” CommandText ” TypeName =”” System.String “”
IdentifierName =”SELECT * FROM Books” />
< TypeDescriptor TypeName =”System.Int32″ IdentifierName =”Books”
AssociatedFilter =”ID” Name=” BookId ” />
</Parameter>
D.
<Action Name=” GetBooks ” Position=”1″>
< ActionParameters >
< ActionParameter Name=” CommandText ” Index=”0″>
SELECT * FROM Books
</ ActionParameter >
< ActionParameter Name=” CommandType ” Index=”0″>
SQLQuery
</ ActionParameter >
</ ActionParameters >
</Action>