This content has been marked as final. Show 1 reply
Just to be clear, you have a table with a number column in it, and you want it to be a string on the EF side?
I tried to do it with an EDM Mapping to convert numbers into strings, and the EF Provider did not like that. Honestly I didn't expect it to, but it seemed like something worth trying. :)
Next I tried just making a model from a table with a number on it, and changing that to a string. It didn't like that either. If you also had no luck by doing it in the CSDL & SSDL, I'm out of ideas for how to do it directly.
The most practical workaround is to create a view that calls TO_CHAR on the number column, and have EF work against the view.