Coding

Scheduled MySQL databases backups on Windows really simply…

Scheduled MySQL databases backups on Windows really simply…

A simple, scheduled MySQL database backup method with zipped files, archive pruning and FTP/offsite upload After a fruitless search for free MySQL backup tools, the solution turned out to be surprising – using good old-fashioned batch scripting to surprising affect! This leverages the MySQLDump tool which produces .sql files as backups. This simple script will backup selected databases and d... »

Automatically encrypt database connection strings in Visual Studio

Automatically encrypt database connection strings in Visual Studio

This article shows you how to automatically preserve your database connection string in app.config whilst also deploying an encrypted version in your production app…. In my example, I am connecting to a remote MySQL database from a winforms app. Add your data source via the usual means, choosing to save your password and store in app.config: The open ProjectSettings > Compile > BuildEv... »

SQLite and Entity Framework 6.0 Setup in Visual Studio 2017

SQLite and Entity Framework 6.0 Setup in Visual Studio 2017

A guide to getting SQLite and Entity Framework 6 working together through Visual Studio 2017 SQLite is an embedded, single file database which is ideal for desktop applications and projects that require a single client/user side database to feed applications data. It prevents the need for clients to have any server/client database frameworks running such as SQL etc. Entity Framework 6 simplifies w... »

SharpDX + vb.net – Displaying bitmaps and bitmap brushes

SharpDX + vb.net – Displaying bitmaps and bitmap brushes

The adventures into SharpDX continue… this instalment: bitmaps and burshes Thanks to this wonderful article¬†[here], I did some code monkery and converted it to vb.net. The original was designed for wpf and used device context, but I changed it to work with the RenderTarget covered in the last article. I also improved on the RenderTarget text – the window resizing was in the wrong place... »

Setting up SMFL.net in Visual Studio

Setting up SMFL.net in Visual Studio

“SFML provides a simple interface to the various components of your PC, to ease the development of games and multimedia applications. It is composed of five modules: system, window, graphics, audio and network.” Download Don’t download through NuGet. Rather, visit page and download from here: https://www.sfml-dev.org/download/sfml.net/ Add the following as references in your proj... »