rowversion, or how to exclude a column from a mapping

RangerDick

Hi!

I need guidance on how to exclude a field from the data comparison.

This particular field is being used as a high water mark in the tables and it is a rowversion type (timestamp). Does the SDK automaticall exclude them on comparison, or do I have to explicitly exclude them? Does it matter if I am using them in the where clause for comparison?

A brief example would be most welcomed. I have found a sample using the tablemapping.fieldmapping.add but not for the remove.

Thanks,
RD

James B

Thanks for your post- it looks like one of the examples on our SDK page may help: see here - although I just spotted you mailed us to say you're okay now, so if you already worked it out that's great!

RangerDick

Thanks for the support. I did not find a direct sample (perhaps I missed it). This was my solution in C#:

mapping.FieldMappings.Remove(mapping.FieldMappings["FieldName"]);

James B

Yeah, that'll work - you can either code them specifically or iterate through a collection of names obtained from "somewhere"