How to use SQLite with Entity Framework 6 on UWP?

Problems using Entity Framework 6 and SQLite

Just thought I'd share another way to configure EF6 with SQLite without using ...app.config... / ...web.config.... EF6 now supports code based configurations as outlined here ...on msdn.... I used the following code (updated to remove reflection thanks to Sly):...public class SQLiteConfiguration : DbConfiguration { public SQLiteConfiguration()...

Where to put SQLite database in UWP app

Current ...Entity Framework Core Documentation... gives an example for using SQLite in a Windows 10 / UWP app. The example given declares the db location with ...optionsBuilder.UseSqlite("Filename=Blogging.db");... The path is equivalent to ...Windows.Storage.ApplicationData.Current.LocalFolder.Path... This puts the SQLite database in ...<packagef...

List of foreign keys in Entity Framework Core using SQLite

I want to implement Related Pages structure that one page have a list of other pages related to it. But I could't figure out if it is possible. Now I have the structure like this: ...public class Page { public int ID { get; set; } public string UrlName { get; set; } public List<RelatedPages> RelPages1 { get; set; } } public class Relate...

ASP.Net Core - Using SQLite - Data showing, but not saving with Entity Framework

I am trying to use ...SQLite... in ...ASP.Net Core... with ...EntityFramework Core.......When I am in debug mode (With Visual Studio), everything is working fine....When I publish it, and I am trying to receive data, it is working....Data read controller is like this-...[HttpGet] public async Task<IActionResult> Get(int start=0,int end=0) { var...

Protect an SQLite database in an UWP app

See my ...Encryption in Microsoft.Data.Sqlite... post for tips on using SQLCipher and friends with Microsoft.Data.Sqlite....The easiest way to use it with EF Core is probably to use an open connection with your ...DbContext.......class MyContext : DbContext { SqliteConnection _connection; protected override void OnConfiguring(DbContextOpti...

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

Do not use both ...EnsureCreated... and ...Migrate..., Only ...Migrate... enough to create and migrate the DB...using (var db = new DBContext()) { //db.Database.EnsureCreated(); Don't use db.Database.Migrate(); }

Including SQLite DB file with data in the UWP application

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:...What is the correct way to bundle this file with the application....How do I compose the file pat...

Using Data Annotations for SQLite in Entity Framework Core

I am using the Entity Framework Core to interface my SQLite database. I want to set a minimum and maximum range for the field ...ExitSide... in my model ...Station...:...using System.ComponentModel.DataAnnotations; ... class Station { public int StationId { get; set; } [Range(0,2)] public int ExitSide { get; set; } } ...But somehow it s...

Error using Entity Framework Core with SQL Server on UWP app

Enabling and starting the SQL Browser service fixed the problem for me. That avoids messing around with IP addresses and TCP ports. ...Integrated security would not work, however, I had to revert to SQL User ID and password.

Is it possible to use MVVM Light with Entity Framework Core in a UWP project?

I'm trying to use Entity Framework Core with UWP. I found this ...sample... from Microsoft and got it to work. In this sample, the object models are in a .Net Standard class library. However, for the project I'm working on, I need to be able to use MVVM Light's RaisePropertyChanged method in the setters of my object models. The issue I'm running in...