A programmer's guide to ADO.NET in C\# (Q2784227)

The book presents ADO.NET, a tool to develop desktop or Web-based applications in .NET and C\#.NEWLINENEWLINEChapters 1 and 2 covers the basic concepts of the C\# language (syntax, data types, control flow, classes and their members, interfaces, arrays, exception handling) and Windows Forms (how to write Windows application using the command line, or Visual Studio .NET IDE). Chapter 3 presents the basic concepts of ADO.NET and shows how to write simple applications to access databases using ADO.NET as well as advantages over current data access technologies. Chapter 4 focuses on how to develop with Visual Studio .NET database applications; VS.NET tools like Server Explorer and Data Form wizard as well as the use of VS.NET to write XML schemas are presented. Chapter 5 covers more advanced features of ADO.NET architecture and the basic building blocs of ADO.NET and ADO.NET data providers; class hierarchy models of various data providers (OleDB, Sql, ODBC) and ADO.NET components (connection, command, dataset, data reader) are also described. Chapter 6 is dedicated to XML; basic operations with XML documents (read, write, navigate, remove, delete) are presented; the relationships between XML and ADO.NET and how to mix them up are covered. Chapter 7 presents ASP.NET and Web Forms and how to write database applications using ASP.NET and C\#; an example showing how to develop a guest book for a Web site using ASP.NET is discussed.NEWLINENEWLINEIn chapter 8 the problem of writing database Web services and Web service consumer application is presented. Event handling is introduced in chapter 8; the use of events for different objects (connection, dataset, data table, data adapter objects) is discussed. Chapter 10 shows how to write database applications utilizing the power of stored procedures and views; the use of data access technologies such as Active X Data Objects (ADO), ADO Extensions for Data Definition Language and security (ADOX), and Active X Data Objects Multi-Dimensional Library (ADOMD) is also presented. The last chapter discusses ODBC.NET data provider and how to access different ODBC data sources. Examples of MySQL, Oracle, Excel and text data files are also presented. Basic database concepts (locking, cursors, and normalization) are presented in Appendix A and a quick reference to SQL statements is made in Appendix B.NEWLINENEWLINEThe book offers an integrated view of ADO.NET programming style and on its use with XML, ASP.NET, and Web services.