Page 1 of 1
DateSet Designer
Posted: Wed 24 Nov 2010 13:05
by degas
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.
Posted: Thu 25 Nov 2010 16:40
by Shalex
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.