The book mainly deals with database programming, and how you from C# can write programs that uses a database. The book assumes that the reader has a basic knowledge of databases, but has an appendix which provides a brief introduction to SQL. The book also deals with WPF and data binding related to the design pattern Model-View-ViewModel.Click here to download the source files from this book.
Description
Contenu
- Foreword
- Introduction
- Contacts
- Books
- ADO
- Database programs
- Exercise 1: Find books
- Exercise 2: Find persons
- Open databases
- The basic SQL statements
- Parametrized SQL commands
- SQL INSERT
- SQL UPDATE
- SQL DELETE
- Exercise 3: Zipcodes
- Provider independence
- WPF and databases
- Data binding
- Binding two WPF controls
- Exercise 4: Bind the background
- Binding to an object
- A little more about conversion
- Exercise 5: Calculate a price
- Exercise 6: Calculate a price again
- Exercise 7: Bind colors
- Binding to a collection
- Binding a collection to a single property
- Data templates
- DataGrid
- Exercise 8: The zip codes again
- Filtering a DataGrid
- Editing a DataGrid
- Problem 1: Denmark
- MVVM
- History people
- Problem 2: The world
- Disconnected ADO
- A SQL SELECT
- The adapter
- The Entity Framework
- Using EF for zip codes
- The books database
- Maintaining contacts a last time
- Final example: Books
- The task-formulation
- The Database
- A prototype
- The entity data model
- The ViewModel layer
- The MainWindow
- Publishers, Categories and Authors
- Maintenance of books
- The search function
- The last things
- Appendix A: SQL
- The book database
- SQL data types
- SQL commands
- DML commands
- The SELECT command
- SQL functions
- View’s
- Inner SELECT statements
- Stored procedures