SQL Server with C# Applications
Creating a full database application from scratch can be a challenge. You need to understand the basics of database design, as well as the specificRelational Database Management System (RDBMS) and its SQL.You need somehow to interface to this from your application which, bythe way, you also need to design. You can get far with frameworks, butcan you go all the way? Do you have a well-performing and maintainablesolution?
This book aims to guide you through the jungle. SQL Server is chosen asthe main RDBMS, while the database-interface design is demonstrated towork with Oracle as well. The real-life sample application is written in C#using classic Windows Forms. However, the main design and databaseinterfaceis equally relevant for WPF and ASP.net.The database framework used is ADO.net.The author works with embedded systems and previously wrote the bookEmbedded Software for the IoT. Creating database-based tools, he facedthe challenges described, and refined a pattern over time.