You create a Microsoft Windowsbased application by using the Microsoft .NET Framework 3.5 andnMicrosoft Synchronization Services for Microsoft ADO.NET. The application uses a Microsoft SQL Server 2005 database.
To synchronize data, the application connects to a table named Leads that contains a column named State.
You write the following code segment.
SqlConnection cn = new SqlConnection("SERVER=myServer;DATABASE=CRMDb;");
SqlSyncAdapterBuilder bldr = new SqlSyncAdapterBuilder(cn);
You need to ensure that the application partitions the data horizontally.
Which code segment should you add?
A.
bldr.CreationTrackingColumn = "State";
B.
bldr.TombstoneDataColumns.Add("State");
C.
bldr.FilterClause = "STATE=@STATE";
bldr.FilterParameters.Add(new SqlParameter("@STATE", userState));
D.
bldr.TombstoneFilterClause = "STATE=@STATE";
bldr.TombstoneFilterParameters.Add(new SqlParameter("@STATE",userState));