in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Browse by Tags

  • about "Can't find PInvoke DLL 'SQLite.Interop.066.DLL'" issue on MIPS device

    I am trying to use SQLite.NET dowloaded from http://sourceforge.net/projects/sqlite-dotnet2/files/SQLite%20for%20ADO.NET%202.0/1.0.66.0/SQLite-1.0.66.0-binaries.zip/download?use_mirror=nchc in an application running on MIPS device , and sure have made all files correctly deployed, but always getting...
    Posted to General (Forum) by hobbybobo on 08-24-2010
  • SourceColumnNullMapping property don't works: total mess!

    Hello, before bug submit my congratulation for doing a work in a difficult territory like that! That said I had a problem in Compact Framework of 1.0.66 with VS2008 (not tested in desktop framework yet) with autogenerated parameters of update and delete commands. For being precise the problem is in evaluating...
    Posted to Bugs (Forum) by Henrik Sozzi on 07-12-2010
  • Is CF2.0+ SQLite a viable future solution?

    My question is how to use it, but is this solution going to be available in the future? I'm in the process of upgrading a Physical Inventory system that uses Motorola/Symbol WinCE scanners. The older version utilized AccessCE. It is not a viable candidate anymore. I do not want the same state in...
    Posted to General (Forum) by mhoop81 on 06-14-2010
  • Re: Version 1.0.66.0 - bad build for Compact Framework ?

    I've since downloaded the source code, and did a Release build using the Compact Framework configuration. It seems to work with no issue on my device, including the 'testce' unit tests. So in the downloadable binaries release, I'm convinced the binaries that are in Compact Framework folder...
    Posted to Bugs (Forum) by jpears on 05-03-2010
  • Is there any working version?

    Hello! I've downloaded 1.0.66.0 version, added reference to the System.Data.SQLite in my CF3.5 application and when i try to run this: var connection = new System.Data.SQLite.SQLiteConnection("Data Source=db.db3;Version=3;"); connection.Open(); i get error " Can't find PInvoke...
    Posted to General (Forum) by nZeus on 04-27-2010
  • Re: Can't find PInvoke DLL 'SQLite.Interop.059.DLL'.

    I'm using SQLite 065 and I had the same problem. Deploying BOTH SQLite.Interop.065.DLL and SQLite.Interop.065.lib along with the main sqlite dll solved the problem and it's working like a charm. One more thing to mention is: SQLite is waaaaaaaaaaaaay much faster than SqlCe and I'm gonna fall...
    Posted to General (Forum) by mmsaffari on 01-27-2010
  • fastest way to insert 100.000 records from one database to another

    Hello, I have a mobile application. My client has a large data set ~100.000 records. It's updated frequently. When we sync we need to copy from one database to another. I have attached the second database to the main, and run a insert into table select * from sync.table This is extremely slow, it...
    Posted to General (Forum) by pentium10 on 01-23-2010
  • Re: Newbie question for CF: "Can't find PInvoke DLL 'SQLite.Interop.060.DLL"

    After being close to going crazy with the same issue, I finally found the solution. I posted here to spare others the trouble: In VS use the function 'Add existing item' on project level to include the two DLLs ( System.Data.SQLite.dll and SQLite.Interop.060.DLL ). For each of them set the property...
    Posted to General (Forum) by zuppi on 11-23-2009
  • Database file isn't copying over?

    I'm playing around a bit with trying to get a sqlite database to open and display in a mobile application, and I'm having some trouble getting it going. From what I can tell, the file isn't being copied like it's supposed to. When I go into file explorer on the simulator, there is a file...
    Posted to General (Forum) by andyd273 on 09-14-2009
  • SQLite an PocketPc Application: SQLiteError no such table

    Hi all! I'm writing pocket pc application with vs2008, started two days ago and still sqlite doesn't work. I went through all that stuff described in forum: 1. I created sqlite database with designer, and when i deployed to windows emulator got Interop.dll error, so i add dll to my project as...
    Posted to How To (Forum) by Adrian Serafin on 08-07-2009
Page 1 of 2 (18 items) 1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems