Easy example of how to connect a local database running on something like UniServer to a Windows application using ODBC drivers in either VB.NET or C# (Example written in VB because this was part of an example project originally which needed to be in VB). All interaction with the Database is done using BackgroundWorkers to take the load off the UI thread.
Local SQL Database used : SqlYog
Allows for the interaction and execution of SQL commands using System.Data.Odbc
's namespace, database, table, field names are of course dependent on your database, so make sure to change them before attempting to use it.
UI is made in WPF using MahApps and Material Design in XAML