PYRK Masternode Monitoring Service - Discontinued

In recent PYRK news (week of 7/19/2021) the team is planning on performing a swap in the next couple of months to a new chain. The team announced that they will turn off masternode rewards. Moving to a new chain is great news for the project as there were issues with the existing chain that is too costly to correct.

Considering this news we have taken down our PYRK Masternode Monitoring service.  

Thank you for using our PYRK Masternode Monitoring service. We hope to bring the service back-online with the new chain if masternodes are supported. 

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