C-Sharp (C#) Group: GENERAL QUESTION

dear frnds,

I've a general question, i read a lot that using stored
procedures with
ASP.NET or with anything gives performance bonus, i
accept/experience
that, but i want to  know is that, why people use SPs even
for select
statements, why not use VIEWS is there any -ve impact if u
ask me i
think NOT AT ALL, views are also precompiled database
objects then Y
are they not very frequently used.

thanx


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "C-Sharp (C#)" group.
To post to this group, send email to C_Sharpgooglegroups.com
To unsubscribe from this group, send email to
C_Sharp-unsubscribegooglegroups.com
For more options, visit this group at http://groups.
google.com/group/C_Sharp
-~----------~----~----~----~------~----~------~--~---

It all goes to separation buddy. n-tier development and
whatnot. In
general you want to keep your data logic in the data tier
(hence SQL
server,) and the bussiness logic in a component/service
while the UI
goes in the presentation layer.
This makes it impossible for you or some dumbwad(from which
there are
plenty) and screw up the sql you have somewhere deep inside
an include
of an include. Ohh and it will make it hard for me, as the
new guy, to
know where exactly you decided to write your SELECT
statement.
Also, most of the SQL Server's admin prowess will be gone
if you do not
use SPs.
Views might be usefull sometimes, but most of the time they
are way to
heavy. If you have a bunch of data that never/very rarely
changes then
yes, views are cool. But you can always use a view in a SP.
Or even
have an SP create custom views. And the coolest thing is
that your
business logic and front end will be none the wiser.

Marty


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "C-Sharp (C#)" group.
To post to this group, send email to C_Sharpgooglegroups.com
To unsubscribe from this group, send email to
C_Sharp-unsubscribegooglegroups.com
For more options, visit this group at http://groups.
google.com/group/C_Sharp
-~----------~----~----~----~------~----~------~--~---