I am facing a weird problem with database checkpoint beign parameterized,when the connection string is being parameterized to an environment variable during run time I am seeing some gibberish value being assigned rather than than actual value due to which the checkping ins failing.
It says as below:
The checkpoint failed because the query returned an empty result set. You specified the following dbtable property values: Connection string: &#65316;&#2336;&#61732;&#2573;.
I also tried the bleow using seto property, but still same issue.
when you are inserting values to your application. keep those values in array arr1.next connect to the DB and fetch the values to an array arr2.
now compare both arrays.
when you are inserting values to your application. keep those values in dictionary objDic1.Next connect to the DB and fetch the values to dictionary objDic2.
now compare both objDic1 vs objDic2.
i recommend second option as it is easy & clear.