 |
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
|
|
|
|
|

March 15th, 2011, 03:13 PM
|
|
Authorized User
|
|
Join Date: Feb 2011
Posts: 33
Thanks: 5
Thanked 0 Times in 0 Posts
|
|
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
|
|

March 15th, 2011, 03:32 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
|
The Following User Says Thank You to Imar For This Useful Post:
|
|
|

March 15th, 2011, 05:22 PM
|
|
Authorized User
|
|
Join Date: Feb 2011
Posts: 33
Thanks: 5
Thanked 0 Times in 0 Posts
|
|
Thanks for your reply.
EF next chapter :)
Regards
TDG
|
|

March 16th, 2011, 02:22 PM
|
|
Registered User
|
|
Join Date: Jul 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|

March 16th, 2011, 03:20 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
|
 |
|