[sqlite] Json1 Extension Question

[Jarred Ford]

I'm on that version, but I get the error that the function json does not exist. 
 Example code I'm using is below:

SQLiteCommand tableCreate = new SQLiteCommand();
            tableCreate = new SQLiteCommand("create table user(name,phone);", 
sqliteConnection);
            tableCreate.ExecuteNonQuery();

            SQLiteDataReader dataReader;
            using (SQLiteCommand command = new SQLiteCommand("insert into 
user(name, phone) values(\"oz\", json('{\"cell\":\"+491765\", 
\"home\":\"+498973\"}'));", sqliteConnection))
            {
                dataReader = command.ExecuteReader();
            }

________________________________________
From: sqlite-users-bounces at mailinglists.sqlite.org <sqlite-users-bounces at 
mailinglists.sqlite.org> on behalf of Joe Mistachkin <sql...@mistachkin.com>
Sent: Tuesday, March 1, 2016 12:24 PM
To: 'SQLite mailing list'
Subject: Re: [sqlite] Json1 Extension Question

Jarred Ford wrote:
>
> Is the json1 extension to sqlite available to use somehow in .net?
>

Yes.  It is compiled into the System.Data.SQLite (version 1.0.99.0 and
higher) interop assembly (SQLite.Interop.dll).

>
> I haven't been able to find any documentation on this and would like
> to be able to leverage the json functions within c# code.
>

You should be able to use it as described here:

        https://www.sqlite.org/json1.html

All the queries described in the above referenced documentation should
work fine with the SQLiteCommand / SQLiteDataReader classes.

--
Joe Mistachkin

_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users