New DotNet Core MVC project using a very old and established datastore. 160 tables modelled with EF, no problem with DB First approach. However, all the expected complex functionality was derived from about 330 SPs. I'm having trouble getting my head around running these. Some docs say you have to recreate them in EF and some say you can execute them. Then there's the huge issue of some other docs saying you can't run SP's that have JOINs in them in EF Core. I'm looking for general advice, if anyone's come accross this sort of issue before. No doubt I'll need a steer on specific code as well at some point. Any advice would be appreciated. Thanks

I've used this nuget package a few years ago for a non-umbraco asp.net core application that had lots of stored procedures. I haven't used it recently and I cant say wether it will work for you or not. Just a thought you may want to investigate. https://www.nuget.org/packages/Snickler.EFCore/

Thanks for the suggestion. It looks interesting but this ship has sailed. It's a long time (15 yrs) since I've done a ton of ADO stuff and it hasn't got a lot better since VB days. It's working though 😉