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.
The Data Definition Language (DDL) script of the database contains the following code segment:
CREATE TABLE [Sales].[SalesOrderHeader]( [SalesOrderID] [int] IDENTITY(1,1) NOT NULL, [BillToAddressID] [int] NOT NULL, ... CONSTRAINT [PK_SalesOrderHeader_SalesOrderID] PRIMARY KEY CLUSTERED ([SalesOrderID] ASC) )
ALTER TABLE [Sales].[SalesOrderHeader] WITH CHECK ADD CONSTRAINT [FK_SalesOrderHeader_Address] FOREIGN KEY([BilIToAddressID]) REFERENCES [Person].[Address]([AddressID])
You create an ADO.NET Entity Framework model. You need to ensure that the entities of the model
correctly map to the DDL of the database.
What should your model contain?

• A. Option
• B. Option
• C. Option
• D. Option

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the ADO.NET Entity Framework Designer to model entities as shown in the following diagram.

You create an ObjectContext instance named objectContext1 and use it to create a SalesPerson instance
named person1.
You create an ObjectContext instance named objectContext2 and use it to create a SalesTerritory instance
named territory1.
You need to create and persist a relationship between person1 and terrotory1. What should you do?

• A. Attach person1 to objectContext2. Attach territory1 to objectContext1. Set the SalesTerritory property of person1 to territory1. Call SaveChanges on both objectContext1 and objectContext2.
• B. Attach person1 to objectContext2. Detach territory1 from objectContext2. Set the SalesTerritory property of person1 to territory1. Call Refresh on objectContext1.
• C. Detach person1 from objectContext1. Detach territory1 from objectContext2. Set the SalesTerritory property of person1 to territory1. Call Refresh on both objectContext1 and objectContext2.
• D. Detach person1 from objectContext1. Attach person1 to objectContext2. Set the SalesTerritory property of person1 to territory1. Call SaveChanges on objectContext2.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application.
You use the ADO.NET Entity Framework Designer to model entities.
The application includes self-tracking entities as shown in the following diagram.

There is a Person entity names person1 that has TrackChanges turned on.
You need to delete all e-mail addresses that are associated with person1 by using an ObjectContext.
What are two possible code segments that you can use to achieve this goal?
(Each correct answer presents a complete solution. Choose two).

• A. while(person1.EMailAddresses.Count>0){
  person1.EmailAddresses.RemoveAt(0);
  }
  context.SaveChanges();
• B. person1.EMailAddresses = null; context.SaveChanges();
• C. person1.EMailAddresses = new TrackableCollection<EMailAddress>(); context.SaveChanges();
• D. foreach(var email in person1.EMailAddresses){
  email.MarkAsDeleted();
  }
  context.SaveChanges();

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database. The application contains the following
code segment.
string SQL = string.Format("SELECT * FROM Customer WHERE CompanyName LIKE '%
{0}%', companyName);
var cmd = new SqlCommand(SQL, con);
You need to reduce the vulnerability to SQL injection attacks. Which code segment should you use?

• A. string SQL = string.Format("SELECT * FROM " + " Customer Where CompanyName LIKE {0}",
  new SqlCommand("@companyName", string.format("%{0}%", companyName))); var cmd = new SqlCommand(SQL, con);
• B. string SQL = "SELECT" * FROM Customer @companyName; var cmd = new sqlcommand(SQL,con); cmd.Parameters.AddWithValue("companyName", string.format("where companyName LIKE '%{0}%'", companyName));
• C. string SQL = "SELECT * FROM Customer Where " + "CompanyName LIKE @companyName"; var cmd = new SqlCommand(SQL,con); cmd.Parameters.AddWithValue("@companyName", string.Format("%{0}%", companyName));
• D. string SQL = "SELECT * FROM Customer Where " + "CompanyName LIKE @companyName"; var cmd = new SqlCommand(SQL,con); var param = new SqlParameter ("@companyName", string.Format("%{0}%", companyName));