SQL Server with C#

This document was uploaded by one of our users. The uploader already confirmed that they had the permission to publish it. If you are author/publisher or own the copyright of this documents, please report to us by using this DMCA report form.

Simply click on the Download Book button.

Yes, Book downloads on Ebookily are 100% Free.

Sometimes the book is free on Amazon As well, so go ahead and hit "Search on Amazon"

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 specific Relational Database Management System (RDBMS) and its SQL. You need somehow to interface to this from your application which, by the way, you also need to design. You can get far with frameworks, but can you go all the way? Do you have a well-performing and maintainable solution? This book aims to guide you through the jungle. SQL Server is chosen as the main RDBMS, while the database-interface design is demonstrated to work with Oracle as well. The real-life sample application is written in C# using classic Windows Forms. However, the main design and databaseinterface is equally relevant for WPF and ASP.net. The database framework used is ADO.net. The author works with embedded systems and previously wrote the book "Embedded Software for the IoT." Creating database-based tools, he faced the challenges described, and refined a pattern over time.

Author(s): Klaus Elk
Publisher: Createspace Independent Publishing Platform
Year: 2018

Language: English
Pages: 146

Cover
Title Page
Preface
Contents
1 Introduction
PART I SQL Server
2 Database Basics
3 TimeReg Database
4 SQL
PART II C# Programming
5 Overall Design
6 Model Layer
7 Database Functions
8 Data Transfer Objects
9 UI Design
10 Using Excel
Index