Microsoft 070-516 valid study dumps : TS: Accessing Data with Microsoft .NET Framework 4

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the Entity Framework.
The application defines the following Entity Data Model.

Within the .edmx file, the following function is defined:
<Function Name="Round" ReturnType="Decimal"> <Parameter Name="val" Type="Decimal" /> <DefiningExpression>
CAST(val as Edm.Int32) </DefiningExpression> </Function>
The application includes the following LINQ query.
var query = from detail in context.SalesOrderDetails select detail.LineTotal.Round();
You need to ensure that the Round function executes on the database server when the query is executed. Which code segment should you use?

• A. public static class DecimalHelper
  {
  [EdmFunction("SqlServer", "Round")]
  public static Decimal Round(this Decimal Amt)
  {
  throw new NotSupportedException();
  }
  }
• B. public static class DecimalHelper
  {
  [EdmFunction("Edm", "Round")]
  public static Decimal Round(this Decimal Amt)
  {
  throw new NotSupportedException();
  }
  }
• C. public static class DecimalHelper
  {
  public static Decimal Round(this Decimal input)
  {
  return (Decimal)(Int32)input;
  }
  }
• D. public static class DecimalHelper
  {
  public static SqlDecimal Round(this Decimal input)
  {
  return SqlDecimal.Round(input, 0);
  }
  }

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 develop an application that
connects to a Microsoft SQL Server 2008 database.
You use the ADO.NET Entity Framework Designer to model entities. You add the following stored
procedure to the database, and you add a function import to the model.
CREATE PROCEDURE [dbo].[InsertDepartment] @Name nvarchar(50), @ID int NULL OUTPUT
AS INSERT INTO Department (Name) VALUES (@Name) SELECT @ID = SCOPE_IDENTITY()
You need to insert a new department and display the generated ID. Which code segment should you use?

• A. using (SchoolEntities context = new SchoolEntities())
  {
  var id = context.InsertDepartment("Department 1", null);
  Console.WriteLine(id);
  }
• B. using (SchoolEntities context = new SchoolEntities())
  {
  var id = new ObjectParameter("ID", null));
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }
• C. using (SchoolEntities context = new SchoolEntities())
  {
  var id = new ObjectParameter("ID", typeof(int));
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }
• D. using (SchoolEntities context = new SchoolEntities())
  {
  ObjectParameter id = null;
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }

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. You create stored procedures by using the following signatures:
CREATE procedure [dbo].[Product_Insert](@name varchar(50),@price float)
CREATE procedure [dbo].[Product_Update](@id int, @name varchar(50), @price
float)
CREATE procedure [dbo].[Product_Delete](@id int)
CREATE procedure [dbo].[Order_Insert](@productId int, @quantity int)
CREATE procedure [dbo].[Order_Update](@id int, @quantity int,@originalTimestamp
timestamp)
CREATE procedure [dbo].[Order_Delete](@id int)
You create a Microsoft ADO.NET Entity Data Model (EDM) by using the Product and Order entities as shown in the exhibit:

You need to map the Product and Order entities to the stored procedures. To which two procedures should
you add the @productId parameter?
(Each correct answer presents part of the solution. Choose two.)

• A. Order_Delete
• B. Product_Update
• C. Product_Delete
• D. Order_Update

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

You use Microsoft .NET Framework 4.0 to develop an application that connects to two separate Microsoft
SQL Server 2008 databases.
The Customers database stores all the customer information, and the Orders database stores all the order
information.
The application includes the following code. (Line numbers are included for reference only.)
01 try
02 {
03 conn.Open();
04 tran = conn.BeginTransaction("Order");
05 SqlCommand cmd = new SqlCommand();
06 cmd.Connection = conn;
07 cmd.Transaction = tran;
08 tran.Save("save1");
09 cmd.CommandText = "INSERT INTO [Cust].dbo.Customer " + "(Name,
PhoneNumber) VALUES ('Paul Jones', " + "'404-555-1212')";
10 cmd.ExecuteNonQuery();
11 tran.Save("save2");
12 cmd.CommandText = "INSERT INTO [Orders].dbo.Order " + "(CustomerID)
VALUES (1234)";
13 cmd.ExecuteNonQuery();
14 tran.Save("save3");
15 cmd.CommandText = "INSERT INTO [Orders].dbo." + "OrderDetail (OrderlD,
ProductNumber) VALUES" + "(5678, 'DC-6721')";
16 cmd.ExecuteNonQuery();
17 tran.Commit();
18 }
19 catch (Exception ex)
20 {
21 ...
22 }
You run the program, and a timeout expired error occurs at line 16. You need to ensure that the customer
information is saved in the database.
If an error occurs while the order is being saved, you must roll back all of the order information and save the
customer information.
Which line of code should you insert at line 21?

• A. tran.Rollback(); tran.Commit();
• B. tran.Rollback("save2"); tran.Commit();
• C. tran.Rollback();
• D. tran.Rollback("save2");

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 contains the following XML document:
<bib> <book title="TCP/IP Illusrated" year="1994">
<author>Author1</author>
</book>
<book title="Programming in UNIX" year="1992">
<author>Author1</author>
<author>Author2</author>
<author>Author3</author>
</book>
<book title="Data on the web" year="2000">
<author>Author4</author>
<author>Author3</author>
</book> </bib>
You add the following code fragment. (Line numbers are included for reference only.)
01 public IEnumerable<XElement> GetBooks(string xml)
02 {
03 XDocument doc = XDocument.Parse(xml);
04 ...
05 }
You need to return a list of book XML element that are authored by Author1. Which code segment should you insert at line 04?

• A. return doc.Elements("bib").Elements() .Where(e1 => e1.Elements().Any(e2 => (string)e2 == "Author1"));
• B. return doc.Element("bib").Elements() .SelectMany(el => el.Elements() .Where(e2 => (string)e2 == "Author1"));
• C. return doc.Element("bib").Elements() .SelectMany(el => el.Elements() .Where(e2 => e2.Equals(new XElement("author", "Author1"))));
• D. return doc.Elements("bib").Elements()
  .Where(e1 => e1.Elements().Any(e2 => e2.Equals(new XElement("author", "Author1"))));