Click here to Skip to main content
15,886,873 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: System Context Menu (Restore,Maximize,Close etc.) on part of client area Pin
pimb225-Jun-09 8:47
pimb225-Jun-09 8:47 
GeneralRe: System Context Menu (Restore,Maximize,Close etc.) on part of client area Pin
Eddy Vluggen25-Jun-09 9:11
professionalEddy Vluggen25-Jun-09 9:11 
AnswerRe: System Context Menu (Restore,Maximize,Close etc.) on part of client area Pin
pimb210-Jul-09 4:09
pimb210-Jul-09 4:09 
QuestionHow to check if TcpClient is connected to server? [modified] Pin
s_stoqnov23-Jun-09 0:45
s_stoqnov23-Jun-09 0:45 
AnswerRe: How to check if TcpClient is connected to server? Pin
s_stoqnov23-Jun-09 2:42
s_stoqnov23-Jun-09 2:42 
AnswerRe: How to check if TcpClient is connected to server? Pin
supercat924-Jun-09 5:49
supercat924-Jun-09 5:49 
QuestionCrystal Report Pin
Bahram.Zarrin22-Jun-09 11:06
Bahram.Zarrin22-Jun-09 11:06 
QuestionThree tier architecture, database access layer pattern [modified] Pin
Julen21-Jun-09 2:35
Julen21-Jun-09 2:35 
Hi,

I am designing an architecture in .NET framework. I use the Three tier model to design my application but I have a concern about how is the way to properly model the access to database layer. I have separate DLL for each layer.

In my business layer I want to access the database, for example to add new registry in a way that the members are not passed each one in a parameter but all in a single object. For example:

namespace myapp.bussines_layer
{
class Point
{
  int x;
  int y;

  MyDatabase db = new MyDatabase();

  //I want this...
  void InsertInDatabase()
  {
    db.NewRowInDB(this);
  }

  //... instead of this
  void InsertInDatabase()
  {
    db.NewRowInDB(this.x, this.y);
  }
}
}


The thing is that this way I have circular dependency because Point knows MyDatabase; and MyDatabase has to know Point in order to recognize Point as an parameter in the function.

Does my idea fit correctly in the good practices and designs to access databases? Is better design to pass all the parameters as native types (even when the amount os parameter is high)??

I would be very grateful if anyone could help me and/or give me references to good design patterns with the connection between business and database layers.

Thank you very much in advance.

Julen.
AnswerRe: Tree tier architecture, database access layer pattern Pin
Eddy Vluggen21-Jun-09 3:31
professionalEddy Vluggen21-Jun-09 3:31 
QuestionRe: Tree tier architecture, database access layer pattern Pin
Julen21-Jun-09 3:56
Julen21-Jun-09 3:56 
AnswerRe: Tree tier architecture, database access layer pattern Pin
Eddy Vluggen21-Jun-09 5:19
professionalEddy Vluggen21-Jun-09 5:19 
AnswerRe: Tree tier architecture, database access layer pattern Pin
vasanth111122-Jun-09 0:55
vasanth111122-Jun-09 0:55 
GeneralRe: Tree tier architecture, database access layer pattern Pin
Eddy Vluggen22-Jun-09 12:24
professionalEddy Vluggen22-Jun-09 12:24 
AnswerRe: Tree tier architecture, database access layer pattern Pin
PIEBALDconsult22-Jun-09 7:46
mvePIEBALDconsult22-Jun-09 7:46 
QuestionRe: Tree tier architecture, database access layer pattern Pin
Julen22-Jun-09 11:15
Julen22-Jun-09 11:15 
AnswerRe: Tree tier architecture, database access layer pattern Pin
Eddy Vluggen23-Jun-09 0:14
professionalEddy Vluggen23-Jun-09 0:14 
AnswerRe: Tree tier architecture, database access layer pattern [modified] Pin
Dave Kreskowiak21-Jun-09 8:05
mveDave Kreskowiak21-Jun-09 8:05 
QuestionRe: Tree tier architecture, database access layer pattern Pin
Julen21-Jun-09 21:41
Julen21-Jun-09 21:41 
AnswerRe: Tree tier architecture, database access layer pattern Pin
Shukla Rahul21-Jun-09 23:54
Shukla Rahul21-Jun-09 23:54 
QuestionRe: Three tier architecture, database access layer pattern Pin
Julen22-Jun-09 0:03
Julen22-Jun-09 0:03 
AnswerRe: Three tier architecture, database access layer pattern Pin
Shukla Rahul22-Jun-09 2:40
Shukla Rahul22-Jun-09 2:40 
AnswerRe: Three tier architecture, database access layer pattern Pin
Pete O'Hanlon22-Jun-09 1:47
mvePete O'Hanlon22-Jun-09 1:47 
QuestionQuestion Regarding Owner-Drawn ComboBox Pin
Alan Burkhart20-Jun-09 15:07
Alan Burkhart20-Jun-09 15:07 
Questionwinsock problem visual basic 2008 Pin
Member 255123019-Jun-09 16:28
Member 255123019-Jun-09 16:28 
QuestionHow does Logging application handle multiple config files? Pin
Taliesin9918-Jun-09 10:36
Taliesin9918-Jun-09 10:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.