You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application uses the ADO.NET Entity Framework to model entities.
The application includes a Customer entity along with a CustomerKey property of the Guid type as shown in
the following exhibit:

You discover that when the application adds a new instance of a Customer, calling the SaveChanges
method
results in the following error message: "Server generated keys are only supported for identity columns."
You need to ensure that the application can add new Customer entities. What should you do?

• A. Add a handler for the ObjectContext.SavingChanges event. In the event handler, set the CustomerKey value.
• B. Add a handler for the ObjectContext.ObjectMaterialized event. In the event handler, set the CustomerKey value.
• C. Call the ObjectContext.Attach method before saving a Customer entity.
• D. Call the ObjectContext.CreateEntityKey method before saving a Customer entity.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You create a Database Access Layer (DAL) that is database-independent. The DAL includes the following
code segment.
(Line numbers are included for reference only.)
01 static void ExecuteDbCommand(DbConnection connection)
02 {
03 if (connection != null){
04 using (connection){
05 try{
06 connection.Open();
07 DbCommand command = connection.CreateCommand();
08 command.CommandText = "INSERT INTO Categories (CategoryName)
VALUES ('Low Carb')";
09 command.ExecuteNonQuery();
10 }
11 ...
12 catch (Exception ex){
13 Trace.WriteLine("Exception.Message: " + ex.Message);
14 }
15 }
16 }
17 }
You need to log information about any error that occurs during data access.
You also need to log the data provider that accesses the database. Which code segment should you insert
at line 11?

• A. catch (OleDbException ex){ Trace.WriteLine("ExceptionType: " + ex.Source);
  Trace.WriteLine("Message: " + ex.Message);
  }
• B. catch (DbException ex){ Trace.WriteLine("ExceptionType: " + ex.InnerException.Source);
  Trace.WriteLine("Message: " + ex.InnerException.Message);
  }
• C. catch (DbException ex){ Trace.WriteLine("ExceptionType: " + ex.Source);
  Trace.WriteLine("Message: " + ex.Message);
  }
• D. catch (OleDbException ex){ Trace.WriteLine("ExceptionType: " + ex.InnerException.Source);
  Trace.WriteLine("Message: " + ex.InnerException.Message);
  }

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 and contains a LINQ to SQL data model.
The data model contains a function named createCustomer that calls a stored procedure.
The stored procedure is also named createCustomer. The createCustomer function has the following
signature.
createCustomer (Guid customerID, String customerName, String address1)
The application contains the following code segment. (Line numbers are included for reference only.)
01 CustomDataContext context = new CustomDataContext(); 02 Guid userID = Guid.NewGuid();
03 String address1 = "1 Main Steet";
04 String name = "Marc";
05 ...
You need to use the createCustomer stored procedure to add a customer to the database. Which code segment should you insert at line 05?

• A. context.createCustomer(userID, customer1, address1);
• B. context.ExecuteCommand("createCustomer", userID, customer1, address1); Customer customer = new Customer() { ID = userID, Address1 = address1, Name = customer1, };
• C. context.ExecuteQuery(typeof(Customer), "createCustomer", customer);
• D. context.ExecuteCommand("createCustomer", customer); Customer customer = new Customer() { ID = userID, Address1 = address1, Name = customer1, };

You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL Server
2008 database.
You add the following stored procedure to the database.
CREATE PROCEDURE [dbo].[InsertTag] @Name nvarchar (15)
AS INSERT INTO [dbo].[Tags] (Name) VALUES(@Name) RETURN @@ROWCOUNT
You need to invoke the stored procedure by using an open SqlConnection named conn. Which code segment should you use?

• A. SqlCommand cmd = new SqlCommand("InsertTag", conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Name", "New Tag 1"); cmd.ExecuteNonQuery();
• B. SqlCommand cmd = new SqlCommand("EXEC InsertTag", conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Name", "New Tag 1"); cmd.ExecuteNonQuery();
• C. SqlCommand cmd = new SqlCommand("InsertTag", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", "New Tag 1"); cmd.ExecuteNonQuery();
• D. SqlCommand cmd = new SqlCommand("EXEC InsertTag", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", "New Tag 1"); cmd.ExecuteNonQuery();

You develop a Microsoft .NET application that uses Entity Framework to store entities in a Microsft SQL
Server 2008 database.
While the application is disconnected from the database, entities that are modified, are serialized to a local
file.
The next time the application connects to the database, it retrieves the identity from the database by using
an object context
named context and stores the entity in a variable named remoteCustomer.
The application then serializes the Customer entity from the local file and stores the entity in a variable
named localCustomer.
The remoteCustomer and the localCustomer variables have the same entity key.
You need to ensure that the offline changes to the Customer entity is persisted in the database when the
ObjectContext.SaveChanges() method is called.
Which line of code should you use?

• A. context.ApplyCurrentValues("Customers", remoteCustomer);
• B. context.ApplyOriginalValues("Customers", localCustomer);
• C. context.ApplyCurrentValues("Customers", localCustomer);
• D. context.ApplyOriginalValues("Customers", remoteCustomer);