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> ...
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!
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 "...
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?
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...
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...
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...
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 ...
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()...
asked by ajr