How do I setup Entity Framework Core 2.1 with Sqlite? - Connecting Database to My Solution

c# cross-platform entity-framework-core sqlite xamarin.forms

Question

I am not an expert on this technology yet, so I guess for most this is a very basic question... But I don't really know how to use DBContext and how can I really connect my database, to the cross-platform solution file... and which nuget packages should I use?... where do I reference it?... what classes should I make and what codes do I put in it?... These questions, that I don't even know how to apply on my solution, I hope it doesn't bother you guys...

My goal is to make a datagrid using xaml grid, binded with sqlite database using entity framework core 2.1...

If you can answer my question in a step-by-step guide that would be really helpful for me...

*How can I setup the Entity Framework Core 2.1 using the database that I created from sqlite?

    * My Database Location & Name: C:\sqlite\demo.db
    * My Target Framework: .Net Standard 2.0
    * My Visual Studio Version: 15.7.2
    * For Android, IOS, & UWP
1
0
6/11/2018 5:18:07 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You can use the dotnet command line tool:

dotnet ef dbcontext scaffold "Data Source=demo.db;" Microsoft.EntityFrameworkCore.Sqlite -OutputDir DataFolder -c "context name"

https://docs.microsoft.com/en-us/ef/core/get-started/aspnetcore/existing-db

1
8/11/2018 9:51:59 PM

Related Questions

Is it possible to automatically map a DB view on Entity Framework Core version 2.1?

I found ...this interesting question on stackoverflow... about mapping a view and working with it in EF Core. ... According to ...its answer..., with previous EF Core versions wasn't possible to automatically map views....But what now? According to the ...Entity Framework 2.1 Roadmap...,...An EF Core model can now include query types. Unlike entity...
asp.net-core asp.net-core-2.1 c# entity-framework-core
asked by Deadpool

UseSqlite with Entity Framework Core in ASP.NET Core 2.1 not working

It’s seems that you have not installed ...Microsoft.EntityFrameworkCore.Sqlite... to the project.
asp.net-core-2.1 entity-framework-core sqlite
asked by vivek nuna

Entity Framework Core 2.1 failling to update entities with relations

You are enumerating over existing steps here, and search for existing step in existing steps collection which does not make sense.... foreach(var step in existingDeploymentScenario.InstallSteps) var existingStep = existingDeploymentScenario.InstallSteps .FirstOrDefault(s => s.ID == step.ID); ...while it should probably be:...foreach(v...
asp.net-core-webapi c# entity-framework-core
asked by Alex Buyny

Using Fluent Api to set foreign key constraint in Entity Framework Core 2.1

We're moving an existing application to .net core 2.1. We currently have a table called ApplicationUser which is referenced by most of the tables in our application because of the audit columns in the tables. ...Given the following tables...ApplicationUser Id Int Identity(1,1) UserName varchar(100), ... ProductOrders OrderId Identity...
.net-standard-2.0 ef-fluent-api entity-framework-core
asked by Felix Cen

.NET Core 2.1 and EF Framework 2.1

I'm trying to replace a web service that provides information to a mobile app via ODATA 4. The current application is using EF6 and works without error....I have subsequently built a NEW .NET Core 2.1.1, using EF 2.1 and Core Odata 7.0.1. Everything seems to be functioning property when run on IISExpress through the Visual Studio 2017 interface. ..
.net-core c# entity-framework entity-framework-core odata
asked by Stewart Basterash

.Net Core 2.1 EF Core Null Reference Exception when searching database with Where linq query

I have a pretty simple query here:...public async Task<IActionResult> Index(string sortOrder) { ApplicationUser user = await _userManager.GetUserAsync(User); var context = _context.Engine .Include(e => e.EngineType) .Where(e => e.Company == user.Company); return View(await context.ToListAsync());...
.net-core entity-framework-core
asked by Ian Gleeson

Entity Framework Core 2.1 IdentityUser IdentityDbContext<> Getting IdentityUserLogin requires primary key to be defined

I am using Entity Framework Core 2.1 and I have a class,...public class MyDbContext : IdentityDbContext<User> ...The User table is part of the 1 and same database. In the Entity User class, it is defined as ...public class User : IdentityUser ...When I run and call ...userManager.FindByNameAsync(model.Username)...,I get following error:...IdentityU...
asp.net-core-identity entity-framework-core
asked by user1250264

ASP.NET Core 2.1 Entity Framework Core Related Data Duplication

I'm trying to build an ASP.NET Core API which returns an object containing some of related, joined, data....But when I call an Article model using Include(), it's mapped automatically by EF Core. Which is intended, but.. unexpected mapping is occurring....EF Core produce fully mapped object for all objects so that too much data is generated....For ...
asp.net-core-2.0 asp.net-core-2.1 asp.net-core-webapi entity-framework-core
asked by Jason Kim

Entity Framework core 2.1 Using AsNoTracking with multiple Async gives InvalidOperationException: The connection was not closed

I have run two Async methods using Entity Framework 2.1 - one for selecting the total count and another for retrieving page data - and I marked my entity AsNoTracking as following:...var dbContext = new SamuraiAppDataCoreContext(); var query = dbContext.Samurais.AsNoTracking(); var pageQuery = query.Skip(0).Take(10); var totalCountTask = query.Co...
async-await asynchronous c# entity-framework-core
asked by Mina Matta

Connect multiple Databases to .NET core project via Entity Framework Core

Create base context and including all settings into this, DBSET:...public abstract class BaseContext : DbContext { public BaseContext(DbContext options) : base(options) { } public DbSet<object> FirstDbSet { get; set; } ... } ...inherit from BaseContext for both DBs(Databases):...public class NavaContext : BaseContext { publi...
.net-core asp.net-core c# entity-framework-core
asked by Mojtaba Nava

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