Re: [sqlite] To import csv file in C#

2013-02-10 Thread Brad Hards
On 09/02/13 13:49, mukesh kumar mehta wrote: Is there any option to import csv file into sqlite database with the help of System.Data.Sqlite.dll. As like shell command .import file_name table_name. SpatiaLite can do this (either as a virtual table, or an import). There are probably other

Re: [sqlite] Trigger blocks a single transaction?

2012-12-23 Thread Brad Hards
On Monday 24 December 2012 11:04:29 Alem Biscan wrote: Hi, No, i do not execute begin/commit. It is VIEW'S INSTEAD OF UPDATE TRIGGER. I am doing a regular update to the view from C#. Another thing is that view doesn't return any row affected value. Well it makes sense somehow.. It cannot

Re: [sqlite] Database sharing across processes

2012-07-07 Thread Brad Hards
On Saturday 07 July 2012 01:00:01 Jonathan Haws wrote: For example, let's say I have two processes that connect to the same database file. One process wants to read from the database, but the other process is in the middle of a write. Does the first process pend on the read or not? If it

[sqlite] System.Data.Sqlite extension function - performing INSERT

2012-06-29 Thread Brad Hards
Hi, I'm trying to provide a not-really-spatialite toolset for C# users (since they often seem to have trouble with spatialite / extension loading). No problem with SELECT from an existing database / table. However I'd like to provide the capability to perform an INSERT of a newly created