Query with Where Filter to Class Field (SQLite Visual Studio C#) (20/23)

In this video we will cover how to query sqlite data, and return the count of rows from a filtered where result.

Basic Steps:
Discuss high level program flow from model to service to repository.
Create general base class method for all derived classes.
Examine table structure and identify logic that will pull desired data
Build a query that will pull desired data from your database.
Write the mock and SQLite repository classes to test and collect our desired results.

C# .NET
Windows Form Application
Visual Studio
Interface
field
Interface
Polymorphism
class objects
SQL
SELECT
FROM
COUNT
WHERE