Community.Data.SQlite?

[Teravus Ovares]

Hey there,

I did the original conversion of the Mono.Data.SqliteClient to
Community.Data.SqliteClient. I looked a few weeks ago and noted
that there still wasn't a Community.Data.SQLite. Is this something
that you think would benefit the C#Sqlite community? I have a
version based on Mono.Data.SQLite (the newer version) that I'm
currently testing that supports both DB and IDB and a .NET 3.5
framework target. I'd be willing to contribute that back to the
community also if you think it would be useful.

Let me know and it'll be a weekend project for me.

Thanks

Teravus

On Tue, Jul 27, 2010 at 8:03 PM, lucwuyts <luc....@a-d-e.net> wrote:
> in System.Data.SQLite i have used decimal parameters
>
> This is not supported in c#_sqlite
>
> So i tried adding this to the sqliteCommand class
>
>                else if (ptype.Equals(typeof(Decimal)))
>                {
>                    string val = param.Value.ToString();
>                    err =
> (SqliteError)Sqlite3.sqlite3_bind_text(pStmt, i, val , val.Length ,
> null );
>                }
>
> but the values are zero when i look in the database.
> I thought the internal representation of all fields was always text ?
>
> Any idea?
>

[Noah Hart]

I'm a little confused. I put the original into
Community.CsharpSqlite.SQLiteClient

Are you saying you want it under the Community.Data.SqliteClient namespace?

See the discussion thread "Suggestions wanted for better organization of
the project"

here

http://groups.google.com/group/csharp-sqlite/browse_thread/thread/1b6d0a5d851ae67a/44ca8176371ffbf3?lnk=gst&q=Community+Data#44ca8176371ffbf3

[Noah Hart]

Got it. I don't use the SQLiteClient at all, and so I don't have a
problem changing it :)

Anyone else care if we make this change?

Noah

On 7/28/2010 8:53 AM, Teravus Ovares wrote:
> No, I'm just saying that I'm working on a version based on
> Mono.Data.Sqlite. The original was based off of
> Mono.Data.SQLiteClient and when it went in there was some frustration
> noted from the mono community about it being based off of
> Mono.Data.SQLiteClient.
>
> Community.CsharpSqlite.SQLiteClient and Community.CSharpSqlite.Sqlite
> works for me if that's your preferred namespace. The letter was not
> in regards to the namespace.
>
> The second paragraph of http://www.mono-project.com/SQLite explains
> the difference in more detail.
>
> Regards
>
> Teravus

[Noah]

Can you comment on this ... http://code.google.com/p/csharp-sqlite/issues/detail?id=76

[Diego Torres]

If I understood correctly your question, you said that no crypto
routines are used? To use them and after opening the database file,
you should issue a PRAGMA hexkey with the passphrase in hexa. hexkey
is expecting a key like this as a parameter
"0x0102030405060708090a0b0c0d0e0f10".

If the database file is empty, the new database will be encrypted. If
the database file exists, it will be decoded with the key supplied. If
key is incorrect, sqlite will fail to find the needed structures in
the decoded pages.

However, if you are expecting to encrypt connections to the ado
provider, this is not the purpose of the crypto routines. This
routines only encrypt the resulting file/memory pages.

--
-- Use of a keyboard or mouse may be linked to serious injuries or disorders.
diego dot torres at gmail dot com - Madrid / Spain