Browse by Tags

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
Re: Error 2019 : Real mapping to double impossible

Hello, I'm sorry, but I don't find any solution. I ask on a Microsoft Forum, the Microsoft man answerd me somthing very strange.. They dont'tanswer on the question ho wto change default EF mapping ? So I continue to use only Single real. For my application It was not a problem, I was using...

Posted to Entity Framework (Forum) by ServAnges on 03-14-2011
How to make Entity Framework CTP5 work with SQLite?

I am having a very hard time in using the SQLite db with EF CTP5. I was just trying to execute this MSDN example with SQLite. But at the line var food = db.Categories.Find("FOOD"); I am getting a runtime exception - System.Data.SQLite.SQLiteException (0x80004005): SQLite errorno such table...

Posted to Entity Framework (Forum) by anidotnet on 02-04-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
NotSupportedException at converting SQLite types (Int64, String) with Entity Framework 4

Hi All, I'm trying to use System.Data.SQLite with Entity Framework 4 and SQLite3 in a POCO scenario. The EDMX model was successfully created from the SQLite database with the wizard. Then I used the MS POCO Entity Generator. At query execution I get the following NotSupportedException while casting...

Posted to Entity Framework (Forum) by Olivier on 07-16-2010
ProviderIncompatibleException

When I found out that there was an EF provider for SQLite, I was really excited because one of the major barriers to using EF is its utter lack of testability without building a framework around it (this, to me defeats the point of using EF to begin with). Unfortunately, there are two extremely important...

Posted to Entity Framework (Forum) by Maximus014 on 06-06-2010
Entity Framework generate model from DB doesn't import cascade settings

I have the following table structure: CREATE TABLE [ SomeTable ] ( [ SomeTableID ] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT , [ PersonID ] INTEGER NOT NULL REFERENCES [ Person ]( PersonID ) ON DELETE CASCADE ) CREATE TABLE [ Person ] ( [ PersonID ] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT ) When...

Posted to Bugs (Forum) by jamone on 03-19-2010
EF doesn't dispose SQLiteCommands correctly

I noticed this while using SQLite with System.Data.SQLite while writing an application that queried the database very often. The working memory set for the application kept growing, so i started .NET Memory Profiler and checked. I noticed that literally ten-thousands of SQLiteCommand objects are noted...

Posted to Entity Framework (Forum) by Schuck on 02-24-2010
TransactionScope does cause database locked exception when invoking SaveChanges more than once

I use a TransactionScope to ensure a transaction. If I invoke ObjectContext.SaveChanges more than once within the transaction, I get an exception that reports that the database file is locked. Here is a sample: using (AdventureWorksLTEntities objectContext = new AdventureWorksLTEntities(connectionString...

Posted to Entity Framework (Forum) by jb42 on 02-04-2010

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