> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Simon Slavin
>
> Which does /not/ describe it as "The official SQLite database engine", which
> is the point I was making.
I used NuGet.
http://www.nuget.org/packages/System.Data.SQLite.Core/
"The off
> On 15 Jul 2014, at 8:05pm, Drago, William @ MWG - NARDAEAST
> wrote:
>
>> On 15 Jul 2014, at 6:42pm, Edward Ned Harvey (sqlite)
>> wrote:
>>
>>> In C#, using the System.Data.Sqlite.Core package, which is described
>>> as "The official SQLite database engine" and published by "SQLite
>>> Dev
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Simon Slavin
> Sent: Tuesday, July 15, 2014 2:35 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Preferred cast in C#
>
>
>
On 15 Jul 2014, at 6:42pm, Edward Ned Harvey (sqlite)
wrote:
> In C#, using the System.Data.Sqlite.Core package, which is described as "The
> official SQLite database engine" and published by "SQLite Development Team"
That's Joe's code. You probably got that off of git or nuget.org. The
de
On 2014/07/15 19:42, Edward Ned Harvey (sqlite) wrote:
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of RSmith
System.DBNull is not a native SQLite construct, it is probably one of the third
party connectors.
In C#, using the System.Data.Sqlite.Core
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of RSmith
>
>
> System.DBNull is not a native SQLite construct, it is probably one of the
> third
> party connectors.
In C#, using the System.Data.Sqlite.Core package, which is described as "The
offi
On 2014/07/15 13:48, Edward Ned Harvey (sqlite) wrote:
I would really love to have an easy way of putting a long? into the database,
and then getting a long? back out. Maybe it exists and I'm just doing it the
hard way right now...
I guess what I'm really getting at is this: The 5 data types
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Edward Ned Harvey (sqlite)
>
> I would really love to have an easy way of putting a long? into the database,
> and then getting a long? back out. Maybe it exists and I'm just doing it the
> hard way r
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Hick Gunter
>
> Why is the column nullable if you require a default value to be returned?
The default value for long? or string or byte[] is null. Which makes perfect
sense.
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Random Coder
>
> Could you not do something like this to handle the nullable types?
>
> T GetValue(string field)
> {
> object obj = reader[field];
>
> if (obj is System.DBNull
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Joseph L. Casale
>
> > I would really love to have an easy way of putting a long? into the
> > database,
> and then getting a long? back out.
>
> What do you want to happen when the column is null as
Why is the column nullable if you require a default value to be returned?
-Ursprüngliche Nachricht-
Von: Random Coder [mailto:random.co...@gmail.com]
Gesendet: Dienstag, 15. Juli 2014 03:50
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] Preferred cast in C#
Could you not
Could you not do something like this to handle the nullable types?
T GetValue(string field)
{
object obj = reader[field];
if (obj is System.DBNull)
return default(T);
else
return (T)obj;
}
Assuming the type is nullable, it should do the
> I would really love to have an easy way of putting a long? into the database,
> and then getting a long? back out.
What do you want to happen when the column is null as in your string example?
jlc
___
sqlite-users mailing list
sqlite-users@sqlite.or
I understand there are only 5 data types in Sqlite, and that the column type
isn't necessarily the type of object returned in a query. Is there a more
seamless way to cast responses than this?
I would really love to have an easy way of putting a long? into the database,
and then getting a long
15 matches
Mail list logo