Entity Framework Core - Knowledge Base (KB)

EF in WinForms: how to filter data in BindingSource/DGW (.Local.ToBindingList())

I generated an EF model (Database first) and DataSource following this tutorial ...http://msdn.microsoft.com/en-us/data/jj682076.aspx...On my form I created BindingSource (bsUsers) and bound DataGridView to it. ...Here is how I load data on form startup:....

binding winforms to database by entity framework 6

The scenario is simple:...I have EF6 DbContext MyDbContext...I have Form with ListBox...The code to bind data from DB to listbox is as follows:...dbContext = new MyDBContext(); listBox1.DataSource = dbContext.Experiments.Select(a => a.Name + "," + a.Modif...

C# Linq efficient way to count items on a List on the fly

I am using Linq to Entities with EF and want an efficient way to do this. I what am doing is going through a list, counting distinct items in the list, appending the count on one element and return one string using String.Join. What I want (and I achieve)...

Notifications for tracked changes in EntityFrameworks DbContext

I am building a Data Entry app using Entity Framework where a user can fill out forms and then Save or Cancel. However I want the Save Button only to be enabled when there is actual data that can be saved to the database....I know about DbContext.ChangeTr...

C# Entity Framework Property is (Sometimes) Null

So I am having a very weird issue when using EF where sometimes property of a class is null and sometimes it is not. In this case ...ParentType... is often null, when it should have a value...With the following code is DOES have a value:... using (...

Dispose Entity DbContext in WinForms

In Windows Forms application, when form starts, it loads data from database. It first goes to Persistence Data layer and creates new DBContext....public DataEntities DBContext = new DataEntities();...After this it loads data. ...I dispose DBContext on for...

Entity Framework Core, discard and update a datagridview

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 diff...

Getting all dates between two dates using datepickers and Entity Framework 6

I have two datetime pickers on my form. I want a function that will return all datetimes from a specific table (which are values of a specific column) between those two dates. ...My method looks like this:...public DateTime[] GetAllArchiveDates(string use...

Is it possible to use Entity Framework Core in a Win Forms Application? / References Not Found Warnings

I am attempting to use Entity Framework Core in a Windows Forms application. No other code has been written, this is all just initial project setup....I am receiving the following warnings after setting up a windows forms application in .net framework 4.6...

How to handle "No connection string named 'RestaurentEntities' could be found in the application config file" in WinForms

I hope you all will be fine. ...I am trying a project on WinForms. I made a Form name ...Dashboard... and User Control name ...DashboardScreen.... ...Dashboard... basically will have many User Controls on it like ...DashboardScreen..., ...InventoryScreen...