Build Your Own ASP.NET 4 Web Site Using C# & VB, 4th Edition

Chapter 8Speaking SQL

So your database has been created, and you’ve defined all the tables you’ll need, and all the columns for your tables—you’ve even defined the relationships between your tables. The question now is, “How will you get to that data?” Sure, you can open the database, look at the data contained in the tables, and manually insert and delete records, but that does little to help your web users interact with that data. Mary in Accounting isn’t going to want to download and learn to use SQL Server Management Studio just so she can retrieve an employee’s mobile phone number—this functionality has to be provided by the Dorknozzle intranet website, which, after all, is supposed to enable staff members to access data easily. In fact, ...