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

Entity Framework Core - Knowledge Base (KB)

144 results in tag: sqlite

Entity Framework 6 + SQLite

I'm trying to use EF6 alpha and SQLite 1.0.66.0...My .config file:...<connectionStrings> <add connectionString="data source=:memory:;" name="TestDbContext" providerName="System.Data.SQLite" /> </connectionStrings> <entityFramework> <providers> ...
ado.net entity-framework entity-framework-6 sqlite
asked by nmulyukin

Does System.Data.Sqlite support Entity Framework 6?

I looked around, and it was not clear if you could use it in EF6. I've found a compatible version on a blog (...here...) but I'd rather use the official one if possible. Is it compatible or not? ...Thanks!
c# entity-framework entity-framework-6 sql sqlite
asked by It'sNotALie.

Problems using Entity Framework 6 and SQLite

I'm trying to use Entity Framework with SQLite. I had issues integrating it into my main application, so I started a little test from scratch, exactly following the directions on ...http://brice-lambson.blogspot.com/2012/10/entity-framework-on-sqlite.html...
.net c# entity-framework entity-framework-6 sqlite
asked by Xcelled

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

Two tables referencing each other in Entity Framework 6 Code First

I have the entities ...Project... and ...Sprint... where a Sprint belongs to a Project. A Project also contains a ...Backlog... which is a reference to a single Sprint it will add items to by default....public class Project { public long ID { get; set...
c# entity-framework entity-framework-6 sqlite
asked by Jay Wick

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

ASP.NET 5 vNext EF7 SQLite TypeLoadException on CreateParameter

I get the following error when I attempt to load my website, or attempt to apply my migrations via ...k ef migration apply...An unhandled exception occurred while processing the request. TypeLoadException: Could not load type 'Microsoft.Data.SQLite.SQLit...
asp.net-core c# entity-framework-core sqlite
asked by socketman

Forcing an Entity Framework 6 query to use the correct index

I have a C# application that uses SQLite as the database and the SQLite Entity Framework 6 provider to generate queries based on user input....The database contains the following tables and indexes:...CREATE TABLE Lists ( ListRowId INTEGER NOT NULL PR...
c# entity-framework entity-framework-6 sqlite
asked by Tony Vitabile

'No Entity Framework provider found' for EF 6 and SQLite 1.0.96.0

I realize there are already several similar questions on this topic, but many of them are from older version of SQLite which did not fully support EF 6 as far as I am aware. I have tried countless suggestions from these threads and am either doing somethi...
c# entity-framework entity-framework-6 sqlite
asked by Simon

Using .Net Entity Data Model with SQLite

I'm attempting to convert a c# application currently running on SQL Server 2014 LocalDB over to SQLite, which appears to do the same job but is much lighter. I spent the whole day reading about it and installing various components....The problem is that I...
.net c# entity-framework entity-framework-6 sqlite
asked by Etienne Charland

Getting sqlite to work in ASP.NET 5 (vnext)

I'm trying to get "EntityFramework....SQLite...": "7.0.0-beta1" to work within ASP.NET 5....I've created my project using Yeoman and installed EF sqlite from the package manager....The project builds fine but when running I get:...Could not load file or a...
.net-core asp.net asp.net-core-mvc entity-framework-core sqlite
asked by ryan g

Unable to determine the provider name for provider factory of type "System.Data.Sqlite.SqliteFactory"

I want to use sqlite entity framework in my web api project, but it always can't work well, ...here is my development enviroment....1.Visual studio 2013, .net framework 4.5...sqlite package version is 1.0.97, I installed below packages...system.data.sqli...
c# entity-framework entity-framework-6 sqlite visual-studio-2013
asked by zhnglicho

EntityFramework 7 - CodeFirst - SQLite - Manage DB using ApplyMigrations at runtime

I am well on my way to utilizing EF7 CodeFirst with SQLite...but really want to employ DB Migrations at runtime. This is a desktop application (Click-once deployment) meant to sync with a main database when connection is available, and provide offline dat...
entity-framework-core sqlite
asked by faldeland

Add-Migration command not working in EF 7 for UWP app

I'm following ...getting started with EF 7 for UWP apps... official tutorial....When I'm at Add-Migration MyFirstMigration, it throws following error:...PM> Add-Migration MyFirstMigration Add-Migration : Exception calling "CreateInstanceAndUnwrap" with "...
entity-framework-core sqlite uwp
asked by Anil

How to use SQLite with Entity Framework 6 on UWP?

I am now developing model classes for Universal Windows Application. Is there any possibility to use EF6 and SQLite together in this project or should I use pre-release of EF7 only?
c# entity-framework entity-framework-6 sqlite uwp
asked by Andrew Sklyar

ASP.NET 5, EF 7 and SQLite - SQLite Error 1: 'no such table: Blog'

I followed the ...Getting Started on ASP.NET 5... guide about Entity Framework 7 and I replaced MicrosoftSqlServer with Sqlite, the only difference in the code is in Startup.cs:...services.AddEntityFramework() .AddSqlite() .AddDbContext<BloggingCo...
asp.net asp.net-core entity-framework entity-framework-core sqlite
asked by Arthur Rump

Entity Framework 7 and SQLite Tables not creating

I've been trying for awhile to figure out how to use a single DBContext to create multiple tables in a Code First fashion without any luck. I'm sure it's just my unfamiliarity with the framework but I'm not sure what I'm missing. Here's a simple example w...
c# entity-framework-core sqlite
asked by CGideon

EF7 (Code First) + SQLite doesn't create a database and the tables for the models

Im currently trying to recreate the example, done in the documentation ...http://ef.readthedocs.org/en/latest/getting-started/uwp.html... , using EF7 and SQLite to create a Universal Windows Platform app....I've installed the required EF7 and EF7 Commands...
entity-framework-core sqlite win-universal-app
asked by fhin

Protect SQLite database used by EntityFramework Core Application

I'm trying to use EntityFramework Core 1.0 (new name for EntityFramework 7) to manage an SQLite database in a C# Desktop application....I read official documentation and my test-application works....My question is: is it possibile to password-protect the ...
c# entity-framework-core sqlite
asked by Enrico Brugnatelli

Entity Framework ChangeTracker not updated, returns "deleted" entities

I'm successfully deleting entity from SQLite database by datagrid delete row event. This can be confirmed by SQLite Manager. However after running this delete event and ...SaveChanges()... command I still get the deleted entities after using ...GetLocal()...
c# change-tracking entity-framework-core sqlite
asked by ajr

Page 1 of 8
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • ยป

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
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!