Click here to Skip to main content
15,888,351 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Rewrite or...? Pin
Sander Rossel11-Sep-22 0:05
professionalSander Rossel11-Sep-22 0:05 
AnswerRe: Rewrite or...? Pin
Cliff Buckley9-Sep-22 4:36
Cliff Buckley9-Sep-22 4:36 
AnswerRe: Rewrite or...? Pin
Member 93013329-Sep-22 4:37
professionalMember 93013329-Sep-22 4:37 
AnswerRe: Rewrite or...? Pin
Kirk 103898219-Sep-22 8:21
Kirk 103898219-Sep-22 8:21 
AnswerRe: Rewrite or...? Pin
DerekT-P9-Sep-22 8:49
professionalDerekT-P9-Sep-22 8:49 
GeneralRe: Rewrite or...? Pin
Sander Rossel9-Sep-22 23:37
professionalSander Rossel9-Sep-22 23:37 
AnswerRe: Rewrite or...? Pin
BryanFazekas9-Sep-22 9:28
BryanFazekas9-Sep-22 9:28 
AnswerRe: Rewrite or...? Pin
Luca Leonardo Scorcia11-Sep-22 2:39
professionalLuca Leonardo Scorcia11-Sep-22 2:39 
I've been there many times as it seems I am one of those (un)lucky ones that actually enjoys untangling legacy code messes mysteries. What I usually do, after getting the hang of how to do a release with the current process, is:

1) Automating CI/CD - some things will be broken by refactorings, better be able to build/test/release quickly. Moreover, nowadays Git is a must;
2) Encapsulating all data access queries. Start with the writes, there are less of them and most of the time they can easily be ported to a proper data layer. Bonus points if you can start using a framework like EF6 that still runs on .net Framework - this may mean porting the SPs to code, but as you already mentioned that doubles as "putting them in source control".
3) Try to find the "bundles" of DB reads/writes and pack them into meaningful methods. This will be your business layer. May need to use TransactionScope to build some simple "unit of work" pattern here. Unless you need to use multiple databases this won't require using DTC so no major architectural problems here.
4) When all previous steps are completed, you have a UI shell around a business layer. That will need to be rewritten using your favorite technology. That's going to be less boring Smile | :)
Luca

The Price of Freedom is Eternal Vigilance. -- Wing Commander IV

En Það Besta Sem Guð Hefur Skapað, Er Nýr Dagur.
(But the best thing God has created, is a New Day.)
-- Sigur Ròs - Viðrar vel til loftárása


modified 11-Sep-22 8:50am.

AnswerRe: Rewrite or...? Pin
Max Santos12-Sep-22 9:41
Max Santos12-Sep-22 9:41 
AnswerRe: Rewrite or...? Pin
Matt McGuire16-Sep-22 5:31
professionalMatt McGuire16-Sep-22 5:31 
RantHow arrogant one can be? Pin
Kornfeld Eliyahu Peter7-Sep-22 22:43
professionalKornfeld Eliyahu Peter7-Sep-22 22:43 
GeneralRe: How arrogant one can be? Pin
Richard MacCutchan7-Sep-22 22:59
mveRichard MacCutchan7-Sep-22 22:59 
GeneralRe: How arrogant one can be? Pin
Sander Rossel8-Sep-22 0:46
professionalSander Rossel8-Sep-22 0:46 
GeneralRe: How arrogant one can be? Pin
Kornfeld Eliyahu Peter8-Sep-22 1:00
professionalKornfeld Eliyahu Peter8-Sep-22 1:00 
GeneralRe: How arrogant one can be? Pin
Rick York8-Sep-22 7:36
mveRick York8-Sep-22 7:36 
GeneralRe: How arrogant one can be? Pin
Maximilien8-Sep-22 1:07
Maximilien8-Sep-22 1:07 
GeneralRe: How arrogant one can be? Pin
Kornfeld Eliyahu Peter8-Sep-22 1:18
professionalKornfeld Eliyahu Peter8-Sep-22 1:18 
GeneralRe: How arrogant one can be? Pin
Daniel Pfeffer8-Sep-22 3:17
professionalDaniel Pfeffer8-Sep-22 3:17 
GeneralRe: How arrogant one can be? Pin
Greg Utas8-Sep-22 4:17
professionalGreg Utas8-Sep-22 4:17 
GeneralRe: How arrogant one can be? Pin
OriginalGriff8-Sep-22 2:40
mveOriginalGriff8-Sep-22 2:40 
GeneralRe: How arrogant one can be? Pin
Jacquers8-Sep-22 5:05
Jacquers8-Sep-22 5:05 
GeneralRe: How arrogant one can be? Pin
Jacquers8-Sep-22 5:07
Jacquers8-Sep-22 5:07 
GeneralRe: How arrogant one can be? Pin
TNCaver8-Sep-22 5:51
TNCaver8-Sep-22 5:51 
GeneralRe: How arrogant one can be? Pin
englebart8-Sep-22 13:34
professionalenglebart8-Sep-22 13:34 
GeneralRe: How arrogant one can be? Pin
Mike Hankey8-Sep-22 6:57
mveMike Hankey8-Sep-22 6:57 

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.