- Shopping Bag ( 0 items )
No matter what programs you develop, there always exists a bottom line: you must know how to access and manipulate data. This book teaches you all the essential data manipulation skills that you will need when you code in C#.
Data can be stored in many places, but large quantities of data that need to be frequently accessed are usually stored in relational databases such as SQL Server. Knowing how this data is structured, and how to access and update it, are therefore the most important programming tasks the professional programmer needs to learn.
As well as teaching you database basics, such as using SQL to communicate with databases, this book provides you with detailed and code-practical techniques to access data in C# across a wide range of specific coding situations. Code-heavy and full of practical detail, this book has been fully revised and upgraded for .NET 1.1 and offers you the best contemporary practice in this core programming area that you'll find yourself using in nearly all of your .NET projects.
|Ch. 1||Installing MSDE||1|
|Ch. 2||Creating a simple database application||17|
|Ch. 3||Introducing SQL||39|
|Ch. 4||What's ADO.NET?||63|
|Ch. 5||Creating connections||89|
|Ch. 6||Introducing commands||113|
|Ch. 7||Introducing data readers||145|
|Ch. 8||Introducing datasets and data adapters||173|
|Ch. 9||Building Windows forms applications||219|
|Ch. 10||Using ASP.NET||249|
|Ch. 11||Validating Web user input||291|
|Ch. 12||Working with tables and relationships||317|
|Ch. 13||Learning more about queries||343|
|Ch. 14||Using views and stored procedures||381|
|Ch. 15||Using indexes and constraints||417|
|Ch. 16||Securing your database||441|
|Ch. 17||Using XML and ADO.NET||467|
|Ch. 18||Handling exceptions||487|
|Ch. 19||Using transactions||509|
|Ch. 20||Working with ADO.NET events||523|
|Ch. 21||Working with text and binary data||541|
|Ch. 22||Using ADO.NET 2.0||567|
|App. A||Creating the SQL tool application||581|
|App. B||XML primer||593|
Posted December 22, 2004
The databases referred to in the title are mostly SQL databases. The authors explain how with the advent of .NET and C#, Microsoft overhauled the entire database accessing, into as simple a usage as possible. To this ends, they give prominent place to ADO.NET, which wraps access to various types of databases, like Oracle and Microsoft's own SQL Server. So that your C# code can stay as independent of the underlying choice of database as possible. You might actually appreciate this book more if you have had the dubious pleasure of using the earlier ADO in pre .NET, to get at your database. Now, ADO.NET lacks the grubby ActiveX and appears to be much more elegant and powerful. Not the least of which is the book's delving into the XML capabilities of ADO.NET. You can now in C# read and write data files in XML. Basically, you have an object oriented database, instead of those other relational databases, where you commit directly to the filesystem. But if you get a fully fledged object oriented database like Versant, then your C# code can very easily match to it.Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.