Browse by Tags

Code First - Create Delete Database

SQLite seems to gain popularity with "Entity Framework Code First" because is the easiest ans fastest way to unit test a DbContext. But the problem is that the "Database.Delete" is not supported and the "Database.Create" does not create table. In the near futur will the...

Posted to Entity Framework (Forum) by Jimmy on 01-10-2011
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
Could someone clarify what to do to deploy an application using SQLite provider?

I try to deploy an application that uses the SQLite provider. I already know that I have to configure the provider in the config file (http://sqlite.phxsoftware.com/forums/t/1713.aspx). But I have several issues (using the Entity Framework) : If I compile the application using AnyCPU (on a 64 bit machine...

Posted to Entity Framework (Forum) by jb42 on 04-23-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
How to map entities associations without foreign keys?

As far as I know, SQLite doesnt allow foreing keys. But I need them to map associations between entities. Is there a way to do it somehow anyway?

Posted to Entity Framework (Forum) by ValTrof on 10-26-2009
Re: Getting error message "Failed to find or load the registered .Net Framework Data Provider."

I met same problem and spend several hours to try. Here I just downgrade the version from 1.0.65.0 back to 1.0.64.0 and the problem disappeares. Maybe someone can let me know if it is a bug or I lost something in my system. Thanks a lot!!

Posted to Entity Framework (Forum) by jones on 09-17-2009
[Solved] Importing Views problem

Hi everyone! I'm getting some trouble importing views into my entity model with EF : There are 8 views I want to import but only two are successfully added to my model. When I update model from database, all my views are marked for import but I only have two successfully added to my model. The 6...

Posted to Entity Framework (Forum) by bechmoul on 08-26-2009

Page 1 of 1 (8 items)