How To Create Editor For Database View (with Joins) In Windows Forms/wpf?

What would be the simplest way to create a quick editor for some data in the database in WPF/WinForms, where the data is represented by a View in the SQL Server database? Say I hav

Solution 1:

You are describing what is known as scaffolding in web development. Scaffolding is a way to automatically generate UIs for each table in the database. Scaffolding lets you create a functional UI for viewing and editing data based on the schema of the data. Here are a couple of resources for WPF scaffolding.

1. There is a WPF scaffolding article on the Code Project website: WPF CRUD Generator (Scaffolding)
2. There is also a Codeplex project that could be helpful: WPF Scaffolder

Enjoy!

Solution 2:

ASP .NET Dynamic Data uses templates to auto-generate a UI for you that will represent the database tables/views you choose, including the auto-generated CRUD capabilities you want.

It even gets the lookup tables right and renders dropdowns automatically.

http://msdn.microsoft.com/en-us/library/ee845452(v=vs.100).aspx