You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database.
You need to ensure that the application calls a stored procedure that accepts a table-valued parameter.
You create a SqlParameter object. What should you do next?

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?

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 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.0 to create an application.
The application connects to a Microsoft SQL Server database.
You use the following SQL statement to retrieve an instance of a DataSet object named ds:

SELECT CustomerID, CompanyName, ContactName, Address, City
FROM dbo.Customers

You need to query the DataSet object to retrieve only the rows where the ContactName field is not NULL. Which code segment should you use?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database.
You create classes by using LINQ to SQL based on the records shown in the exhibit:

You need to create a LINQ query to retrieve a list of objects that contains the OrderID and CustomerID properties.
You need to retrieve the total price amount of each Order record. What are two possible ways to achieve this goal?
(Each correct answer presents a complete solution. Choose two.)

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Communication Foundation (WCF) Data Services service.
You discover that when an application submits a PUT or DELETE request to the Data Services service, it receives an error.
You need to ensure that the application can access the service. Which header and request type should you use in the application?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Communication Foundation (WCF) Data Services service.
The service connects to a Microsoft SQL Server 2008 database. The service is hosted by an Internet Information Services (IIS) 6.0 server.
You need to ensure that applications authenticate against user information stored in the database before the application is allowed to use the service.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

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. You create an entity as shown in the following code fragment.

<EntityType Name=”ProductCategory”>
<Key>
<PropertyRef Name=”ProductCategoryID” />
</Key>
<Property Name=”ProductCategoryID” Type=”int” Nullable=”false” StoreGeneraedPattern=”Identity” />
<Property Name=”ParentProductCategoryID” Type=”int” />
<Property Name=”Name” Type=”nvarchar” Nullable=”false” MaxLength=”50″ />
…
</EntityType>

You need to provide two entity-tracking fields:
* rowguid that is automatically generated when the entity is created
* ModifiedDate that is automatically set whenever the entity is updated.
Which code fragment should you add to the .edmx file?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You manually create your own Context class named AdventureWorksDB that inherits from ObjectContext.
You need to use AdventureWorksDB 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.0 to create an application.
The application connects to a Microsoft SQL Server database. The application uses the ADO.NET Entity Framework to manage order data.
The application makes a Web service call to obtain orders from an order-tracking system.
You need to ensure that the orders are added to the local data store. Which method should you call on the ObjectContext?