Wrox Programmer Forums
|
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 15th, 2011, 03:13 PM
Authorized User
 
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
 
Old March 15th, 2011, 03:32 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 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!
The Following User Says Thank You to Imar For This Useful Post:
TeaDrinkingGeek (March 15th, 2011)
 
Old March 15th, 2011, 05:22 PM
Authorized User
 
Join Date: Feb 2011
Posts: 33
Thanks: 5
Thanked 0 Times in 0 Posts
Default

Thanks for your reply.

EF next chapter :)

Regards
TDG
 
Old March 16th, 2011, 02:22 PM
Registered User
 
Join Date: Jul 2010
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
 
Old March 16th, 2011, 03:20 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 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!





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





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