title: How to store data from MsSQL in my application (easy to use)
body: <p>I'm currently writing my first WPF application. It provides a GUI for viewing, editing and creating data from my mssql-server. In my database I have one main table and a couple of sub-tables (foreign keys in main table).In my view, I have a Datagrid to Display all the data. I have several other views, that can add, edit and delete rows in my main table and in some sub-tables.</p>
  
  <p>In a first version of my Programm, I had a public static class which contains several <code>public static ObservableDictionarie</code>s (from <a href="http://drwpf.com/blog/2007/09/16/can-i-bind-my-itemscontrol-to-a-dictionary/" rel="nofollow">Dr. WPF</a>), with the ID-Columns of my Database as key and a custom type as value. These dictionaries had the same structure as my database. With the start of my program I filled all of this static dictionaries and then I can access them at any time from anywhere in my code. The controls in my views I bound with <code>x:static</code>. </p>
  
  <p>The problem I have now, is that I can't use INPC with this static class, so my GUI doesn't update when I e.g. delete rows of my dictionary. When I change the data inside a row the GUI updates, because I implemented INPC in my custom type.</p>
  
  <p>So how can I store the data in my application in an easy way? This is only a small application with only one programmer, so I think that patterns like MVVM is a bit too much for this (and I used this never before). For example I use the events of controls in code-behind. But I want to use the comfort of binding my DataGrid to a dictionary and the INPC to update my GUI.</p>
  
  <p>Sorry for my bad english, but my native language is german.</p>