> -----Ursprüngliche Nachricht----- > Von: Tim Cross <theophilusx@xxxxxxxxx> > Gesendet: Sonntag, 19. August 2018 04:57 > > > > We're using object mapping / entity frameworks (e.g. XPO, Entity > Framework Core). These frameworks support regular queries out-of-the > box; a CTEs require additional effort and are more difficult to maintain. > > > > Ah, another reason to avoid object mapping/entity frameworks! I guess > really the same reason - loss of flexibility and expressive power. While I agree that you loose control over certain details, we are overall quite happy using the frameworks. The frameworks nowadays provide the ability to call procedures if required - but using the objects directly is more convenient for the developers. SQL procedures add (just like a CTE) an additional layer to the application design which needs maintenance. That's fine if it really helps overall but we try to avoid it if it isn't needed. Regards Klaus
