Browse by Tags

Database locked error message

Hi I am writing a Compact Framework 3.5 application using version 1.0.66. I have one SQLite database with a few tables. i have a form which opens two other forms optionally and in each of those forms different data is written to the same table here is some sample code For Each dr As DataRow In m_qUI...

Posted to Bugs (Forum) by create_software on 01-04-2012
One to many relationship problem

I want to report a problem, which has already found a workaround, which was discussed at the page http://sqlite.phxsoftware.com/forums/t/1460.aspx As you can see from the last post in the forum above the bug is very annoying because it obliges us to make a ToList () the whole table if you want the sub...

Posted to Bugs (Forum) by abramo on 10-06-2011
Error creating entity model

When I try to add an entity model to my project, I can select the DB to connect to but then when VS tries to retrieve DB information (tables etc.) I get an error message: "no such functon: sortconcat". Any ideas?

Posted to Entity Framework (Forum) by mmedic on 03-01-2011
Running test.exe from version 1.0.66.0

I installed the ADO.NET 2.0 Provider for SQLite(1.0.66.0) on my development machine. Then copied all files under C:\Program Files (x86)\SQLite.NET\bin\ to a new fresh-installed windows XP machine which has .net framework 3.5 being installed. I cannot run the test.exe without any error message. What's...

Posted to General (Forum) by al2ping on 02-17-2011
error opening database with long connectionString containing multi-language characters

hi, I am using version 1.0.66 of the DLL and encountered an SQLiteException using the following connectionString. I've verified that previous version 1.0.44 has no problem with this. The super long multi-language connection string Data Source= C:\Documents and Settings\winusername\Desktop\projectfolder...

Posted to Bugs (Forum) by clarencec on 02-09-2011
Error 2019 : Real mapping to double impossible

Hello, I use Visual studio 2010 and I create a EDM from a database designed under Visual studio 2010. I use the Sqlite wrapper System.data.Sqlite to access to my database latest version 1.0.66. My model is directly a mapping of the SQLite table. I define many fields as real in SqLite (8bytes IEEE real...

Posted to Entity Framework (Forum) by ServAnges on 01-29-2011
Version 1.0.60.0 on Visual Studio 2010 + .net 4: SQLite v. 2.8.x

Hi everybody! Is there any chance to get the actual version working in combination with SQLite 2.8.x? I successfully set up VS 2010 and .net 4 with the actual System.Data.SQLite version 1.0.60.0, but I need to connect to DBs of the Version 3.8.1. Found this post: http://sqlite.phxsoftware.com/forums...

Posted to General (Forum) by cardox on 01-25-2011
DbType.String -> DbType.Int32

Hi, i just wrote a simple code: _cmdMandati = new SQLiteCommand(); _cmdMandati.CommandText = "insert into Import (" + "Tipo," + "File," + "Riga," + "Codice," + "Descrizione," + "MandatiImporto," + "MandatiQuantita" + "...

Posted to Bugs (Forum) by Lukino2000 on 01-05-2011
After DB FileCopy EF can't access DB

I've added backup functionality to a c# .Net 3.5 Sp1 Application. The db-file is copied to a location. With Restore, the db file is copied back to its original location. After the restore, I can access the DB with SqliteConnection. However, as soon as EF wants to access the DB, I get the error: EntityException...

Posted to Entity Framework (Forum) by GERT107 on 11-09-2010
Re: ProviderIncompatibleException

I discovered (to my dismay :() that System.Data.SQLite doesn't implement the CreateDatabase() method. The obvious workaround (of copying and renaming a created but empty SQLite fileto the path of the desired new database file) is not an acceptable solution for me: I used the Entity Framework to importan...

Posted to Entity Framework (Forum) by macaulay on 10-25-2010

Page 1 of 3 (24 items) 1 2 3 Next >