Including SQLite DB file with data in the UWP application

entity-framework-core sqlite uwp windows-10

Question

I'm trying to include a SQLite file with the UWP application. SQLite file has a number of tables in it populated with data.

The database (for now, at least) is read-only and I'm planning to use EF Core to access the data.

So i have two questions:

  1. What is the correct way to bundle this file with the application.
  2. How do I compose the file path to access that file from UWP applciation?

Setting .sqlite file's "Copy to output directory" setting to "Copy always" seems to copy the file to bin folder but I can't seem to figure out the path to access it. When setting the SQLite conenction string to "Filename=databasename.sqlite" - it seems to create a blank DB file elsewhere, as tryign to access any of the tables throws a table not found exception.

Thanks in advance!

1
1
7/27/2017 2:41:37 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

My recommendation is ...

  1. Include the .db file to your AppX package. To include it, add the .db file to Assets folder in your project.
  2. Then, at the first time launch of your app, you should copy the .db file from Assets to your app's local folder. Because, SQLite itself can't access to the Assets folder. It can only access to the your app's local or temporary folder.

I've answered for the similar question on MSDN forum. Please refer it too.

[UWP] SQLite.net Path question?

4
7/27/2017 5:59:54 AM

Related Questions

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

Today you can invoke the extension method ...Migrate... on the ...DatabaseFacade.... ...This method is only available when the ...using Microsoft.Data.Entity... statement is present. It comes from the ...RelationalDatabaseFacadeExtensions... class that is part of the ...EntityFramework.Relational... package....Still have to find out how to migrate ...
entity-framework-core sqlite
asked by riezebosch

How to use SQLite with Entity Framework 6 on UWP?

Sure, you can now use ...Microsoft.EntityFrameworkCore.Sqlite..., but with a little workaround needed. ...Useful documentation...A useful walkthrough...Workarounds:...adding an app.config to application layer UWP## Heading ##...Add Ms.EfCore.Tools to app layer (natemcmaster commented on 3 May) ...Hope this helps
c# entity-framework entity-framework-6 sqlite uwp
asked by Ian

Where to put SQLite database in UWP app

Documentation is right. The path for the database (Windows.Storage.ApplicationData.Current.LocalFolder.Path) is correct. Your data will exist as long as the app is installed on the device....Please see below MSDN article and what is the most important from it:..."local data, which exists as long as the app that created it remains installed"...And o...
entity-framework entity-framework-core sqlite uwp
asked by Daniel Krzyczkowski

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

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
entity-framework-core uwp windows-10 windows-10-mobile windows-10-universal
asked by Ben

Protect an SQLite database in an UWP app

It is an ...UWP...application using a ...SQLite... database. Below, the dependencies for this application:...{ "dependencies": { "Microsoft.EntityFrameworkCore.Sqlite": "1.0.1", "Microsoft.EntityFrameworkCore.Tools": "1.0.0-preview2-final", "Microsoft.NETCore.UniversalWindowsPlatform": "5.2.2", "Microsoft.Xaml.Behaviors.Uwp.Mana...
.net-4.6 c# entity-framework-core uwp
asked by JiBéDoublevé

table already exists exception when migrate DB using Entity Framework Core and SQLite

I'm using EF Core and SQLite in UWP. I tried to migrate by calling DbContext.Database.Migrate() but I always get ...Microsoft.Data.Sqlite.SqliteException: 'SQLite Error 1: 'table "Tags" already exists'.'.... ...I'm sure that the table doesn't exist because I checked on bin/debug folder, there is no database file. Even I check in wrong folder, t...
entity-framework-core sqlite uwp
asked by witoong623

Entity Framework Core with SQLite: ASP.NET application holding onto database in memory

"How can I have the Web project use the db in the Data.EF project?"...Possibly ...optionsBuilder.UseSqlite("Data Source=\Data.EF\sqlite.db");
asp.net-core c# entity-framework-core sqlite
asked by Tubs

Why can't I use file extensions in Entity Framework Core Sqlite files?

The issue results from the previous connection still having access to the file....As mentioned in the thread below Sqlite's C# implementation has a quirk where after a .Close() the connection is not truly cleaned up until a garbage collect runs...System.Data.SQLite Close() not releasing database file...To fix it you could add IDisposable to your IA...
.net-core c# entity-framework entity-framework-core sqlite
asked by IainM1985

Updating entity in EF Core application with SQLite gives DbUpdateConcurrencyException

I try to use optimistic concurrency check in EF Core with SQLite. The simplest positive scenario (even without concurrency itself) gives me ...Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException: 'Database operation expected to affect 1 row(s) but actually affected 0 row(s). Data may have been modified or deleted since entities were loaded....
c# entity-framework-core sqlite
asked by flam3

Xamarin Forms +Entity Framework Core + SQLite - Calling migration on production breaks application

Do you have linking enabled in your release build configuration? According to this ...https://github.com/aspnet/EntityFrameworkCore/issues/10963... the compiler requires hints to not link assemblies accessed through reflection internally in EF Core. You can try switching to "Link sdk assemblies only" to see if that fixes the issue. If it does then ...
c# entity-framework-core production-environment sqlite xamarin.forms
asked by FullStackOverflowDev

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