"Cirene" <ci****@nowhere .comwrote in message
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..
>I am working on an ASP.NET 2.0/SQL Server enterprise application which is
basically a online scheduler (like Outlook functionality.) There will be
many simultaneous users hopefully.
For my sql related tasks I was thinking that most of the work can be done
using Visual Studio's GUI Wizards (drag/drop, etc...) without writing any
SQL related code.
Is there any benefit to choosing to write stored procedures or inline SQL
code (like in a DAL class) over simply using the GUI to do the "code"?
Yes. Separation of concerns.
You have a UI of some sort (web, it appears, since you posted here), some
business logic and data logic, along with physical data storage. Each has
its own purpose.
When you drag and drop UI code, you marry the UI to the database you are
using. This may be okay in your case, but you should be making a conscious
decision to bind the layers together in this manner.
--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA
Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss
or just read it:
http://gregorybeamer.spaces.live.com/
*************** *************** *************** ****
| Think outside the box!
|
*************** *************** *************** ****