[Free] Get all latest Microsoft 70-516 Actual Tests 171-180

EnsurepassQUESTION 171 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the Entity Framework Designer to create an Entity Data Model (EDM). You need to create a database creation script for the EDM. What should you do?   A.       Use a new Self-Tracking Entities template. B.       Drag entities to Server Explorer. C.        Run the Generate Database Read more [...]

[Free] Get all latest Microsoft 70-516 Actual Tests 191-200

EnsurepassQUESTION 191 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.   SQLConnection conn = new SQLConnection(connectionString); conn.Open(); SqlTransaction tran = db.BeginTransaction(IsolationLevel. ...); ...   You must retrieve not commited records originate from various transactions. Which method should you use?   A.       ReadUncommited Read more [...]

[Free] Get all latest Microsoft 70-516 Actual Tests 181-190

EnsurepassQUESTION 181 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 of the ADO.NET Entity Framework to retrieve data from the database. You need to define a custom function in the conceptual model. You also need to ensure that the function calculates a value based on properties of the object. Which two XML element types should you use? (Each correct answer presents part Read more [...]

[Free] Get all latest Microsoft 70-516 Actual Tests 171-180

EnsurepassQUESTION 171 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the Entity Framework Designer to create an Entity Data Model (EDM). You need to create a database creation script for the EDM. What should you do?   A.       Use a new Self-Tracking Entities template. B.       Drag entities to Server Explorer. C.        Run the Generate Database Read more [...]

[Free] Get all latest Microsoft 70-516 Actual Tests 161-170

EnsurepassQUESTION 161 The database contains orphaned Color records that are no longer connected to Part records. You need to clean up the orphaned records. You have an existing ContosoEntities context object named context. Which code segment should you use?   A.       var unusedColors = context.Colors.Where(c => !c.Parts.Any()).ToList(); foreach (var unused in unusedColors){ context.DeleteObject(unused) } context.SaveChanges();   B.       Read more [...]

[Free] Get all latest Microsoft 70-516 Actual Tests 151-160

EnsurepassQUESTION 151 You are working with an ObjectContext object that targets the mainframe and another ObjectContext object that targets SQL Server. When it's time to save the changes, you want all changes to be sent to the mainframe and to SQL Server as one transaction. How can you accomplish this?   A.       Just save both ObjectContext objects because they automatically join the same transaction. B.       Save to the mainframe Read more [...]

[Free] Get all latest Microsoft 70-516 Actual Tests 141-150

EnsurepassQUESTION 141 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. The application uses a Microsoft ADO. NET SQL Server managed provider. When a connection fails, the application logs connection information, including the full connection string. The information is stored as plain text in a .config file. You need to ensure that the database credentials are secure. Which connection Read more [...]

[Free] Get all latest Microsoft 70-516 Actual Tests 131-140

EnsurepassQUESTION 131 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You use the ADO.NET Entity Framework to model your entities. You use Plain Old CLR Objects (POCO) entities along with snapshot-based change tracking. The code accesses the POCO entities directly. You need to ensure that the state manager synchronizes when changes are made to the object graph. Which ObjectContext method should you call?   A.       Read more [...]

[Free] Get all latest Microsoft 70-516 Actual Tests 121-130

EnsurepassQUESTION 121 You want to execute a SQL insert statement from your client application, so you set the CommandText property of the command object and open the connection. Which method will you execute on the command?   A.       ExecuteScalar B.       ExecuteXmlReader C.        ExecuteReader D.       ExecuteNonQuery   Correct Answer: D     QUESTION Read more [...]

[Free] Get all latest Microsoft 70-516 Actual Tests 111-120

EnsurepassQUESTION 111 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 define a Category class by writing the following code segment. (Line numbers are included for reference only.)   01 public class Category 02 { 03 public int CategoryID { get; set; } 04 public string CategoryName { get; set; } 05 public string Description { get; set; } 06 public byte[] Picture { get; set; Read more [...]

[Free] Get all latest Microsoft 70-516 Actual Tests 101-110

EnsurepassQUESTION 101 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 create a Plain Old CLR Object (POCO) class that can be used with the ObjectContext.CreateObject method to create a proxy. What should you do?   A.       Create a custom data class that has a Protected constructor that does not have parameters. B.       Read more [...]

[Free] Get all latest Microsoft 70-516 Actual Tests 91-100

EnsurepassQUESTION 91 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that uses the ADO.NET Entity Framework to model entities. You create an entity model as shown in the following diagram.     You need to ensure that all Person entities and their associated EmailAddresses are loaded. Which code segment should you use?   A.       var people = context.People.Include("EmailAddresses").ToList(); B.       Read more [...]
1 2