Converting LLBL Generated output to Readable / Formatted output

Posts   
 
    
MaddCoder
User
Posts: 1
Joined: 06-Jan-2012
# Posted on: 06-Jan-2012 20:50:22   

This is a simple application that will convert the giant 1000 character output to a readable output with all the paramters (@someParamter) replaced with their values

The idea to get a output that can be copied and pasted into your query window and run.

Attachments
Filename File size Added on Approval
LLBL2SQL-WPF.zip 138,028 06-Jan-2012 20:51.41 Approved
daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 07-Jan-2012 01:20:20   

Thanks for the contribution MadMan wink

You also could use your code to trap the generated SQL from the LLBLGen tracing and reformat it. Then you don't need to copy-paste the sql in your app. This is similar to what Miha did in this article: http://cs.rthand.com/blogs/blog_with_righthand/pages/Implementing-more-useful-tracing-for-LLBLGenPro-2.0.aspx

Also you can use ORMProfiler which also present a human-readable sql and do other powerful analysis.

Anyway thanks again for the contribution.

David Elizondo | LLBLGen Support Team