Microsoft TS: Accessing Data with Microsoft .NET Framework 4 Sample Questions:

1. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You create stored procedures by using the following signatures:
CREATE procedure [dbo].[Product_Insert](@name varchar(50),@price float)
CREATE procedure [dbo].[Product_Update](@id int, @name varchar(50), @price
float)
CREATE procedure [dbo].[Product_Delete](@id int)
CREATE procedure [dbo].[Order_Insert](@productId int, @quantity int)
CREATE procedure [dbo].[Order_Update](@id int, @quantity int,@originalTimestamp
timestamp)
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:

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

A) Order_Delete
B) Product_Delete
C) Order_Update
D) Product_Update

2. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 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 enable query plan caching. Which object should you use?

A) EntityTransaction
B) EntityDataReader
C) EntityCommand
D) EntityConnection

3. You need to ensure that an exception is thrown when color names are set to less than two characters. What should you do?

A) Add the following method to the Color partial class in Model\Color.cs:
protected overrride void OnPropertyChanged(string property)
{
if (property == "Name" && this.Name.Length < 2)
throw new ArgumentOutOfRangeException("Name must be at least two
characters");
}
B) Add the following code segment to the ContosoEntities partial class in Model\ContosoEntities.cs:
public override in SaveChanges(System.Data.Objects.SaveOptions options)
{
var changes = this.ObjectStateManager.GetObjectSateEntries
(System.Data.EntityState.Added);
foreach (var change in changes)
{
if (change.Entity is Color) if (((Color)change.Entity.Name.Length < 2) throw new ArgumentException ("Name too short");
}
return base.SaveChanges(options);
}
C) Add the following attribute to the Name property of the Color class in the entity designer file:
[StringLength(256, MinimumLength = 2)]
D) Add the following method to the Color partial class in Model\Color.cs:
protected overrride void OnPropertyChanging(string property)
{
if (property == "Name" && this.Name.Length < 2)
throw new ArgumentOutOfRangeException("Name must be at least two
characters");
}

4. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use the ADO.NET Entity Framework to model your entities.
The application connects to a Microsoft SQL Server 2008 database named AdventureWorks by using
Windows Authentication.
Information about the required Entity Data Model (EDM) is stored in the following files:
-model.csdl
-model.ssdl
-model.msl
These files are embedded as resources in the MyCompanyData.dll file.You need to define the connection
string
that is used by the application. Which connection string should you add to the app.config file?

A) <add name="AdventureWorksEntities" connectionString="metadata=res://MyComparny.Data,Culture=neutral,PublicKeyToken=null/
model.csdIl res://MyCompany.Data,Culture=neutral, PublicKeyToken=null/model.ssdl| res://MyCompany.Data,Culture=neutral, PublicKeyToken=null/model.msl; provider=System.Data.EntityClient; provider connection string='DataSource=localhost;Initial Catalog=AdventureWorks;lntegrated
Security=True;multipleactivesuitsets=true'"
providerName="System.Data.SqlClient"/>
B) <add name="AdventureWorksEntities" connectionString="metadata=res://MyComparny.Data,Culture=neutral,PublicKeyToken=null/
model.csdIl res://MyCompany.Data,Culture=neutral, PublicKeyToken=null/model.ssdl| res://MyCompany.Data,Culture=neutral, PublicKeyToken=null/model.msl; provider=System.Data.SqlClient; provider connection string='DataSource=localhost;Initial Catalog=AdventureWorks;lntegrated
Security=True;multipleactivesuitsets=true'"
providerName="System.Data.EntityClient"/>
C) <add name="AdventureWorksEntities" connectionString="metadata=res://MyComparny.Datamodel.csdl| res://MyCompany.Data.model.ssdl| res://MyCompany.Data.model.msl; provider=System.Data.SqlClient; provider connection string='DataSource=localhost;Initial Catalog=AdventureWorks;lntegrated
Security=SSPI;multipleactivesuitsets=true'"
providerName="System.Data.EntityClient"/>
D) <add name="AdventureWorksEntities" connectionString="metadata=res://MyComparny.Data,Culture=neutral,PublicKeyToken=null/
model.csdIl
res://MyComparny.Data,Culture=neutral,PublicKeyToken=null/model.ssdIl
res://MyComparny.Data,Culture=neutral,PublicKeyToken=null/model.msl;
provider=System.Data.OleDBClient;
provider connection string='Provider=sqloledb;DataSource=localhost;Initial
Catalog=AdventureWorks;lntegrated Security=SSPI;multipleactivesuitsets=true'"
providerName="System.Data.EntityClient"/>

5. Refer to the following lines in the case study: PA40 in \Model\Part.cs, PR16 in\Model\Product.cs, and CT14 in \Model\Component.cs
The application must create XML files that detail the part structure for any product. The XML files must use the following format:
<?xml version="1.0" encoding="utf-8"?>
<product name="Brush" description="Brush product" productType="1">
<component name="Handle" description="Handle" partType="2">
<component name="Screw" description="Screw" partType="3">
<component name="Wood" description="Wooden shaft" partType="45">
</component>
<component name="Head" description="Head" partType="5">
<component name="Screw" description="Screw" partType="3">
<component name="Bristles" description="Bristles" partType="4">
</component> </product>
You need to update the application to support the creation of an XElement object having a structure that will
serialize to the format shown above.
What should you do? (Each correct answer presents part of the solution. Choose two.)

A) Insert the following code segment at line CT14 in \Model\Component.cs:
return new XElement("component, new XElement("name", this.Name),
new XElement("description", this.Description),
new XElement("partType", this.PartType));
B) Insert the following code segment at line CT14 in \Model\Component.cs:
return new XElement("component, new XAttribute("name", this.Name),
new XAttribute("description", this.Description),
new XAttribute("partType", this.PartType));
C) Insert the following code segment at line PR16 in \Model\Product.cs:
return new XElement("product, new XElement("name", this.Name),
new XElement("description", this.Description),
new XElement("productType", this.ProductType));
D) Insert the following code segment at line PR16 in \Model\Product.cs:
return new XElement("product, new XAttribute("name", this.Name),
new XAttribute("description", this.Description),
new XAttribute("productType", this.ProductType));
E) Insert the following code segment at line CT14 in \Model\Component.cs:
return new XElement("component, new XAttribute("name", this.Name),
new XElement("description", this.Description),
new XElement("partType", this.PartType));
F) Insert the following code segment at line PR16 in \Model\Product.cs:
return new XElement("product, new XAttribute("name", this.Name),
new XElement("description", this.Description),
new XElement("productType", this.ProductType));

Solutions: