Dotnet Core Test

Postgres access with Entity Framework and ADO.Net

Following lab setup, in this post, I will show how to use dotnet core to access Postgres db. Summary Create a dotnet core console project use Entity Framework to generate Entity Framework context and entity code write code to run a query using Entity Framework write code to run a query using ADO.Net/Npgsql run a speed test Create a dotnet project and add Postgres packages dotnet new console -n CmdlineApp cd CmdlineApp dotnet add package Npgsql --version 4. [Read More]

Lab Setup for a Test Drive

A Postgres server and developer computer setup

Source code: My Test-Drive github repo Summary build a Postgres Docker image start a new container get data from College Scorecard web site perform an ETL to get a subset of the data install PostgresSql client on Windows load data to server Build a custom Docker image based on Postgres 11 Dockerfile and create user/db script FROMpostgres:11.2COPY ./create-bruno-db.sh /docker-entrypoint-initdb.d/create-bruno-db.sh create-bruno-db.sh This file must be executable If you edit it on Windows, make sure you convert Windows CR LF to Linux new line charater LF [Read More]