Click here to Skip to main content
15,898,010 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
GeneralRe: Never use pure built in types Pin
jschell12-Dec-14 12:29
jschell12-Dec-14 12:29 
GeneralRe: Never use pure built in types Pin
den2k8814-Dec-14 0:09
professionalden2k8814-Dec-14 0:09 
GeneralRe: Never use pure built in types Pin
jschell16-Dec-14 12:37
jschell16-Dec-14 12:37 
AnswerRe: Never use pure built in types Pin
jschell12-Dec-14 12:26
jschell12-Dec-14 12:26 
GeneralRe: Never use pure built in types Pin
D4rkTrick21-Dec-14 8:17
professionalD4rkTrick21-Dec-14 8:17 
QuestionHow to avoid backend stored procedures Pin
nstk8-Dec-14 21:24
nstk8-Dec-14 21:24 
JokeRe: How to avoid backend stored procedures Pin
Brady Kelly12-Dec-14 5:52
Brady Kelly12-Dec-14 5:52 
AnswerRe: How to avoid backend stored procedures Pin
Eddy Vluggen12-Dec-14 7:27
professionalEddy Vluggen12-Dec-14 7:27 
nstk wrote:
having each more or less 300 stored procedures!
..it can hold lots more.

nstk wrote:
as they do not contain any object oriented thinking
And why is that a problem?

nstk wrote:
in the end we have a procedural code like in the days of old good C.
C and TSQL are different beasts.

nstk wrote:
We have to deal with lots of bugs, which is not sure whether they come from
backend (MSSQL) or the frontend (Windows App in C#)
Simple; if it is raised after executing a query, it is in the database. With sprocs it is even easier to verify as one only has to check the parameters.

A good way would be to have error-handling in the sproc, and rollback any changes if there's an error, and raising your own custom error that gets handled and logged by the C# code. There's examples on this site on how to do so.

nstk wrote:
Are there any other solutions to avoid so much SPs and still have a professional
code?
Yes, the alternative is to use inline SQL. That'll be even harder to debug.

nstk wrote:
I thought of exchanging SELECT SPs through Views
A view is nothing more than a SELECT statement. You can create 300 views, but they would not be very object-oriented. You also cannot pass a parameter to a view like one could with a sproc. Finally you could execute the select directly from code, without any views or sprocs - but that would be rather dirty.

SProcs are the professional way.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

AnswerRe: How to avoid backend stored procedures Pin
Dominic Burford23-Dec-14 1:35
professionalDominic Burford23-Dec-14 1:35 
QuestionRearchitecting BackgroundWorker based to Task based? Pin
Matt T Heffron17-Nov-14 12:49
professionalMatt T Heffron17-Nov-14 12:49 
AnswerRe: Rearchitecting BackgroundWorker based to Task based? Pin
Richard Deeming18-Nov-14 2:45
mveRichard Deeming18-Nov-14 2:45 
AnswerRe: Rearchitecting BackgroundWorker based to Task based? Pin
Gerry Schmitz18-Nov-14 7:00
mveGerry Schmitz18-Nov-14 7:00 
QuestionRemote Desktop Connection Pin
Non Sequitur11-Nov-14 3:43
Non Sequitur11-Nov-14 3:43 
SuggestionRe: Remote Desktop Connection Pin
ZurdoDev11-Nov-14 5:27
professionalZurdoDev11-Nov-14 5:27 
AnswerRe: Remote Desktop Connection Pin
Pete O'Hanlon11-Nov-14 5:57
mvePete O'Hanlon11-Nov-14 5:57 
QuestionWhat is an architect for? Pin
Member 448708318-Oct-14 10:19
Member 448708318-Oct-14 10:19 
JokeRe: What is an architect for? Pin
Vivi Chellappa18-Oct-14 18:43
professionalVivi Chellappa18-Oct-14 18:43 
AnswerRe: What is an architect for? Pin
kimpetwangi25-Oct-14 17:12
kimpetwangi25-Oct-14 17:12 
AnswerRe: What is an architect for? Pin
Richard MacCutchan18-Oct-14 21:22
mveRichard MacCutchan18-Oct-14 21:22 
GeneralRe: What is an architect for? Pin
Member 448708318-Oct-14 21:59
Member 448708318-Oct-14 21:59 
GeneralRe: What is an architect for? Pin
Richard MacCutchan18-Oct-14 22:08
mveRichard MacCutchan18-Oct-14 22:08 
AnswerRe: What is an architect for? Pin
Eddy Vluggen19-Oct-14 3:50
professionalEddy Vluggen19-Oct-14 3:50 
GeneralRe: What is an architect for? Pin
Member 448708319-Oct-14 11:26
Member 448708319-Oct-14 11:26 
GeneralRe: What is an architect for? Pin
Eddy Vluggen20-Oct-14 1:44
professionalEddy Vluggen20-Oct-14 1:44 
AnswerRe: What is an architect for? Pin
Mycroft Holmes19-Oct-14 12:48
professionalMycroft Holmes19-Oct-14 12:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.