We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >
LINQ and Recursive CTE and Windows Functions[Answered]
1 reply
Last post Jul 24, 2018 07:31 PM by Mikesdotnetting
Last post Jul 24, 2018 07:31 PM by Mikesdotnetting
Member
282 Points
298 Posts
LINQ and Recursive CTE and Windows Functions
Jul 24, 2018 06:15 PM|rkrex|LINK
Hi Friends,
I was wondering can I write a recursive CTE or a Windows function using LINQ. Also can I write T SQL in .Net Core 2.1? Thanks !!!
All-Star
194851 Points
28099 Posts
Moderator
Re: LINQ and Recursive CTE and Windows Functions
Jul 24, 2018 07:31 PM|Mikesdotnetting|LINK
For complex queries, you should fall back to plain SQL and then use the context's Database property to execute it: https://www.learnentityframeworkcore.com/raw-sql