sql maintaince hell?
-
How is having sql queries in code and stored procedures on the server make for good maintenance? Now you have two places to look for things to go wrong. :wtf:
-
Because they used to have some in the asp.net markup, now there's only 2 places to look rather than three. I say this from experience.
Only this is for asp.net applications built from scratch. I'm thinking future maintenance. You're explanation offers at least a little bit of incite.
-
Only this is for asp.net applications built from scratch. I'm thinking future maintenance. You're explanation offers at least a little bit of incite.
Ah, Well, I'm actually falling off the two location band wagon at the moment myself. My general thought was, it's a pain to sort through a few hundred stored procedures so just keep the little stuff in the code itself. Which works at first, then you wind up with a few fifty stored procedures and a few fifty in code procedures once the customer starts making requests beyond your initial design.
-
Ah, Well, I'm actually falling off the two location band wagon at the moment myself. My general thought was, it's a pain to sort through a few hundred stored procedures so just keep the little stuff in the code itself. Which works at first, then you wind up with a few fifty stored procedures and a few fifty in code procedures once the customer starts making requests beyond your initial design.
Put it all in SQL I say. We started out with some stuff in code and some in SQL, but as the number of procedures in our app now exceeds 3000 I am glad we are all in SQL now!
If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) [My Articles] [My Website]
-
Put it all in SQL I say. We started out with some stuff in code and some in SQL, but as the number of procedures in our app now exceeds 3000 I am glad we are all in SQL now!
If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) [My Articles] [My Website]
-
Seems to be the best way despite the couple of problems I've had in the past(five people trying to work on something that only has 2 connections was fun), but none of the issues have ever been the SQL so much as the IT...
-
How is having sql queries in code and stored procedures on the server make for good maintenance? Now you have two places to look for things to go wrong. :wtf:
Oh not at all now you can have them as LINQ statements as well so you have no idea what sort of code is hitting your database. Almost as silly as have clr in you database, heres another though don't just use result sets do 50% as xml results as well. Rip the frikkin lot out of the code, stick em all into procs. Have the next idiot that presents LINQ as a solution shot as an example. Oh wait why not put you linq into the cloud AAaaaahhhhhhhhh
Never underestimate the power of human stupidity RAH
-
Only this is for asp.net applications built from scratch. I'm thinking future maintenance. You're explanation offers at least a little bit of incite.
Incite and insight are quite different. :-D
I hope you realise that hamsters are very creative when it comes to revenge. - Elaine
-
Oh not at all now you can have them as LINQ statements as well so you have no idea what sort of code is hitting your database. Almost as silly as have clr in you database, heres another though don't just use result sets do 50% as xml results as well. Rip the frikkin lot out of the code, stick em all into procs. Have the next idiot that presents LINQ as a solution shot as an example. Oh wait why not put you linq into the cloud AAaaaahhhhhhhhh
Never underestimate the power of human stupidity RAH
Do I detect some issues with LINQ? :laugh:
-
Do I detect some issues with LINQ? :laugh:
Yup I have issues with linq! Stupid frikkin bloody idea thought up by Microsofts over technified geeks and inflicted on the poor bloody developer community. The miserable SOB who thought of this should be taken out and shot, boiled in oil, drawn and quartered and drowned in butter. Then deep fry the bastard. Just what we need another abstraction layer!!!!!!!
Never underestimate the power of human stupidity RAH