Reply to post: Re: SQL's JOIN syntax is no harder to learn and more precise to use

Plans for Entity Framework Core 6.0 revealed as Microsoft admits it is unlikely to match Dapper for performance

itguy

Re: SQL's JOIN syntax is no harder to learn and more precise to use

Not always possible to have all the logic in the code. Sometimes a good SP can handle the complex joins needed in a complicated query way better than any coder can do at the code level.

We have some very complex queries that could be done in the client but the performance compared to an optimized SP just plain sucked.

One place where SP's suck in their own right is versioning, or a lack thereof. Would be a nice feature to have.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon