How to create a Birthday Reminders application using Blazor Server, C# and SQLite.
The complete re-development of a Blazor Server application from Microsoft SQL Server to SQLite. The final application will send email reminders automatically, warning for forthcoming birthdays (or other important dates). This video shows how to handle date functions in SQLite, in particular how to calculate someone's age and their next birthday.
00:00 - Introduction
03:07 - Demonstration of Birthday Reminders
04:50 - List of programming tasks
05:42 - Create project in Visual Studio 2022
11:04 - Adding NuGet packages (SQLite, Dapper, Syncfusion, Hangfire)
12:23 - Database introduction
13:11 - DB Browser for SQLite
13:37 - Adding SQLite database
15:00 - Adding SQLite table
19:25 - SQLite connection string
20:15 - Syncfusion controls setup and licensing
22:45 - Person class, service and interface
24:53 - Simple list of people
26:36 - Conversion of SQL Server list of people to SQLite
29:55 - Adding a person
33:55 - Prevent duplicates when adding records
37:47 - Updating a person, including duplicate check
42:47 - Delete a person
46:32 - Restrict person list by logged-in user
49:05 - Next birthday and age next birthday introduction
49:43 - Dealing with dates in SQLite
54:51 - SQLite date function examples in DB Browser for SQLite
1:04:11 - Modify person list to show next birthday and age next birthday
1:06:00 - Calculate number of days to next birthday
1:12:10 - Email reminders (manually)
1:14:48 - Hangfire setup and configuration
1:16:23 - Reminder service to send emails automatically
1:19:08 - Housekeeping
1:20:19 - Running the app to create the Hangfire.db file
1:21:48 - Set Hangfire.db properties
1:22:48 - Deploy to Microsoft Azure
References
Blazorcode.uk: https://blazorcode.uk/birthdayssqlite/
Blazorcode.uk full code: https://blazorcode.uk/birthdayssqlite...
SQLite: https://blazorcode.uk/birthdayssqlite...
DB Browser for SQLite: https://sqlitebrowser.org/
SQLite Date & Time functions: https://www.sqlite.org/lang_datefunc....
SQLite Tutorial: https://www.sqlitetutorial.net/
SQLite julianday function: https://www.techonthenet.com/sqlite/f...