Just today I decided to download LLBLGen to see exactly what it can do. Pretty awesome software, and generates clean code IMO. However, all this time I've been using MS DAAB, and I'm not sure if i should make a switch, not use it, or use it in conjunction with
the rest of my DAL. Here are my questions: 1. LLBLGen Seems to generate all the basic CRUD classes and sp's, and this is very helpful. However, I still have much more complex queries, so do i continue to use DAAB for these, or should I try and extend the generated
LLBLGen? 2. I currently use (and love) the feature of passing in ordered values into SqlHelper without haveing to build the SqlParameters. However, in order for this to be possible, the DAAB has to first query the metadata for the stored procedure before actually
executing the query. Is this double hit on the database expensive? 3. How easy (or tough) is it to manage a changing database schema after using and customizing code generated with LLBLGen? 4. What is the best way for my Business objects to interact with the
DAL created by LLBLGen? An example would be great. A couple more questions slightly related: 5. When a page with multiple controls, each with their own data needs, request to query the database, is it better to bundle all the queries into one request, query
the database with a stored procedure that executes several other stored procedures, returns a dataset with multiple datatables, and each control grabs it's requested data? I don't even know if this is feasible, considering i've got several controls each doing
their own thing on any given page, requesting data independantly of every other control. 6. If anyone has seen some of my posted code, you can see that my business tier is all screwed up. I need to know best practice of how my presentation layer should talk
to my business layer, what exactly should make up my business layer, and how my business layer should talk to the data layer. An example that I'm just dying to see is something where a Product is created, filled, inserted, and the result is returned all the
way back to the presentation layer so that a Confirmation message can be displayed. My app does this already, and im sure most anyone can do this.... but to have each tier only talking to the tier next to it, and to have each tier only performing functions
it is supposed to....that is the challenge for me. Whew! Now if even half of these questions can be answered, i'll be a happy guy.
sjmueller
Member
359 Points
73 Posts
LLBLGen vs. Microsoft DAAB... Plus More
Aug 16, 2003 01:23 AM|LINK