Last post Jul 24, 2018 07:31 PM by Mikesdotnetting
Member
216 Points
235 Posts
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
189145 Points
27426 Posts
Moderator
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
Member
216 Points
235 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
189145 Points
27426 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