ADO.net Book recommendation

[Avni]

Hi,

can anyone recommend a good ADO.net book that is suitable
for beginners.
I need help in creating my standlone windows
application.As i am using an access database the example
have to be suitable for this and not just SQL server
(Like most other books).

All the books i have so far show the code that goes into
a console application with a connection to sql server
dbms. (

Any recommendations??

 

[S Gopikrishna]

I am not sure whether there are any books specific to
Access and ADO.NET

The following link gives an idea on how to go about using
Access database in ASP.NET

http://www.codeproject.com/useritems/myaspnetguestbook.asp
?print=true

-Gopi

 

[William Ryan]

Two books are already classics ...The ADO.NET Core Reference by David Sceppa
and ADO & ADO.NET Best PRactices by Bill Vaughn. If you can, get them
both...you'll be glad you did.

 

[Avni]

Hi William,
thx for your input.
Is the ADO.NET Core Reference by David Sceppa written for
VB.net developers or C# developers??
Also is the book suitable for use with an access database
or MSDE ?

 

[William Ryan]

It's written with examples in Both languages. It discusses SQLClient library
(which you can use with MSDE) and OLEDb library which Access and many other
are written on. The ORacle Provider wasn't implemented, but I think when
the second edition comes out, David will have some more discussion of it -
trust me on this..Sceppa is a killer writer and really knows his stuff - and
since his examples are in both languages, you'll be fine.

Bill's book is in VB.NET, but he has an edition in C# as well. I feel the
same way about his book...both of the guys know the fine details of their
craft, and know how to communicate it to everyone from beginners to pros.
They both write with a lot of respect for their audience.

And just as an aside....ADO.NET is ADO.NET. I'd focus on understanding it
and why it works how it does. the VB.NET vs. C# thing is trivial compared
to understanding the nuances and differences of ADO.NET. However, if you
are new to either language, then focus on the language that you are
comfortable with. Once you start warming up to it, I'd take some time and
learn the other one....

HTH,,

Bill

 

[Avni]

That is great. thx for your help william )
I think i will purchase this book.

Is it suitable for windows application development of web
development? the last book i purchased had code only for
a console application.

Before i make my purchase, can u confirm that this is the
book i need for the vb.net examples..

http://www.amazon.co.uk/exec/obidos/ASIN/0735614237/qid=10
68410861/sr=1-2/ref=sr_1_3_2/202-9740696-9212648


this is another book i have found.....
http://www.amazon.co.uk/exec/obidos/ASIN/1861008066/qid=10
68410861/sr=1-1/ref=sr_1_3_1/202-9740696-9212648

do u know if this book is any good? it is not reviewed!!

thanks once again for your prompt resonces

 

[William \(Bill\) Vaughn]

Both David's and my book(s) cover both Windows forms and Web development.
While I don't have a lot of (any) JET examples, most of the concepts apply
to both Jet and SQL Server. I didn't include JET/Access as this was
thoroughly covered before the product became obsolete. I don't recommend the
use of JET generally and never in a web site.


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[William Ryan]

The neat thign about ADO.NET is that if you write your classes properly, you
can take the Exact same code, run it on a Desktop, a WebService, an ASP.NET
page, or a PDA. ADO.NET only deals with returning data, it doesn't really
care who's making the request.

I also noticed that Bill mentioned that he doesn't discuss much about Jet.
As one of his biggest fans...I think he made a good choice by not talking
about it much. With free MSDE available....go with SQL Client. If you
really don't want to use it, then try MySQL...but Access is a Desktop
database, and as a backend to an app that has many users over a
network..you'll curse the day you chose it. Listen to Bill...few people if
any know their art better and no one gives better advice!