Hi all,

Can I reuse ThePhile code to build an intranet for my company? If yes, how should I acknowledge the authors' work?

Thanks.

Sure you can. I don't think you need to acknowledge the authors because you'll probably make a lot of changes to customize the code. You can have some kind of link called "this website" where you explain that the code is based on this book if you want to.

Following the technique used by the authors in this book to develop professional website will be a catastrophic mistake.

Few Reasons:
  -this approach is hardcoded approch and solution will not scale. You have stored procedure to insert\update\delete\search for each module\category. In case you need to add some new field to your schema, you end up modifying the stored proc, data layer, business layer, recompile, retest and many other pains. Same applies when you want to delete some fields.

  -It might work for personal website with ~1000 records having a childish schema as well as when you know beforehand that your scheme will never change. Otherwise you have to make changes in everywhere.

For professional site, you need to develop complex schema driven by metadata and program each functionality once. Why writing 5 different stored procedures for 5 modules while you doing same operation-insert?
Ideally you need to write a generic logic that will work for entire schema driven by what is on the form rather than table name.

I am surprized to see that few people just love writing books with limited skills and knowledge and misguide developers to a wrong direction.

Thanks
Mohammad Musa

We agree that the schema needs work!

But the idea of hard-coded procs vs general procs is a matter of choice. It's common to see specialized procs to get the most performance, even though it makes new development and maintenance harder.

But then, performance wasn't a serious goal of the designers of this particular application. I think it's clear that these authors weren't SQL experts when they wrote the book.

What do you think of the ASP.NET design? The real goal of this book was the code. The database was just something they needed, and wasn't a big part of their goals (at least I hope it wasn't one of their big goals).

Eric

Generic data access logic has security issues. You give the presentation layer control and duties better suited to the data access layer.

But least I appear to have "limited skills and knowledge" (as you claim of the authors) please post links that support Generic data access.

Thanks,
Dave

 love when people critized everything other people do.... but never give any solution... as a General manager of a department of development in Venezuela, I always am, very clear if some one is going to pin-point a problem [u]they better have a solution with it</u> ....

Thanks ! ;)