Which XML fragment should you use?

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?

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>



Leave a Reply 0

Your email address will not be published. Required fields are marked *