DateSet Designer

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 77
Joined: Mon 16 Feb 2009 18:36
Location: Argentina

DateSet Designer

Post by degas » Wed 24 Nov 2010 13:05

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.

Site Admin
Posts: 8239
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 25 Nov 2010 16:40

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.

Post Reply