.NET Core: Introduction To Microsoft.Data.Sqlite

[Costas]

// Reused and Modified Code - https://github.com/aspnet/Microsoft.Data.Sqlite/blob/dev/src/Microsoft.Data.Sqlite/Utilities/DbConnectionExtensions.cs  
public static class DbConnectionExtensions  
{  
    public static int ExecuteNonQuery(thisDbConnection connection,  
        string commandText, int timeout = 30)   
    {  
        var command = connection.CreateCommand();  
        command.CommandTimeout = timeout;  
        command.CommandText = commandText;  
        return command.ExecuteNonQuery();  
    }  
  
    public static TExecuteScalar < T > (thisDbConnection connection,  
            stringcommandText, int timeout = 30) =>  
        (T) connection.ExecuteScalar(commandText, timeout);  
  
    private static objectExecuteScalar(thisDbConnection connection,  
        string commandText, int timeout)  
    {  
        var command = connection.CreateCommand();  
        command.CommandTimeout = timeout;  
        command.CommandText = commandText;  
        returncommand.ExecuteScalar();  
    }  
  
    public static DbDataReader ExecuteReader(thisDbConnection connection,  
        string commandText)  
    {  
        var command = connection.CreateCommand();  
        command.CommandText = commandText;  
        return command.ExecuteReader();  
    }  
}