How to write 3-Tier Application using c# windows Application with MS SQL Server 2000?.

How to write 3-Tier Application using c# windows Application with MS SQL Server 2000?.

• codequest

  OK, that's a bit clearer. If you're using a database, then it's arguable that your app IS 3 tier, especially if you're doing the right thing and making all data access via stored procs, and putting all the code that calls the stored procs in a single class. Basically, if you're writing the app so that you have one point of contact between the database and your middle tier, the app is 3 tier.

  
  
  

• SaliDM

  I think it depends on how big your app is. If you have 20 odd stored procs, they may as well be in the middle tier, in a class. If you have 20 different entities which each have lots of procs, you need to build a dll for that code.

  
  
  

• Craig Thomson

  Thanks. yesterday I read a artical in that they mention that First Layer contains Forms and control and the second Layer contains the collection of properties and the Data Layer contains the connection object and details about datafetch ( which Stored Procedure Should Fetch ) and the final layer Data Base (MSSQL Server) . If a user invokes the Show Details Button throw UI , first it fetch the data from data layer and it assignes to second Layer ( Collection of Property) and the UI will fetch the data from Property and displays ... Is it so ..... Need to confrim with Expert .....
  

• alsadykov

  That's a bit of a massive question. Which part are you having trouble with Are you new to programming overall Have you written n-tiered apps before You need to define where you are coming from and ask more specific questions if you want a meaningful answer. The web also abounds with info on this, certainly at the broad level that you've posed the question.

  
  
  

• Phlin

  Presently i am working in 2-Tier Application. I have created two projects in a solutions . One is Form Design(Application Layer) and another is to fetch(Full of Class Files) the data from db and assigns to the property and the Application Layer gets the data from Property and assignes to UI Controls. This is the way i am proceeding now . So I want to know how to handle this Application in 3-Tier .
  

• Test 007

  Thanks Cgraus .. If you find any good method to proceed .. please let me know .. My ID : senthilkumar@pinnacle-aims.com..
  

• Constantin Mihai - MSFT

  Yes, it sounds like it.

  
  
  

• Ben Morris

  Yes . I have nearly 60 forms and morethat 100 stored procedures . Is that a good way to do .
  
• How to write 3-Tier Application using c# windows Application with MS SQL Server 2000?.