Database Application for Windows

Products and their categories in the AdventureWorksLT database

• 
  Use the AdventureWorksLT database in any of the following formats:
  • Microsoft Access file (.mdb file)
  • Microsoft SQL Server 2005 or 2008 database which can be attached (.mdf and .ldf files)
• (The AdventureWorksLT database is one of many versions of the sample database used in many presentations. More information can be found at http://msftdbprodsamples.codeplex.com/)
• Required functionality:
  • viewing the hierarchy of product categories (be sure to make the application to work correctly also in cases when the hierarchy tree's level is bigger than 2)
  • modifying names of a product categories
    • the application should load all the data and disconnect from the database; on the user's demand it should reconnect to the database and save changes done by the user
  • viewing all products from the selected category
    • show both the name and the thumbnail image
• Example of the user interface:
  
• Technical requirements:
  • the database structure cannot be modified
  • parameters of the connection to the database must be stored in the application's configuration file
  • the user interface can be created in Windows Forms or WPF
  • access to the database can be provided using ADO.NET, LINQ to SQL, Entity Framework or any other library

• Approximate points:
  • reading data from the database: 1,5
  • the hierarchy of product categories: 2,5
  • editing a name of the product category (including refreshing the hierarchy's view): 1,0
  • names of products from the selected category: 1,5
  • images of products from the selected category: 2,5
  • saving data to the database: 1,0

• Links for uploading:
  • solutions
  • corrections