In-Depth

Books: Master C# Database Programming

Database Programming with C# explains the essentials of database programming to those familiar already with C#. Learn to exploit the VS.NET IDE to access data, and more.

There's no doubt C# is here to stay. Countless organizations and individuals are investing their time and money into mastering this new standard language, and as with most languages, understanding how to access data is a requirement in becoming a proficient application developer. Carsten Thomsen's Database Programming with C# helps shed some light on this foundational topic.

The book is divided into three sections. The first is a brief introduction to C# itself. The second part comprises the heart of the book; Thomsen covers high-level database programming concepts, including how to use ADO.NET in both a connected and disconnected state, how to use the Visual Studio IDE to help access data, and how to manage data exceptions. The book centers on using SQL Server and details the use of stored procedures, views, and triggers. Thomsen also spends time demonstrating how to connect to hierarchical databases, such as Active Directory, and he provides insight into working with Microsoft Message Queue Server.

The third section of the book uses a sample application to give you insight into data access with C#. Thomsen provides an appendix with further information on the use of XML with SQL Server 2000.

Overall, this book has a lot of breadth, and is great for those who are fluent already in C# and have little to no experience with database programming.


Database Programming with C#
by Carsten Thomsen
Apress
ISBN: 1590590104
Price: $54.95
Quick Facts: Covers a wide range of topics, including basic consumption of ADO.NET, accessing LDAP data, working with message queues, creating data wrappers, and using data-bound controls.
Pros: Provides introductory information on many data-access subjects; covers the complete spectrum of data-access techniques.
Cons: Not written for seasoned developers or those looking for data-access design-pattern information. Doesn't cover many different databases, such as DB2 or Oracle.

About the Author

Joel Semeniuk is a founder of Imaginet Resources Corp., a Canada-based Microsoft Gold Partner. Currently, Joel is also serving as an Executive VP of Agile Project Management Tools at Telerik. He is also a Microsoft Regional Director and MVP Microsoft ALM, with a degree in Computer Science. With more than 18 years of experience, Joel specializes in helping organizations around the world realize their potential through maturing their software development and information technology practices. Joel is passionate about Application Lifecycle Management tooling, techniques and mindsets, and regularly speaks at conferences around the world on a wide range of ALM topics.

comments powered by Disqus

Featured

  • AI for GitHub Collaboration? Maybe Not So Much

    No doubt GitHub Copilot has been a boon for developers, but AI might not be the best tool for collaboration, according to developers weighing in on a recent social media post from the GitHub team.

  • Visual Studio 2022 Getting VS Code 'Command Palette' Equivalent

    As any Visual Studio Code user knows, the editor's command palette is a powerful tool for getting things done quickly, without having to navigate through menus and dialogs. Now, we learn how an equivalent is coming for Microsoft's flagship Visual Studio IDE, invoked by the same familiar Ctrl+Shift+P keyboard shortcut.

  • .NET 9 Preview 3: 'I've Been Waiting 9 Years for This API!'

    Microsoft's third preview of .NET 9 sees a lot of minor tweaks and fixes with no earth-shaking new functionality, but little things can be important to individual developers.

  • Data Anomaly Detection Using a Neural Autoencoder with C#

    Dr. James McCaffrey of Microsoft Research tackles the process of examining a set of source data to find data items that are different in some way from the majority of the source items.

  • What's New for Python, Java in Visual Studio Code

    Microsoft announced March 2024 updates to its Python and Java extensions for Visual Studio Code, the open source-based, cross-platform code editor that has repeatedly been named the No. 1 tool in major development surveys.

Subscribe on YouTube