05 database structure for which we are creating sample application - chempkovsky/CS2WPF-and-CS2XAMARIN GitHub Wiki

Typical Wpf App

  • Now it's time to get acquainted with a typical Wpf application created using CS2WPF.
  • An overview of the main aspects of such an application will help illuminate the class of tasks whose solution CS2WPF automates.
  • In other words, the goal is to show what you can get at the end of the development process

We start from DataBase structure

DB structure

  • Country is a master for
    • Dialect, Publisher, Author
  • Language is a master for
    • Dialect
  • Genre, Author, Dialect are masters for
    • Manuscript
  • Manuscript, Publisher, Edition are masters for
    • Book

Creating such a strange database, we sought to achieve two goals:

  • have a master-detail chain longer than two:
    • Country > Author > Manuscript > Book
    • Country > Dialect > Manuscript > Book
  • have a node that has more than one master:
    • Dialect, Genre, Author are masters for Manuscript