Microsoft 70-516 valid exam dumps : TS: Accessing Data with Microsoft .NET Framework 4

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 following object query to load a product from the database.
(Line numbers are included for reference only.)
01 using (AdventureWorksEntities advWorksContext = new AdventureWorksEntities
())
02 {
03 ObjectQuery <Product> productQuery = advWorksContext.Product.Where
("it.ProductID = 900");
04 ...
05 }
You need to log the command that the query executes against the data source. Which code segment should you insert at line 04?

• A. Trace.WriteLine(productQuery.CommandText);
• B. Trace.WriteLine(((IQueryable)productQuery).Expression);
• C. Trace.WriteLine(productQuery.ToTraceString());
• D. Trace.WriteLine(productQuery.ToString());

Explanation: Only visible for ValidDumps members. You can sign-up / login (it's free).

The application user interface displays part names or color names in many plases as '## Name ##'.
You need to provide a method named FormattedName() to format part names and color names throughout
the
application. What should you do?

• A. Add the following code segment to the ExtensionMethods class in ExtensionMethods.cs:
  public static string FormattedName (this Color entity){
  return string.Format("## {0} ##", entity.Name)
  }
• B. Add the following code segment to the ExtensionMethods class in ExtensionMethods.cs:
  public static string FormattedName (this Part entity){
  return string.Format("## {0} ##", entity.Name)
  }
• C. Add the following code segmend to the Color class in Color.cs:
  public string FormattedName(){
  return string.Format("## {0} ##", this.Name);
  }
• D. Add the following code segmend to the Part class in Part.cs:
  public string FormattedName(){
  return string.Format("## {0} ##", this.Name);
  }
• E. Add the following code segment to the ExtensionMethods class in ExtensionMethods.cs:
  public static string FormattedName (this IName entity){
  return string.Format("## {0} ##", entity.Name)
  }

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to develop an application.
You use entity Framework Designer to create an Entity Data Model from an existing database by using the
Generate From Database wizard.
The model contains an entity type named Product. The Product type requires an additional property that is
not mapped to database colomn.
You need to add the property to product. What should you do?

• A. Add the property in the generated class file, and select Run Custom Tool from the solution menu.
• B. Add the property in a partial class named Product in a new source file.
• C. Create a function import with the name of property in the Entity Framework Designer.
• D. Create a comlex type with the name of the property in the Entity Framework Designer.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the Entity Framework.
The application has an entity model that contains a SalesOrderHeader entity. The entity includes an
OrderDate property of type DateTime.
You need to retrieve the 10 oldest SalesOrderHeaders according to the OrderDate property.
Which code segment should you use?

• A. var model = new AdventureWorksEntities(); var sales = model.SalesOrderHeaders.OrderByDescending(soh => soh.OrderDate).Take(10);
• B. var model = new AdventureWorksEntities(); var sales = model.SalesOrderHeaders.OrderBy(soh => soh.OrderDate).Take(10);
• C. var model = new AdventureWorksEntities(); var sales = model.SalesOrderHeaders.Take(10).OrderBy(soh => soh.OrderDate);
• D. var model = new AdventureWorksEntities(); var sales = model.SalesOrderHeaders.Take(10).OrderByDescending(soh => soh.OrderDate);

Explanation: Only visible for ValidDumps members. You can sign-up / login (it's free).

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?

• A. from row in ds.Tables[0].AsEnumerable() where row.Field<string>("ContactName") != null select row;
• B. from row in ds.Tables[0].AsEnumerable() where !row.IsNull((string)row["ContactName"]) select row;
• C. from row in ds.Tables[0].AsEnumerable() where (string)row["ContactName"] != null select row;
• D. from row in ds.Tables[0].AsEnumerable() where !Convert.IsDBNull(row.Field<string>("ContactName")) select row;

Explanation: Only visible for ValidDumps members. You can sign-up / login (it's free).