GetValueOrDefault() missing after second configure
Posted: Fri 20 Mar 2015 07:42
Hello. I use Visual Studio Professional 2013 with dotConnect for PostgreSql 7.3.359. I have this simple table:
In VS I have a DataSet with a TableAdapter with a Fill and GetData:
Click the TableAdapter - Add Query - Use SQL statements - Select which returns a single value - Next - - Next - Finish.
Now I can do:
Now, if I go to the TableAdapter and reconfigure the SQL statement without modifying anything the GetPresent(2) returns object and thus I can't use GetValueOrDefault();
Am I doing something wrong or is this a little bug?
Thanks.
Code: Select all
CREATE TABLE test
(
id serial NOT NULL,
name character varying(200) NOT NULL,
data date NOT NULL,
present boolean NOT NULL DEFAULT false,
CONSTRAINT test_pkey PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
ALTER TABLE test
OWNER TO postgres;Code: Select all
SELECT id, "name", "data", present FROM "public".testClick the TableAdapter - Add Query - Use SQL statements - Select which returns a single value - Next -
Code: Select all
SELECT present FROM test where id=:idNow I can do:
Code: Select all
var taAdapter = new testTableAdapter();
var valueTest1 = taAdapter.GetPresent(2).GetValueOrDefault();
//GetPresent(2) returns ?bool
Now, if I go to the TableAdapter and reconfigure the SQL statement without modifying anything the GetPresent(2) returns object and thus I can't use GetValueOrDefault();
Am I doing something wrong or is this a little bug?
Thanks.