Entity Framework Core, discard and update a datagridview

c# entity-framework-core winforms

Question

I have a Winforms test application that I'm using to try to learn about Entity Framework Core.

I have a datagridview bound to my table and I can edit fields and call context.SaveChanges() - works fine.

What if I have edited several cells on different rows, deleted and added a row, then changed my mind and I don't want to save? How can I discard the changes and refresh the datagridview with the original data?

I call EntityFrameworkQueryableExtensions.Load(context.entity) and then dataGridView1.Refresh() but my form remains unchanged with my changes.

dataGridView1.DataSource = context.enity.Local.ToBindingList();
1
0
10/10/2018 4:07:35 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

To load data from database you have to instantiate the Context again: 

context = new SampleDbContext(options);

then you can reload your grid any way that's possible. I think the easiest possible way is to assign it again:

dataGridView.DataSource = context.MyDbSet;

And one more thing (just in case you want to learn more); EF is not designed to be used with long lived contexts. The best way to use EF is to dispose the DbContext instance after you are done with it:

using(var ctx = new SampleDbContext()){
    instances = ctx.MyDbSet....
}
0
10/11/2018 7:58:10 PM

Related Questions

Entity Framework 6 Batch Updates and AuditLog using Entity Framework Extended

I am using Entity Framework 6 and I am using EntityFramework Extended to perform some batch updates and batch deletes. The batch updates and batch deletes work OK however I also need to know the entities that were updated / deleted (i.e. the current and previous values). I thought that using the AuditLogger provided by EntityFramework.Extended wo...
entity-framework entity-framework-5 entity-framework-6 entity-framework-extended
asked by quophyie

Updating records with Entity Framework Core 1.0 without needing to Update/UpdateRange

In Entity Framework Core 1.0 when I do something like:...var products = _context.Products.ToList(); foreach (var prod in products) { prod.Status = 1; } _context.SaveChanges(); ...I believe it will automatically update all products in the list to have a Status of 1....If this is the case what happened to AddRange, UpdateRange, Add, Update, Rem...
c# entity-framework entity-framework-core
asked by Blake Rivell

Update entity class in ASP.NET Core Entity Framework

One option is-...You can use ...Scaffold-DbContext... command with ...-force... flag. This way you can force scaffolding to overwrite existing model files....sample command - ...Scaffold-DbContext "<ConnectionString>" Microsoft.EntityFrameworkCore.SqlServer -t <tablename> -f ...Replace ConnectionString & TableName as per your requirements.
asp.net-core c# entity-framework-core
asked by Sanket

EF Core - adding/updating entity and adding/updating/removing child entities in one request

As usual, posting this question to StackOverflow helped me resolve the problem. The code originally didn't look like in the question above, but I was rather fixing the code while writing the question. ...Before writing the question, I spent almost a day trying to figure out what the problem was and so I tried different things, such as recreating en...
asp.net-core aspnetboilerplate c# entity-framework entity-framework-core
asked by Dejan Janjušević

Entity Framework Core: Fail to update Entity with nested value objects

According to ...this EF Core GitHub ticket... you have to update the child/nested/owned type properties directly for it to track properly. This was supposed to be fixed in EF 2.1 (currently only available as a release candidate) but may have not made the cut. In 2.0.3 they updated the verbiage of the exception to:...InvalidOperationException: The i...
c# entity-framework-core entity-framework-core-2.1 value-objects
asked by bman7716

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

Entity Framework Core Update child entities problem

In my ASP.NET Core 2.2. MVC project I have a master-detail form that I use for editing a PARENT table that also has a list of child entities (stored in CHILD table). ...When I save the modifications on the form I first save the changes to the parent entity and then run the following method to update the corresponding child entities:...private void ...
asp.net-core c# entity-framework-core
asked by TheMixy

Add or Update child entities when updating a parent entity in Entity Framework Core

In a new project we are using Entity Framework Core instead of EntityFramework 6.2.0. Works good but it causes a problem when updating a parents children while also inserting new children....Example:...Current model:...public class Profile { public Profile() { Interests = new List<Interest>(); } [Key] [DatabaseGenerate...
c# entity-framework entity-framework-core entity-framework-core-2.2 entity-framework-core-3.1
asked by Ogglas

Entity Framework Core: Update() method INSERTs instead of UPDATEs on dependent entity

It seems like EF Core is doing an INSERT instead of an UPDATE, and thus MySQL complains about a duplicate key. However, I am using the Update method on the DbSet and the entities do have primary keys set. This results in a DUPLICATE ENTRY error in MySql....Running VS 2019, EF Core 3.1.1 and ASP.NET Core 3.1...Model (I do not use Fluent config for r...
asp.net-core entity-framework-core mysql
asked by Ted

DateTime property causing new migration update even without any update on model in Entity Framework core

In entity framework, if I run the command "...add-migration <name>..." in package manager console, each and every time it creates migration with some update commands for the property datetime....Model:...public class TestDetailBase { public string TestTitle { get; set; } public int TotalTimeinMinutes { get; set; } public...
c# entity-framework entity-framework-core
asked by Bimal Das

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