Passing Business object to Dabase Layer causes Problems, Help Needed..

[waheed azad]

Hi,

I have a been developing an accounting system for a non-profit organization. I had decided to to divide the solution, in three layers, presentation, business layer and database layer.

My business layer is composed of objects like Account, Transaction, Voucher etc. And my database layer is composed of objects like AccountDB, TransactionDB, VoucherDB.

Now each of my layer is residing in a seperate project under the same solution. And i wanted, my database objects with functions like insert(Transaction tranasaction). So I'm passing my business objects to my database objects functions, for that purpose i have the references to my database objects in my business objects.

So I'm in a position that i need a reference to my database project in my business project, and also my business project reference in my database project. Is there any way i can do this without having circular references?

Thanks in advance..

waheed.

[Frinavale]

Hi,

I have a been developing an accounting system for a non-profit organization. I had decided to to divide the solution, in three layers, presentation, business layer and database layer.

My business layer is composed of objects like Account, Transaction, Voucher etc. And my database layer is composed of objects like AccountDB, TransactionDB, VoucherDB.

Now each of my layer is residing in a seperate project under the same solution. And i wanted, my database objects with functions like insert(Transaction tranasaction). So I'm passing my business objects to my database objects functions, for that purpose i have the references to my database objects in my business objects.

So I'm in a position that i need a reference to my database project in my business project, and also my business project reference in my database project. Is there any way i can do this without having circular references?

Thanks in advance..

waheed.

I've done something similar in one of my projects.

I've created a small class library that handles all of my database transactions. In my main application I referenced this class library and created a class (called DatabaseHandler) that would server as an interface between the database class library and my application's custom objects.

DatabaseHandler accepted my applications custom objects as parameters and then called my database class library's functions...providing them with the information needed to properly fill the tables that are retrieved from my custom objects.


Eg. (in Pseudocode)

 [Database Project]
 
Class DatabaseManipulator
     Function UpdateTableA( int id, string name...)
     Function UpdateTableB(int id, string code....)
End Class
 
 [/Database Project]
 
 [Main Application (references Database Project)]
Class A
     Property ID 
     Property Name
End Class
 
Class B
     Property ID
     Property Code
End Class
 
Class DatabaseHandler
     Function FillTableA( Class A ...)
     {
         DatabaseManipulator.UpdateTableA(A.id, A.name...)
     }
 
     Function FillTableA( Class B...)
     {
         DatabaseManipulator.UpdateTableB(B.id, B.code...)
     }
End Class
 [/Main Application]
 
 

So, whenever I needed to update the database with a validated custom object I'd just call my DatabaseHandler's function and passed my custom object to it ...which would send it to my database class library to do the work for me.

Hope this helps!

-Frinny

[waheed azad]

Thanks Frinny, that seems a nice solution to my problem...

waheed.

[Frinavale]

Thanks Frinny, that seems a nice solution to my problem...

waheed.

Glad to have helped
:)