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?

You use Microsoft Visual Studio 2010 and Microsoft ADO.NET Framework 4 to create an
application.The application connects to a Microsoft SQL Server database.The application uses the
ADO.NET LINQ to SQL model to retrieve data from the database. The application will not modifv
retrieved data.You need to that all the requested data is retneved. You want to achieve this goal
using the minimum amount of resources. What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application.You
use the ADO.NET Entity Framework to model your entities.You use Plain Old CLR Obects (POCO)
entities along with snapshot-based change tracking. The code accesses the POCO ent,es direcly. You
need to ensure that the state manager synchronizes when changes are made to the object graph.
Which ObectContext method should you choose?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application uses the ADO.NET Entity Framework to manage PIan Old CLR Objects (POCO) entities.
You create a new POCO class.
You reed to ensure that the class meets the following requirements:
• It can be used by an ObjectContext
• It is enabled for change-trackng proxles
Which two actions sould you perform? (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. The
application connects to a Microsoft SQL Server database. You use the ADO.NET LINQ to Entities
model to retrieve data from the database. You need to call a function that is defined in the
conceptual model from within the LINQ to Entities queries. You create a common language runtime
(CLR) method that maps to the function. What should you do next?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You
manually create your own Context class named AdventureWorksDB that inherits from Object
Context. You need to use Adventure WorksDB to invoke a stored procedure that is defined in the
data source. Which method should you call?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database.You use Entity SQL to retrieve data from
the database. You need to find out whether a collection is empty. Which entity set operator should
you use?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application.
Theapplication connects to a Microsoft SQL Server 2008 database. You need to use a spatial value
type as a parameter for your database query. What should you do?