Critical issue using EF Core on UWP (unable to open database file)

entity-framework-core uwp windows-10 windows-10-mobile windows-10-universal

Question

Steps to reproduce

Follow this simple tutorial.

The issue

Start the app either in Debug or Release.

An exception occurs with db.Database.Migrate();.

Exception thrown: 'Microsoft.Data.Sqlite.SqliteException' in Microsoft.Data.Sqlite.dll. Additional information: SQLite Error 14: 'unable to open database file'.

This is the very first step, Migrate() method should create the database if there is not any yet (it also fails with db.Database.EnsureCreated()).

Further technical details

EF Core Tools version: 1.0.0-preview2-final

EF Core Sqlite version: 1.0.0

UniversalWindowsPlatform version: 5.2.2

Visual Studio version: VS 2015 Update 3

Operating system: Windows 10 10586.494

1
0
7/21/2016 8:17:51 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

It appears that, although the first-chance exception is thrown, it doesn't actually represent a bug as EF Core handles this and continues execution normally. However, it leads to a misinterpretation (the database is created anyway).

More info

1
7/25/2016 8:30:24 AM

Related Questions

Cannot attach database file when using Entity Framework Core Migration commands

There may be a different *.mdf file already attached to a database named EfGetStarted2... Try dropping/detaching that database then try again....You might also be running into problems if the user LocalDB is running as doesn't have correct permissions to the path.
entity-framework-core
asked by bricelam

How to run a migration in UWP using ef core 1

I don't know how I have run the migration in EntityFramework.Core(v7.0.0-rc1-final) using EntityFramework.Commands(also v7.0.0-rc1-final). When I add the migration (Add-Migration) so migration creates. Then, when I enter the Update-Database, so the PM console returns:...Update-Database should not be used with Universal Windows apps. Instead, call ...
entity-framework-core win-universal-app
asked by Stefan Babos

SQLite Error 14: 'unable to open database file' with EF Core code first

I am getting an...SQLite Error 14: 'unable to open database file'...with EF Core code first, no idea why. I worked fine the first time, the database file got created in c:\users\username\AppData\Local\Packages\PackageId\LocalState....Then I deleted the database file and the code first migration and ModelSnapshot classes and created a new migration ...
ef-code-first entity-framework-core sqlite
asked by IngoB

Inserting into two tables using a view model in asp.net core/ issue with database connection

What is the best way to insert into two tables at once? I am having an issue with the connection string. Below are my data models as well as my view model. I am using the code first approach with asp.net core.... public ActionResult Create(BuildPackagingViewModel viewModel) { var build = new Build() { BuildStep ...
asp.net-core asp.net-mvc c# entity-framework-core
asked by Alex Zimmerman

Xamarin - Entity Framework - SqLite - GetItemsAsync : unable to open database file

According to get the..."Unable to open database file" ...error maybe you're pointing the code at a file that doesn't exist....A "Table not found" error means it found the database, but not the table you were looking for. On the other hand, "Unable to open database file" means that it couldn't even find the database, and didn't even bother looking f...
c# entity-framework-core sqlite xamarin xamarin.forms
asked by Junior Jiang - MSFT

.designer file of migration in EF core not being associated with .cs file in visual studio

I have created a .NET Core application. I am using Entity Framework Core with Code first approach and I am creating migrations....For some reason the ....designer.cs... file of the migration is not associated with the principal ....cs... file....I have seen this ...solution... but it seems is not correct for .net core application....Any help please...
.net-core ef-migrations entity-framework-core visual-studio-2017
asked by Ciccio

What is the difference between EF Core Database-First and EF Core Code-First approaches?

I was wondering... since there is no EDMX in EF Core, what is the difference between those 2? And if the major difference would be the possibility to change the database tables, why not use code first then use EF code-first migrations?
asp.net-core ef-code-first ef-database-first entity-framework-core
asked by shade1337

Unable to map List<> navigational properties using OData, EF Core and AutoMapper

I'm currently writing an ASP .NET Core API utilizing OData for querying, and Entity Framework to talk to the database....I want to separate the domain objects from the DTOs sent to the user, so have also started to use AutoMapper to translate entity framework query results to DTOs I have created....At this point (while I'm testing), my DTOs and dom...
asp.net-core automapper c# entity-framework-core odata
asked by Olorin

EF Core migration with SQLite database: unable to create object of type

I'm trying to make an initial migration of SQLite database with Entity Framework Core....My solution consists of two projects: Console Application and Class Library (that contains DbContext and all models)....DbContext looks like that:...public class SQLite_DbContext : DbContext { public DbSet<DeviceRepresentation> Devices { get; set; } pub...
c# entity-framework entity-framework-core
asked by Piotrek

I am unable to store data into database using Entity Framework Core and Ajax

I have a problem with my code. The problem is I am not getting post data by parameter using ajax....Can anyone fix this? The code is shown below....This is Javascript Ajax code where I am sending data by post method to the controller:...$('#pending').click(function () { SaveTestResult("/Reception/PatientTests/SavePendingTest"); }); function Sa...
asp.net asp.net-core asp.net-core-2.0 asp.net-core-mvc entity-framework-core
asked by SK jha

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow