I am getting an ES object back from an SQL view. Two of the fields are Money fields but when I look at them in the ES object they are decimal and not currency or money. Any reason for this? I would like to check the datatype of each column and apply formatting to a grid but how can I tell the difference between a money column and a column that would be decimal in SQL?

I'm a little confused, perhaps I'm misunderstanding your question. In C# or VB there aren't "currency" or "money" types, there's only decimal or float. If you need to determine the underlying physical data type of a column though you can do this:

 

 

Does this help? 

---

EntitySpaces | Twitter | BLOG | Please honor our Software License

Oh duh - forget about that, that was a VB 6.0 moment.