70-516 무료 덤프문제 온라인 액세스

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 model contains an entity type
named Product.
You need to ensure that a stored procedure will be invoked when the ObjectContext.SaveChanges method
is executed after an attached Product has changed.
What should you do in the ADO.NET Entity Framework Designer?

• A.Add a stored procedure mapping for the Product entity type.
• B.Add a function import for the Product entity type.
• C.Add a new entity that has a base class of Product that is mapped to the stored procedure.
• D.Add a complex type named Product that is mapped to the stored procedure.

You use Microsoft .NET Framework 4.0 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.GetClassAndStudents AS BEGIN
SELECT * FROM dbo.Class
SELECT * FROM dbo.Student
END
You create a SqIConnection named conn that connects to the database.
You need to fill a DataSet from the result that is returned by the stored procedure.
The first result set must be added to a DataTable named Class, and the second result set must be added to
a DataTable named Student.
Which code segment should you use?

• A.DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.Fill(ds);
• B.DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ds.Tables.Add("Class"); ds.Tables.Add("Student"); ad.Fill(ds);
• C.DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.TableMappings.Add("Table", "Class"); ad.TableMappings.Add("Table1", "Student") ; ad.Fill(ds) ;
• D.DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.MissingMappingAction = MissingMappingAction.Ignore; ad.Fill(ds, "Class"); ad.Fill(ds, "Student");

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 a DataTable named OrderDetailTable that has the following columns:
-ID
-OrderID
-ProductID
-Quantity
-LineTotal
Some records contain a null value in the LineTotal field and 0 in the Quantity field. You write the following code segment. (Line numbers are included for reference only.)
01 DataColumn column = new DataColumn("UnitPrice", typeof(double));
02 ...
03 OrderDetailTable.Columns.Add(column);
You need to add a calculated DataColumn named UnitPrice to the OrderDetailTable object.
You also need to ensure that UnitPrice is set to 0 when it cannot be calculated.
Which code segment should you insert at line 02?

• A.column.Expression = "LineTotal/Quantity";
• B.column.Expression = "if(Quantity > 0, LineTotal/Quantity, 0)";
• C.column.Expression = "LineTotal/ISNULL(Quantity, 1)";
• D.column.Expression = "iif(Quantity > 0, LineTotal/Quantity, 0)";

Refer to the following lines in the case study: PA40 in \Model\Part.cs, PR16 in\Model\Product.cs, and CT14 in \Model\Component.cs
The application must create XML files that detail the part structure for any product. The XML files must use the following format:
<?xml version="1.0" encoding="utf-8"?>
<product name="Brush" description="Brush product" productType="1">
<component name="Handle" description="Handle" partType="2">
<component name="Screw" description="Screw" partType="3">
<component name="Wood" description="Wooden shaft" partType="45">
</component>
<component name="Head" description="Head" partType="5">
<component name="Screw" description="Screw" partType="3">
<component name="Bristles" description="Bristles" partType="4">
</component> </product>
You need to update the application to support the creation of an XElement object having a structure that will
serialize to the format shown above.
What should you do? (Each correct answer presents part of the solution. Choose two.)

• A.Insert the following code segment at line CT14 in \Model\Component.cs:
  return new XElement("component, new XElement("name", this.Name),
  new XElement("description", this.Description),
  new XElement("partType", this.PartType));
• B.Insert the following code segment at line PR16 in \Model\Product.cs:
  return new XElement("product, new XAttribute("name", this.Name),
  new XElement("description", this.Description),
  new XElement("productType", this.ProductType));
• C.Insert the following code segment at line CT14 in \Model\Component.cs:
  return new XElement("component, new XAttribute("name", this.Name),
  new XElement("description", this.Description),
  new XElement("partType", this.PartType));
• D.Insert the following code segment at line PR16 in \Model\Product.cs:
  return new XElement("product, new XElement("name", this.Name),
  new XElement("description", this.Description),
  new XElement("productType", this.ProductType));
• E.Insert the following code segment at line CT14 in \Model\Component.cs:
  return new XElement("component, new XAttribute("name", this.Name),
  new XAttribute("description", this.Description),
  new XAttribute("partType", this.PartType));
• F.Insert the following code segment at line PR16 in \Model\Product.cs:
  return new XElement("product, new XAttribute("name", this.Name),
  new XAttribute("description", this.Description),
  new XAttribute("productType", this.ProductType));

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.
You need to ensure that the entities are self-tracking. What should you do in the ADO.NET Entity
Framework Designer?

• A.Add an ADO.NET EntityObject Generator to the model.
• B.Change the Transform Related Text Templates On Save option to False.
• C.Add an ADO.NET Self-Tracking Entity Generator to the model.
• D.Change the Code Generation Strategy option from Default to None.