Databases
StackOverflow2013
Postsdbo
POLooking to design a tool to Translate Business logic from Stored Procedures to C# Business Layer
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLooking to design a tool to Translate Business logic from Stored Procedures to C# Business Layer
    primarykey
    data
    text
    <p>Without getting into a discussion about whether the business logic should be in the database or at the application layer, since it has been covered <a href="https://stackoverflow.com/questions/119540/business-logic-database-or-application-layer">elsewhere</a>.</p> <p>My team is translating <strong>100K+</strong> lines of PL/SQL code and moving the logic from the database into the application. We were using VB6 with straight calls to Oracle 9i Stored Procedures and Ad-hoc queries and are now using C#, .net 3.5, Winforms with NHibernate to an Oracle 9i database.</p> <p>We have already found a wonderful tool to assist in converting the Ad-hoc queries, <a href="http://www.codeproject.com/KB/dotnet/SmartCode-Code_Generation.aspx" rel="nofollow noreferrer">SmartCode</a>, but it only creates code based on Tables and Views. We are looking for a tool to assist in converting the Stored Procedures.</p> <p>The Stored Procedures have most of the Business logic in them that we want to migrate to the application layer. We are wondering if there are any tools to convert the Stored Procedures into C# code. </p> <p>Assuming there are none, what would be the best place to start if we develop the tool in-house/open source. Is there another similar system with similar goals that could be used as a starting place?</p> <p><strong>Accepted Answer UPDATE:</strong> I have selected scope-creep's answer, because it appears to be the best method for implementing the issue presented in the question. For those that deal with this same issue, I heartedly recommend Adam's response, as he has strongly advocated against the use of a tool and provides a strong rationale. He has also provided the most interaction with this question and had the most up-voted response.</p> <p>Thank you to everyone for your help and dialog.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USLucas B
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POLooking to design a tool to Translate Business logic from Stored Procedures to C# Business Layer
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POLooking to design a tool to Translate Business logic from Stored Procedures to C# Business Layer
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POLooking to design a tool to Translate Business logic from Stored Procedures to C# Business Layer
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHow much code do you have in the stored procedures? If you convert it all by hand, how long do you think it will take?
      singulars
      1. POLooking to design a tool to Translate Business logic from Stored Procedures to C# Business Layer
      1. USIra Baxter
    2. COThousands of lines. From a cursory analysis, much of the code is similar, just particular to the table in question. Most of the "similar" code, which I estimate to be 60-70% is around null/empty string issues and soft-delete filtering.
      singulars
      1. POLooking to design a tool to Translate Business logic from Stored Procedures to C# Business Layer
      1. USLucas B
    3. COI estimate it would take many months to convert the code by hand, which is why I am considering using or creating a tool to do this.
      singulars
      1. POLooking to design a tool to Translate Business logic from Stored Procedures to C# Business Layer
      1. USLucas B
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload