Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 4 : in C# and VB
This is the forum to discuss the Wrox book Beginning ASP.NET 4: in C# and VB by Imar Spaanjaars; ISBN: 9780470502211
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 4 : in C# and VB section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 15th, 2011, 03:13 PM
Authorized User
Points: 145, Level: 2
Points: 145, Level: 2 Points: 145, Level: 2 Points: 145, Level: 2
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2011
Posts: 33
Thanks: 5
Thanked 0 Times in 0 Posts
Default Stored Procedures

Hi Imar,

is there a reason that you didn't include Strored Procedures in your book Beginning ASP.NET 4?

Are they not popular with Developers anymore?

Regards
TDG
Reply With Quote
  #2 (permalink)  
Old March 15th, 2011, 03:32 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi there,

I did include them; the Membership and Roles providers use them in the aspnetdb database.... ;-)

Kidding aside, they are still popular, and I still use them in many projects. However, I consider them to be a more advanced topic. Since I didn't want to write a 1,600 page Beginners book (or actually, since you didn't want to buy and read a 1,600 page Beginners book), I decided to leave this topic out.

Also, for many common scenarios, EF or L2S is more than enough for data access and you don't need them anymore. I think I cut the projects that use them in halve since I use EF a lot....

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
The Following User Says Thank You to Imar For This Useful Post:
TeaDrinkingGeek (March 15th, 2011)
  #3 (permalink)  
Old March 15th, 2011, 05:22 PM
Authorized User
Points: 145, Level: 2
Points: 145, Level: 2 Points: 145, Level: 2 Points: 145, Level: 2
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2011
Posts: 33
Thanks: 5
Thanked 0 Times in 0 Posts
Default

Thanks for your reply.

EF next chapter :)

Regards
TDG
Reply With Quote
  #4 (permalink)  
Old March 16th, 2011, 02:22 PM
Registered User
 
Join Date: Jul 2010
Location: Québec
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Imar,

Also, for many common scenarios, EF or L2S is more than enough for data access and you don't need them anymore [Store Procedures].


I don't really agree with that point. Even in 2011, many companies still continue to use SQL Server 2000 in common scenarios. As you probably know, this version of SQL Server is not supported by Visual Studio 2010 and by Microsoft anymore. So, only considering EF or L2S for database access is like shooting himself in the foot. I unfortunately know what I’m talking about… ;-).

Moreover, one advantage of Store Procedures above EF or L2S is that the version of SQL Server can be abstracted, making web applications more flexible.

I agree with you on the fact that Stored Procedures is a more advanced topic, and nobody wants to find big boring theory about it in your book. But some simple explanations about how to call Stored Procedures and retrieve data from them could be a great addition to chapter 15.
Cheers,

Mikael
Reply With Quote
  #5 (permalink)  
Old March 16th, 2011, 03:20 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Absolutely. I agree with what you say.

I didn't say they were obsolete or not used anymore. I said they are not needed in many common cases (while I acknowledge they are still common in many other cases). I have seen tens or hundreds of sites in the past year that don't use them anymore while they would have been used pre EF.

Personally, I think stored procedures are better off in the Pro ASP.NET series.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
stored procedures MunishBhatia SQL Server 2005 4 April 12th, 2008 01:39 AM
stored procedures thillaiarasu ASP.NET 2.0 Basics 2 May 3rd, 2007 07:55 AM
Help me to DO Stored Procedures msbsam SQL Server 2000 3 October 23rd, 2006 01:54 PM
Stored Procedures seanmayhew BOOK: ASP.NET Website Programming Problem-Design-Solution 4 June 10th, 2004 10:06 AM
Using Stored Procedures lintacious Classic ASP Basics 1 August 12th, 2003 04:06 PM



All times are GMT -4. The time now is 01:26 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.