|
The custom data tables are very limited by the fact, that the bit and datetime field data type is not supported. These data types are widely used and should be supported at least on API side, so one can insert rows with such types.
Using YesNo enum (m_code) is not an option as there needs to be then put an additional join just for filtering records based on bit flag, not to mention that the performance and maintanability of such code degrades.
Also DateTime does not have an alternative solution if one wants to store time part.
Thanks for any feedback on this.
|