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:
![](../../../imagefab0.html?picture=/2021/ScreenShot.png)
The project takes the approach of a typical setup of Dependency Injection of the service classes required to load and query the data.
![](../../../imagef7a4.html?picture=/2021/CORE.png)
The GitHub project at this link has the steps on what is required to setup this code and run it.