Dotnet Core Test

dotnet new console -n CmdlineApp
cd CmdlineApp
dotnet add package Npgsql --version 4.0.5
dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 2.2.0

# set up connection string
$cnstr = "Host={0};Database={1};Username={2};Password={3}" -f $env:PGHOST,$env:PGDATABASE,$env:PGUSER,$env:PGPASSWORD
dotnet ef dbcontext scaffold $cnstr Npgsql.EntityFrameworkCore.PostgreSQL

# brunoContext.cs and College.cs generated

 int ret = 0;
brunoContext.ConnectionString = ConnectionString;
string sqltext = (!queryByName) ? "select * from yin.college where id = {0}"
    :"select * from yin.college where earnings is not null and name ~* {0} order by earnings desc limit 20";
using (var context = new brunoContext())
{
    Task<List<College>> task = context.College
        .FromSql(sqltext, val)
        .ToListAsync();
    Console.WriteLine("Waiting for query to finish ...");
    var college = await task;
    foreach(var item in college){
        Console.WriteLine(item.Info);
        Log.Information(item.Info);
    }
    ret = college.Count;
}
return ret;

decimal? ToDecimal(Object v){
    return (v is System.DBNull)? null: (decimal?)v;
}

using(var cn = new NpgsqlConnection(ConnectionString)){
string sqltext = (!queryByName) ? "select * from yin.college where id = @p1"
    :"select * from yin.college where earnings is not null and name ~* @p1 order by earnings desc limit 20";
await cn.OpenAsync();
var cmd = new NpgsqlCommand(sqltext, cn);
var p1 = cmd.Parameters.Add("p1", NpgsqlDbType.Varchar, 32);
p1.Value = val;
var r = await cmd.ExecuteReaderAsync();
int total = 0;
while(r.Read()){
    Object[] values = new Object[r.FieldCount];
    int fieldCount = r.GetValues(values);
    College item = new College{
        Id = (string)values[0], Name = (string)values[1],City = (string)values[2],State = (string)values[3],
        Zip = (string)values[4],Region = (int)values[5], 
        Latitude = ToDecimal(values[6]), Longitude = ToDecimal(values[7]),
        AdmRate = ToDecimal(values[8]), SatAvg = ToDecimal(values[9]), ActAvg=ToDecimal(values[10]),
        Earnings=ToDecimal(values[11]), Cost=ToDecimal(values[12]),Enrollments=ToDecimal(values[13])
    };
    Log.Information(item.Info);
    Console.WriteLine(item.Info);
    total ++;
}
ret = total;

$testEF = {    
    dotnet run -n cali -qt ef
}

$testSimple = {
    dotnet run -n cali
}

Function runTest{
    Param(
        [scriptblock]$Script
    )
    $w = New-Object System.Diagnostics.Stopwatch
    $w.Start()
    & $Script | Out-Null
    $w.Stop()
    # "`n{0:#,###.#0} milli seconds used`n" -f $w.Elapsed.TotalMilliseconds
    $w.Elapsed.TotalMilliseconds
}
 
$results = @()

1 .. 25 | % {
    $a = runTest -Script $testEF
    $b = runTest -Script $testSimple

    $results += New-Object -TypeName psobject -Property @{EF=$a; Simple=$b; Difference=$b-$a }
}

$results