zzz projects Entity Framework 6 EF 6
Home EF Core Articles Knowledge Base Online Examples
  • Home
  • EF Core
  • Articles
  • Knowledge Base
  • Online Examples

Entity Framework 6 - Knowledge Base (KB)

13 results in tag: system.data.sqlite

SQLite + Entity Framework deployment

I have a ASP.NET MVC app that is using SQLite database through Entity Framework. Everything works on VS 2008's local development webserver....However, deploying the web app to my service provider causes this error:...[ArgumentException: Unable to find the...
asp.net-mvc entity-framework sqlite system.data.sqlite
asked by Pompair

Entity Framework and SQLite

I'm having a problem with primary keys in Entity Framework when using SQLite. SQLite wants an explicit NULL in the VALUES list on an autoincrementing primary key column. I haven't actually looked at the generated SQL in the EF Context, but I believe it'...
entity-framework system.data.sqlite
asked by Dave Swersky

SQLite with EntityFramework with Code-First

I am trying to create an embedded SQLite database on the fly with the EF however, I can't get it to work, the database file is never getting created. ...I have EF 4.2 and latest version SQLite...Here is what I have...app.config...<?xml version="1.0"?> <co...
c# ef-code-first entity-framework sqlite system.data.sqlite
asked by Pierluc SS

In entity framework, find an object for a given primary key.

I have a table "Customer" and it's corresponding ORMapping Entity Customer in entity framework and I want to find an object corresponding to a given primary key. Something like ...customerobject.getbjectByID()... instead of lambda expression or query.
.net c# entity-framework system.data.sqlite
asked by saurabh

Entity Framework 6 with SQLite 3 Code First - Won't create tables

Using latest versions of EF6 and SQLite from NuGet. I finally got the app.config file to work after some useful posts on Stackoverflow. Now the problem is that the tables are not being created although the database is....My app.config:...<?xml version="1....
.net ef-code-first entity-framework-6 sqlite system.data.sqlite
asked by user1192887

Work with SQLITE database using visual studio 2013

I'm Trying to work with SQLITE database using visual studio 2013. I have installed ...System.Data.SQLite (x86/x64) 1.0.92... to visual studio. And installed the Setups for 64-bit Windows (.NET Framework 4.5) as well....Problems...It gives me and exception...
c# entity-framework-6 sqlite system.data.sqlite visual-studio-2013
asked by Chamika Sandamal

Manually opening an EntityConnection to SQLite database causes ProviderIncompatibleException

For integration testing purposes I'd like to manually create and open an EntityConnection in the test fixture set up. This fails with the following exception when calling the Open() method:...System.Data.ProviderIncompatibleException : A null was returned...
c# entity-framework entity-framework-6 sqlite system.data.sqlite
asked by Harry13

How does the SQLite Entity Framework 6 provider handle Guids?

I am porting our product's database to SQLite from another product that supported Guids. As we know, SQLite does not support Guids. I've got created an entity framework 6 model from my database (database first) and I need to build a query from C# that c...
c# entity-framework entity-framework-6 sqlite system.data.sqlite
asked by Tony Vitabile

How to pass DbContext (EntityFramework SqlConnection) to another Method?

Issue in passing DbContext to another method i.e. for e.g: ...public bool MarkCustomerForDelete(Customer customerObj) { using(var dbContext = new MyContext()) { using(var dbTransaction = dbContext.Database.BeginTransaction()) ...
c# entity-framework entity-framework-6 sqlite system.data.sqlite
asked by bhuvin

The entity set is not defined in the entity container

Cross posted on MSDN...We use manual code first Entity Framework for System.Data.Sqlite...So when creating a new entity, we manually create the table, the c# object, and add the DbSet to our context....I have a very simple object created and I am getting ...
c# entity-framework-6 system.data.sqlite
asked by wesmantooth

Updating to EF 6.2.0 from EF 6.1.3 causes cannot access a disposed object error

I'm working with SQLite. I am able to use entity framework 6.1.3 in my WPF application without problems, but when I update it to 6.2.0 I get the following error:...Test method DataAccessLayerTests.GenericDataRepositoryTests.CRUD_On_Pipe threw exception: ...
c# entity-framework-6 system.data.sqlite
asked by ferit

Its 2017: How do you create tables with System.Data.SQLITE.EF6

I've ready a number of old posts mentioning that System.Data.Sqlite allows you to talk to Entity Framework but not actually create the database tables. It is 2017 now and I'm wondering if SQLite for Entity Framework 6 still lacks the ability to create a ...
ef-code-first entity-framework-6 sqlite system.data.sqlite
asked by Tony Valenti

SQLite.CodeFirst "The provider did not return a ProviderManifest instance."

I am trying to make work the simplest project using ...SQLite.CodeFirst... (1.5.1.25, installed from NuGet package) along with the ...System.Data.SQLite... (1.0.108, also NuGet). ... However, adding a person will result in ...The provider did not return a...
c# ef-code-first entity-framework-6 sqlite system.data.sqlite
asked by wondra

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

EF Extensions
Try for free now
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!