Last post Nov 22, 2007 09:53 AM by ashmetry
Nov 19, 2007 10:42 AM|engineerachu|LINK
I'm working with classifieds starter kit. I believe there is Database code is complexed in this kit. I couldn't find where the data base coding is written! Are they written in class library? And I guess, fully stored procedure is used! Can any one explain
how this database design is done?
Thanks in Advance!
Nov 19, 2007 11:03 AM|darkknight187|LINK
For the most part it uses stored procedures, and a lot of the info is set in App_Code/BLL/Ads.vb (or Ads.cs if you use c sharp)
Is there something specific you are trying to do?
Nov 19, 2007 01:29 PM|engineerachu|LINK
Not like that. I tried to find where the database (SQL) coding is written. I couldn't find any. But I believe they have written everything in business logic. Code is very complicated!. I couldn't understand anything in that.
Nov 21, 2007 10:10 AM|kp8732|LINK
I am having trouble as well attaching the dbs to my local machine.
It does not find the log file that should be attached.
Nov 22, 2007 09:53 AM|ashmetry|LINK
For this problem make sure that the mdf and ldf files are both in the same location.
to Answer Achutha's questions, this is a 3-tier application.
tier 1 is the presentation layer, (*.aspx/*.aspx.cs) files (or .vb), this contains logic & code (mostly UI stuff)
tier 2 is the buisness layer, which is the code inside BLL (Business Logic Layer) directory, which is the BRAIN of the applicaton, here you will find the business logic code that contains the business rules of the applicatoin, (eg.. Send
an email to the admin for verification whenever a new ad is posted)
tier 3 is the data layer and its represented by the code iniside DAL (Data Access), which is the layer than handles all the data, all the insert., selects..ettc . This layer simply reflects the stored procedures that handle all the data
So it depends on what you are trying to find, you can find it in its corresponding layer, but mostly the code is in the BLL, since this is classified ads applicatoin then most code is in BLL/Ads.cs as mentioned by Daniel earlier.
As a tip, the best way not to overwhelm yourself with the code is to track one thing at a time and find the code for it, the debuggger is your best friend :)
Best of luck!