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

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the EntityFramework.
The application has an entity named Person. A Person instance named person1 and an ObjectContext
instance named model exist.
You need to delete the person1 instance. Which code segment should you use?

• A.model.ExecuteStoreCommand("Delete", new []{new ObjectParameter("Person", person1)}; model.SaveChanges();
• B.model.DeleteObject(person1); model.SaveChanges();
• C.model.Detach(person1); model.SaveChanges();
• D.model.ExecuteStoreCommand("Detach", new []{new ObjectParameter("Person", person1)}; model.SaveChanges();

You use Microsoft .NET Framework 4.0 to develop an application that uses the Entity Framework.
The application defines the following Entity SQL (ESQL) query, which must be executed against the mode.
string prodQuery = "select value p from Products as p where
p.ProductCategory.Name = @p0";
You need to execute the query. Which code segment should you use?

• A.var prods = ctx.ExecuteStoreQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• B.var prods = ctx.CreateQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• C.var prods = ctx.ExecuteStoreCommand(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• D.var prods = ctx.ExecuteFunction<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses LINQ to SQL.
You create a data model name AdvWorksDataContext, and you add the Product table to the data model.
The Product table contains a decimal column named ListPrice and a string column named Color.
You need to update ListPrice column where the product color is Black or Red. Which code segment should
you use?

• A.AdvWorksDataContext dc = new AdvWorksDataContext("..."); var prod = from p in dc.Products
  select p;
  var list = prod.ToList();
  foreach(Product product in list){
  if(product.Color == "Black, Red"){
  product.ListPrice = product.StandardCost * 1.5M;
  }
  }
  dc.SubmitChanges();
• B.string[] colorList = new string[] {"Black", "Red"}; AdvWorksDataContext dc = new AdvWorksDataContext(); var prod = from p in dc.Products
  where colorList.Contains(p.Color)
  select p;
  foreach(var product in prod){
  product.ListPrice = product.StandardCost * 1.5M;
  }
  dc.SubmitChanges();
• C.AdvWorksDataContext dc = new AdvWorksDataContext("..."); var prod = from p in dc.Products
  select p;
  var list = prod.ToList();
  foreach(Product product in list){
  if((product.Color == "Black) && (product.Color == "Red")){
  product.ListPrice = product.StandardCost * 1.5M;
  }
  }
  dc.SubmitChanges();
• D.AdvWorksDataContext dc = new AdvWorksDataContext("...");
  var prod = from p in dc.Products
  where p.Color == "Black, Red"
  select p;
  foreach(var product in prod){
  product.ListPrice = product.StandardCost * 1.5M;
  }
  dc.SubmitChanges();

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 associate a previously deserialized entity named person1 to an object context named model
and persist changes to the database.
Which code segment should you use?

• A.model.People.Attach(person1); model.SaveChanges();
• B.person1.AcceptChanges(); model.SaveChanges();
• C.model.AttachTo("People", person1); model.SaveChanges();
• D.model.People.ApplyChanges(person1) ; model.SaveChanges();

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?

• A.Set the SqlDbType of SqlParameter to Udt.
• B.Set the ParameterDirection of SqlParameter to Output.
• C.Set the SqlDbType of SqlParameter to Structured. Set the TypeName of SqlParameter to Udt.
• D.Set the SqlDbType of SqlParameter to Variant.