TS-MS-NET-Framework-3-5-ADO-NET-Application-Development-Csharp-(70-561-CSharp).pdf

This preview shows page 1 - 4 out of 7 pages.

70-561-CSharpMicrosoftTS- MS .NET Framework 3.5 ADO.NET Application Development
Answer:AQUESTION:94You create an application by using the Microsoft .NET Framework 3.5 and MicrosoftSynchronizationServicesforMicrosoftADO.NET.TheapplicationusesaMicrosoftSQLServer 2005 (Compact Edition) database. This database contains a table named Order.Microsoft Windows Mobilebased devices synchronize data concurrently with the databaseserver. You write the following code segment. (Line numbers are included for referenceonly.)01 public class ServerSyncProvider : DbServerSyncProvider02 {03 public ServerSyncProvider()04 {05 SyncAdapter orderSyncAdapter =06 new SyncAdapter("Order");07 SqlCommand ManageRows = new SqlCommand();08 ManageRows.CommandText =09 "DELETE FROM dbo.Order WHERE OrderId = @OrderId " +10 "AND ((UpdateTS <= @sync_last_received_anchor OR " +11 "UpdateId = @sync_client_id ) OR @sync_force_write=1) " +12 "IF (@@rowcount > 0) UPDATE Sales. Order_Tombstone SET "+13 "DeleteId = @sync_client_id WHERE OrderId = @OrderId";1415 }16 }You need to ensure that the application performs the following tasks: It allows bidirectionalincremental data changes to the Order table.It generates the ClientUpdateServerDeleteaction as a conflict. Which line of code should you insert at line 14?
QUESTION:95You create an application by using the Microsoft .NET Framework 3.5 and Microsoft(Linenumbersare.Youwritethefollowingcodesegmentintheapplication.NET.ADOincluded for reference only.)01 string connString =66
05;";sspwd=pa;uid=user;database=Store;server=localhost"02 SqlConnection conn = new SqlConnection(connString);03 SqlDependency sqlDep = new SqlDependency();04 sqlDep.OnChange += new OnChangeEventHandler(sqlDep_OnChange);06 cmd.ExecuteNonQuery();

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 7 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
Mohammad Alizadeh
Tags
NET Framework, ADO NET, Microsoft SQL Server, Microsoft Visual Studio

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture