O'Reilly logo

Windows Application Development Cookbook by Marcin Jamro

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Selecting data from a SQLite database

As in the case of inserting data into a database, it is quite difficult to imagine any application that uses a database but does not select any data from it. Thus, in this recipe, you will learn how to select data from particular tables in a database using Language Integrated Query (LINQ). What is interesting is that you do not need to write raw SQL queries on your own, thus it may be a really convenient and simple solution.

As an example, you will modify the project from the previous recipe to load data of all categories and entries after initializing the database. The list of categories will be shown in a drop-down list, while the list of entries in a dedicated place on the left-hand side.

Getting ready

To ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required