This document discusses some general principles in developing database applications using
C#, .NET, and Microsoft SQL Server. We’ll develop a command line database application to manage contacts. General ideas apply to the GUI oriented version—in fact, that’s the homework: To create a GUI version of this thing.

For this whole scheme to work, you need a few tools. These include:
• .NET Framework SDK
• Microsoft SQL Server

The .NET Framework SDK is a free download from the Microsoft website. You go to the Microsoft website, click on download, select “.NET” then search—then pick and download the 100MB (or so) .NET Framework SDK 1.1 package. The SQL Server is a bit of a different matter. Apparently Microsoft (in all their wisdom) wishes to make it relatively difficult for developers to get a copy of their server—so they’re selling it for $49.99 : http://www.microsoft.com/sql/howtobuy/development.asp There is a way around buying SQL Server: Use the school provided server. Another possible way around is to download the “Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)”, which is really just SQL Server, except without any tools. (ie: like MySQL server without the useful ‘mysql’ program to interact with the database). There are many ‘Query’ programs online to use instead, like “SqlBuddy” (search sourceforge.net for it). Next week we’ll use Oracle—which is just a free download.

Download C#, .NET, & SQL Server pdf