A programmer's guide to ADO.NET in C\#
The book presents ADO.NET, a tool to develop desktop or Web-based applications in .NET and C\#. Chapters 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. In 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. The book offers an integrated view of ADO.NET programming style and on its use with XML, ASP.NET, and Web services.
- Database programming with C\#
- ADO.NET examples and best practices for C\# programmers. Incl. 1 CD-ROM
- Distributed accounting processing using ADO, NET and XML
- scientific article; zbMATH DE number 1979572 (Why is no real title available?)
- scientific article; zbMATH DE number 5051585 (Why is no real title available?)
This page was built for publication: A programmer's guide to ADO.NET in C\#
Report a bug (only for logged in users!)Click here to report a bug for this page (MaRDI item Q2784227)