Re: [Firebird-net-provider] Handling of boolean in .Net Provider 4.6.2

[Christian W. <chr...@rt...>]

Thanks for the info
I will do some test with a SMALLINT field.

Happy coding
Chris
> -----Ursprüngliche Nachricht-----
> Von: Геннадий Забула [mailto:zab...@gm...]
> Gesendet: Freitag, 26. Juni 2015 15:11
> An: chr...@rt...; For users and developers of the
> Firebird .NET providers
> Betreff: Re: [Firebird-net-provider] Handling of boolean in .Net
> Provider 4.6.2
> 
> We are using SMALLINT type in our project.
> FB EF provider also generates tables with SMALLINT fields for code-
> first class fields.
> 
> On 26 June 2015 at 14:49, Christian Waldmann <christian.waldmann@rte-
> ag.ch> wrote:
> > I am using Firebird 2.5.4, superServer and embedded, Visula Studio
> > 2013, .Net Framework 4.5.1, .Net Provider 4.6.2
> >
> >
> //====================================================================
> > ======
> > =================
> > I have defined a table with "CyclePassed" CHAR(1) to store a boolean
> > result
> >
> > CREATE TABLE "SampleSummaries" (
> >     "UniqueId"            BIGINT DEFAULT 0 NOT NULL,
> >     "EndTestRunId"        BIGINT NOT NULL,
> >     "Cycle"               BIGINT NOT NULL,
> >     "LoadPressure"        FLOAT,
> >     "LoadPressureMin"     FLOAT,
> >     "LoadPressureMax"     FLOAT,
> >     "ShutoffPressure"     FLOAT,
> >     "ShutoffPressureMin"  FLOAT,
> >     "ShutoffPressureMax"  FLOAT,
> >     "TravelTime"          FLOAT,
> >     "TravelTimeMin"       FLOAT,
> >     "TravelTimeMax"       FLOAT,
> >     "CyclePassed"         CHAR(1)
> > );
> >
> >
> >
> //====================================================================
> > ======
> > =================
> > // access to table from C#
> >
> > bool cyclePassed = true;
> > FbCommand command = new FbCommand();
> >
> > command.CommandText =
> >         "INSERT INTO \"SampleSummaries\" (" +
> >       "\"EndTestRunId\", \"Cycle\", " +
> >       "\"LoadPressure\", \"LoadPressureMin\", \"LoadPressureMax\", "
> +
> >       "\"ShutoffPressure\", \"ShutoffPressureMin\",
> > \"ShutoffPressureMax\", " +
> >       "\"TravelTime\", \"TravelTimeMin\", \"TravelTimeMax\",
> > \"CyclePassed\"" +
> >       ") VALUES  (@EndTestRunId, @Cycle, " +
> >       "@LoadPressure, @LoadPressureMin, @LoadPressureMax, " +
> >       "@ShutoffPressure, @ShutoffPressureMin, @ShutoffPressureMax," +
> >       "@TravelTime, @TravelTimeMin, @TravelTimeMax, @CyclePassed )";
> >
> > command.Connection = samplesTableAdapter.Connection;
> > command.Transaction = transaction;
> >
> > command.Parameters.Add("@EndTestRunId", FbDbType.BigInt).Value =
> channelId;
> >             ...
> >
> > // PROBLEM A:
> >
> ======================================================================
> > ======
> > ==============
> > // works with stand alone server,
> > // but SQL error "string conversion error '49'"
> > // {Remark: 49 is the decimal ASCII code of '1'}
> > command.Parameters.Add("@CyclePassed", FbDbType.Boolean).Value =
> > cyclePassed ? '1' : '0';
> >
> > // PROBLEM B:
> >
> ======================================================================
> > ======
> > ==============
> > // works with embedded server,
> > // but "string truncation error" with stand alone server
> > command.Parameters.Add("@CyclePassed", FbDbType.Boolean).Value =
> > cyclePassed;
> >
> > // REMARK:
> >
> ======================================================================
> > ======
> > ==============
> > // works with embedded server and standalone server Firebird 2.5.3,
> > with .Net Provider 2.0, .Net Framework 2.0, Visual Studio 2008
> > command.Parameters.Add("@CyclePassed", FbDbType.Boolean).Value =
> > cyclePassed;
> >
> > // QUESTION
> >
> ======================================================================
> > ======
> > ================
> > Is this a bug or am I missing the correct usage of storing a 'bool'?
> >
> > Happy coding
> > Christian Waldmann
> >