Architecturing DAL & BLL
-
Hope im in the right board for the type of questions i am about to ask. I'm turning into the BLL / DAL 3 tiers architecture and i'm confused a bit. Just to clear things up - i'm working on VStudio 2005, .net 2.0 - my DAL implementation would be in an xsd file (typed dataset) - my BLL will be my own "wrapper" around the DAL 1) What is the relation between a Database Table, a DAL/BLL set, and a set of operations i.e: Say i have an Order Editing form. I will in this form Delete full orders, by means of an orders list, and i will be able to Edit some order details, as Both the order header (Master table) and the order rows (Child Table). Now, should i create a DAL containing both Tables or should i work with 2 DAL/BLL objects, one containing my master table, the other containing my details table ? On my Shipping Form, i need access to both Order Master/Details and Inventory because when i ship some items, my inventory has to decrease. I also need to validate that i have enough inventory to complete the operation... should inventory be part or the same DAL Definition ? Should i create a new DAL / BLL ? I'm sure you can see i'm really confused and i will appreciate any pointers to guide me. DB
-
Hope im in the right board for the type of questions i am about to ask. I'm turning into the BLL / DAL 3 tiers architecture and i'm confused a bit. Just to clear things up - i'm working on VStudio 2005, .net 2.0 - my DAL implementation would be in an xsd file (typed dataset) - my BLL will be my own "wrapper" around the DAL 1) What is the relation between a Database Table, a DAL/BLL set, and a set of operations i.e: Say i have an Order Editing form. I will in this form Delete full orders, by means of an orders list, and i will be able to Edit some order details, as Both the order header (Master table) and the order rows (Child Table). Now, should i create a DAL containing both Tables or should i work with 2 DAL/BLL objects, one containing my master table, the other containing my details table ? On my Shipping Form, i need access to both Order Master/Details and Inventory because when i ship some items, my inventory has to decrease. I also need to validate that i have enough inventory to complete the operation... should inventory be part or the same DAL Definition ? Should i create a new DAL / BLL ? I'm sure you can see i'm really confused and i will appreciate any pointers to guide me. DB
Howdy I recently read a 3 part article by Imar Spaanjaars on n-tier (basically 3 tier) architecture in C#. Coming from many years of n-tier architecture in Java I found this article a very good read. It covers the basics real well and explains the important decisions. The article can be found at http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=416[^] Cheers Q