You create Microsoft Windows-based applications. You create a Microsoft Windows-based application that stores information in a Microsoft SQL Server 2005 database. Your company requires that all database access is done by using stored procedures.
The stored procedures must meet the following requirements:
The procedures return data that can be used in any data-bound control in the application. The procedures return data in the most compact format available.
No complex logic is needed in the procedures. You need to implement the most appropriate technology to write stored procedures that meet these requirements. You also need to ensure that the stored procedures can be easily updated as application requirements change. What should you do?
A.
Use Transact-SQL that returns relational data.
B.
Use Transact-SQL that returns XML data.
C.
Use the .NET Framework language that returns relational data.
D.
Use the .NET Framework language that returns XML data.