You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You
are creating the data layer of the application. You write the following code segment. (Line numbers
are included for reference only.)
01 public static SqlDataReader GetDataReader(string sql) {
02 SqlDataReader dr – null;
03
03 return dr;
05 }
You need to ensure that the following requirements are met:
• The SqlDataReader returned by the GetDataReader method can be used to retrieve rows
from the database.
• SQL connections opened within the GetDataReader method will close when the
SqlDataReader is closed.
Which code segment should you insert at line 03?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application. A
file named books.xmi contains ths following XML.
<bib>
<book title3″Ercgranraing in Unix” yeai=”1992*,>
<author> Author1</author >
<author>Author2</author>
<author>Author3</author>
</book>
</bib>
The application must generate an XML result that contains an XML element named DookTitle for
each book. The text content of must contain the title of the book. You need to create a query that
generates the new XML result. Which code segment should you use?

CD -C# 1st
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You
create stored procedures by using the following signatures:

• CREATE procedure [dbo].[Product Insert](Gname varchar(50),8price float)
• CREATE procedure [dbo].[Product_Updatej (@id int, Bname varchar(50), @price
float)
• CREATE procedure [dbo].[Product_Delete] (@ Id int)
• CREATE procedure [dbo].[Order_Insert] (@productld Int, Gquantity Int)
• CREATE procedure [dbo].[Order_Update](@id int, Gquantity int,GoriginalTimestamp
tlmestamp)
• CREATE procedure [dbo].[Order_Delete](@id int)
You create a Microsoft ADO.NET Entity Data Model (EDM) by using the Product and Order entities as
shown in the exhibit. (Click the Exhibit button.)

You need to map the Product and Order entities to the stored procedures. To which two procedures
should you add the Qproductld parameter? (Each correct answer presents part of the solution.
Choose two.)

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You
use Microsoft ADO.NET Entity Data Model (EDM) to mode entities. You create an entity named
Person with a schema defined by the following XML fragment
<EnlityType l1ame’CPerson”
<Key>
<PropertyRef Name=”Personld” I>
</Key>
<Property Name=”Personid” Typel=”int32” Nullable=”false” />
<Property Name=”CompaiyName” Type=”String”/>
<Property Name=”ContactName” Type”Strng”/>
<Property Name=”ContactTitle” Type=’String”/>
<Proper1y Name=”Address” Type=”String”/>
</Entitytype>
You need to ensure that entities within the application are able to add properties related to the city,
region, and country of Person’s address. What should you do?