Browse by Tags

Rebuild assemblies with a different name and SQLITE_DLL for side by side x86/x64 ?

Hello, I am trying to use SQLite.NET in both 32 AND 64 bits environments, in a scenario where I cannot force my process in 32 bit (must run in 64 bit native), and where the deployment is xcopy-based (same files, no way to choose during install time between the two versions, and no way of knowing before...

Posted to General (Forum) by Krzys on 11-04-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
LINQ generating inappropriate SQL???

I am trying to use LINQ with System.Data.SQLite (version 1.0.64.0) in VS2008 (no SP), and am unable to insert a row into a table. The code below generates the error I am seeing. Besides the two columns that appear in the code and log, there is one more named CustomerKey which is the integer primary key...

Posted to General (Forum) by Steve Reynolds on 07-23-2009
SQLite Exception "Unable to open the database file"

Dear all, As first really thanks for all the helps you are providing. If possible I have a little question, but please, consider me an absolute beginner. I'm tryng to develop a little test application for smart device using C# and SQLite. After the creation of the DB and the related schema, if I...

Posted to General (Forum) by Giovanni on 07-01-2009
Re: Readin Blob data in C#

But consider this line: long len = rdr.GetBytes(1, 0, null, 0, 0); it throws a Cast Exception, Check: http://sqlite.phxsoftware.com/forums/t/1781.aspx Any suggestion there?

Posted to General (Forum) by afshin on 06-19-2009
Re: Readin Blob data in C#

Thanks to Joel Lucsy It has been fixed. Here is his code: public T GetValue<T>( String query ) { using (IDbCommand cmd = connection.CreateCommand()) { cmd.CommandText = query; return (T)cmd.ExecuteScalar(); } } public void foo() { byte[ img = GetValue<byte[>( "select imageblob from imagetable"...

Posted to General (Forum) by afshin on 06-18-2009
Readin Blob data in C#

Hi, I'm using the latest Wrapper, Installed about a week ago. I try to use SQLiteDataReader to read a file from the database and write it to a file, but the problem is I can't read it, I either get Cast Exception or No Current Row. For No Current row, if i use reader.Read(); Then I get CAST Exception...

Posted to General (Forum) by afshin on 06-17-2009
sqlite Exception System.InvalidCastException: Specified cast is not valid.

This is the Code in C#: SQLiteDataReader rdr; SQLiteCommand contentCommand; String cmd = String.Format("SELECT filename,content,filesize FROM documents WHERE did={0}",120); contentCommand = sqlconn.CreateCommand(); contentCommand.CommandText = cmd; rdr = contentCommand.ExecuteReader(); rdr...

Posted to General (Forum) by afshin on 06-17-2009
SQLite error: no such table: tblLogin

Dear all, I am coding the SMS Management Application for my Pocket PC Windows Mobile 6.1 and use SQLite. I created db3 file and tables by Visual Studio 2008. I drap and drop tables from Server Explorer to Dataset Designer. I also edited connection string in dataset source code and copy SQLite.Interop...

Posted to General (Forum) by tavu on 02-11-2009
test.exe.config?

I've downloaded and built SQLite-1.0.60.0 from the source code and I try to run the test.exe application with the following error. Ln 38 of TestCaseDialog.cs DbProviderFactory factory = DbProviderFactories.GetFactory(_provider.SelectedItem.ToString()); Throws ConfigurationErrorsException "Failed...

Posted to General (Forum) by EdoTokugawa on 01-25-2009

Page 1 of 2 (13 items) 1 2 Next >