Is is possible set a value of bool in the datatable and in the database stored it as a VARCHAR(1), values like Y or N, directly from de DataSetDesigner.
I would like to propose that the DataSetWizard, could have the naming functionality for columns, that the EntityDeveloper.
DateSet Designer
We recommend you using the NUMBER(1) data type for storing boolean values in Oracle. Here is a walkthrough for making the NUMBER(1) column value to be mapped to System.Boolean:
1. Current version.
Change manually the NUMBER(1) column type in DataSet.xsd (open it with XML Editor) from type="xs:int" to type="xs:boolean" in this node:
.
2. Starting from the upcoming build.
Add to your connection string (it also will be possible in design time with Devart DataSet Wizard) such mapping:
Number Mappings =(INTEGER,1,1,System.Boolean);.
After this, NUMBER(1) is mapped to System.Boolean automatically.
Column mappings in DataSet can be set on the 4th step of Devart DataSet Wizard.
1. Current version.
Change manually the NUMBER(1) column type in DataSet.xsd (open it with XML Editor) from type="xs:int" to type="xs:boolean" in this node:
.
2. Starting from the upcoming build.
Add to your connection string (it also will be possible in design time with Devart DataSet Wizard) such mapping:
Number Mappings =(INTEGER,1,1,System.Boolean);.
After this, NUMBER(1) is mapped to System.Boolean automatically.
Column mappings in DataSet can be set on the 4th step of Devart DataSet Wizard.