On 24 Jan 2014, at 6:24am, Frantisek Cerven <[email protected]> wrote:

> I want to ask you if is any way to call sqlite special commands
> programatically from c#.

These 'special commands' are not in SQLite at all.  They are features of the 
command-line shell application.  SQLite does not understand any command 
starting with a dot.

> E.g. I need something like this in code not in command line:
> 
> sqlite> .mode csv
> sqlite> .output test.csv
> sqlite> select * from tbl1;
> sqlite> .output stdout
> 
> If not, what is the quicker way to export table programatically? Now I`m
> doing it with DbDataReader, but it is slow.

I'm afraid that the way to do that quickly is to write some C# code which does 
it.  A slower way to do it would be to have C# issue an operating system 
command that makes the shell tool do it.

> Ps: There is not any support user forum??

This is it !

Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to