You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL
Server 2008 database. You add the following table to the database.
CREATE TABLE ObjectCache (
Id INT IDENTITY PRIMARY KEY,
SerializedObjectData XML )
You write the following code segment to retrieve records from the ObjectCache table. (Line numbers
are included for reference only.)
01string s = GetConnectStringFromConfigFile(“xmldb”);
02using (SqlConnection conn = new SqlConnection(s))
03using (SqlCommand cmd = new SqlCommand(
04″select * from ObjectCache”, conn))
05{
06conn.Open();
07SqlDataReader rdr = cmd.ExecuteReader();
08while(rdr.Read())
09{
10
11DeserializeObject(obj);
12}
13}
You need to retrieve the data from the SerializedObjectData column and pass it to a method named
DeserializeObject. Which line of code should you insert at line 10?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application
that uses the Entity Framework. You create the following Entity Data Model.

You write the following code. (Line numbers are included for reference only.)
01using (var context = new AdventureWorksLTEntities())
02{
03Customer cust = context.Customers.First();
04cust.CompanyName = “Contoso”;
05int count = 0;
06
07}
The changes to the cust entity must be saved. If an exception is thrown, the application must retry
the save 3 times. You need to add a code segment to meet the requirements. Which code segment
should you insert at line 06?

You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL
Server 2008 database. The application contains the following code segment.
stringSQL=string.Format
(“SELECT*FROMCustomerWHERECompanyNameLIKE’%{0}%'”,
companyName);
varcmd=newSqlCommand(SQL,con);
You need to reduce the vulnerability to SQL injection attacks. Which code segment should you use?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application
that uses the Entity Framework. You create an Entity Data Model (EDM) named Model. You need to
ensure that the Storage Schema Definition Language (SSDL) of the EDM can be modified without
rebuilding the application. What should you do?