EFcore3.1 get values from sys.master_files and SERVERPROPERTY

I need my (console) app to get some general SQLserver DB info. In SQLserver management studio I run this query on the master system database: SELECT @@VERSION, name, physical_name, size, SERVERPROPERTY(‘Edition’), SERVERPROPERTY(‘ProductVersion’), SERVERPROPERTY(‘MachineName’) FROM sys.master_files WHERE name = ‘mydb’ I get back a table with a single row and the values I need in 7…

Details