PC Awake - Prevent Windows 10 from Sleeping / Screen Locking

There are tools such Mouse Jigglers that will keep Windows 10 from locking or going to sleep.  The drawback of Mouse Jigglers for Windows 10 is that, well your mouse is moving. 

This freeware utility I created called "PC Awake" will keep your Windows PC from locking or going to sleep without moving the mouse.  The PC Awake App also has a feature to stop after a certain number of hours, or never. This is great if you want your PC to remain unlocked while you are home or working, but when you are done it will automatically stop and allow your PC to sleep or lock as normal. 

There are similar products out there (paid and free) my goal was to make something simple and useful.  With some locking features with security in mind so that your PC will lock as normal after a period of time you set. 

Features:

  • Prevent Windows from Sleeping or Locking the Screen (for an hour or more)
  • Does not move your mouse pointer
  • Minimize to the System Tray
  • Does not interrupt your normal PC activities
  • Stop the process on demand 
  • Freeware

Screen Shots: 

Default Screen

Set to run for 1 hour

1 hour run time is up! (in this case I clicked stop to capture the screen shot, ignore the end time)

Download Links:  Note: These links are not a full installer. If there are errors running the app you may need to download .NET 4.8 at this link.

 

PostgreSQL .NET Core Entity Framework Example

While working on planning for a new application I decided to look at PostgreSQL vs. SQL Server Express. What drove my decision is the limitations on database size for SQL Server Express. I wanted to stick with Entity Framework as well and decided to go with PostgreSQL after looking at alternatives. I was very impressed with all the features of PostgreSQL and that the PostgreSQL team has a .NET Core Entity Framework provider.

Typically I create a sample console app when working with technology I have not used before (in this case PostgreSQL) so that I have a working example I can refer too and share.  I posted a full working copy of this console app on my GitHub at this link

The sample project (using .NET Core Entity Framework) will truncate a table in PostgreSQL then load a set of Cryptocurrency symbols and query that data with LINQ. 

Sample Screen Shot:

The project takes the approach of a typical setup of Dependency Injection of the service classes required to load and query the data. 

The GitHub project at this link has the steps on what is required to setup this code and run it. 

.NET Core - Google Authentication and .NET Core Identity

This post is just a collection of a couple of links around using Google Authentication and .NET Core Identity. 

  • Free Code Camp: Step by Step adding Google Auth to .NET Core project.
    • By default the SQL Database to support this will be located on your C:\Users\[username] folder.  Change the connection string in appsettings.json to create the database in SQL Server.
  • Microsoft Documentation: Good overview / walk through about using Google Auth but not enough to get the site to work (need the link above).
  • Google Developer Console: This where you need to get your Auth Key.

I have used the Data Repo pattern in .NET Core but wanted to generate the models similar to .NET. 

  • This stackover flow post is a good reference. 
  • How to scaffold models
  • Scaffold-DbContext "Server=yourserver;Database=yourdatabase;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models
  • With table params 
  • Scaffold-DbContext "Server=(localdb)\mssqllocaldb;Database=DatabaseName;Trusted_Connection=True;"
    -Provider Microsoft.EntityFrameworkCore.SqlServer
    -OutputDir Models -Context NorthwndContext
    -Tables Products,Categories,Suppliers -Force