This question is locked. New answers and comments are not allowed.
I was looking for information on how to use the 'Converter' property of a column that is visible when you select a column in the Model Schema Explorer. I have a couple columns where I would like to be able to parse whatever data comes out of the DB myself, and it seems like the Converter property of a column might be just what I am looking for. However, I can't find any information about how to use this field, or what it is actually meant to do. Is there a code example or something in the documentation that I am missing?
My issue is that I've got multiple instances of the same basic database that, for various historical reasons, have a few columns that are not defined exactly the same. For example, (in SQL Server anyway) one column might be defined as an 'int' while in a different copy of the DB it would be 'decimal(10)'. Much as I would love to change the datatype on the affected columns, that may not be the easiest option for non-technical reasons. So, I was looking into the possibility of parsing whatever comes back from the DB and putting it into the field myself. It seems like this might be what the Converter property is meant to do, but I can't really tell.
Any help is appreciated,
- Bret
My issue is that I've got multiple instances of the same basic database that, for various historical reasons, have a few columns that are not defined exactly the same. For example, (in SQL Server anyway) one column might be defined as an 'int' while in a different copy of the DB it would be 'decimal(10)'. Much as I would love to change the datatype on the affected columns, that may not be the easiest option for non-technical reasons. So, I was looking into the possibility of parsing whatever comes back from the DB and putting it into the field myself. It seems like this might be what the Converter property is meant to do, but I can't really tell.
Any help is appreciated,
- Bret