Using DbContext to show data in wpf controls

Question

I don't know how to use DbContext to show data in a Wpf Data Control as the ListView, ListBox or DataGrid.

I'm using the Database first approach, with VS2012.

I have a Database with one table (the simplest case).

enter image description here

Then I added an ADO Net Entity Data Model, it added several classes to my project, among them is OneTableEntities : DbContext:

enter image description here

Now I have a ListBox in a Wpf Window, what do I bind the listbox.ItemsSource to? I tried "listBox.ItemsSource = context.MyTables;" but I get this error:

Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery) is not supported. Instead populate a DbSet with data, for example by calling Load on the DbSet, and then bind to local data. For WPF bind to DbSet.Local. For WinForms bind to DbSet.Local.ToBindingList().

Where is that Load operation?, How can I populate a local store?

Sergey Berezovskiy · Accepted Answer · 2014-01-01 20:05:55Z

3

As error message says, you cannot bind control to query. Use ToList() to execute database query and save results to in-memory collection. Then you will be able to bind this collection to listbox:

listBox.ItemsSource = context.MyTables.ToList();

Another option you can find directly in error message:

context.MyTables.Load(); 
listBox.ItemsSource = context.MyTables.Local;

edited Jan 1, 2014 at 20:05

answered Jan 1, 2014 at 20:00

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using DbContext to show data in wpf controls

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related