I have the working by converting a datatable into a list of getter/setter models because I don't like EF.   However all the Microsoft new stuff is using EF that is slower than ADO.NET.