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