books on getting stored procedures using C# and asp.net

Question

User1555545927 posted

I'm in a situation where I can only access data using stored procedures in my ASP.NET 4 application. The stored procedures are written by the database administrator and I have to write C# code to execute and extract the data using methods like ExecuteSqlReader, ExecuteSqlNonQuery, DataReader, ExecuteScalar, SqlCommand and so forth.

I would like to get a solid understanding of how to work with stored procedures from C# and how to use above methods efficiently. I'm hereby looking for books that deals with the area only. There is ADO.NET books, but they cover a much larger area than what I am in search of.

I hope someone can point out a books the specifically deals with above area. 

Answer 1

User-760709272 posted

An ADO.Net book is the only thing that's going to cover this.  Calling a SP is incredibly trivial, you'll learn everything you need from a "getting started with ado.net" tutorial on the web.

Answer 2

User-821857111 posted

It's extremely old, and I got mine for a fraction of the cover price in a bargain bin, but this book: http://www.springer.com/computer/swe/book/978-1-59059-012-6 covers ADO.NET very well.

However, the stuff you listed in your post is very very basic and is covered very well on the MSDN site, and in a thousand tutorials on-line. I don't think you should need a book.