E-Book, Englisch, 482 Seiten
Fahad Gilani / Vrat Agarwal / Reid Beginning C# 2008 Databases
1. ed
ISBN: 978-1-4302-0450-3
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark
From Novice to Professional
E-Book, Englisch, 482 Seiten
ISBN: 978-1-4302-0450-3
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark
Assuming only basic knowledge of C# 3.0, Beginning C# 3.0 Databases teaches all the fundamentals of database technology and database programming readers need to quickly become highly proficient database users and application developers. It explains and demonstrates how to create database objects and program against them in both T-SQL and C#. Full of practical, detailed examples, it's been fully revised and updated for C# 3.0 and offers the most complete, detailed, and gentle introduction to database technology for all C# programmers at any level of experience.
Syed Fahad Gilani has more than 15 years of experience in computing. He sold his first program at the age of 10.
Autoren/Hrsg.
Weitere Infos & Material
1;Contents at a Glance;5
2;Contents;6
3;About the Authors;20
4;About the Technical Reviewer;21
5;Acknowledgments;22
6;Introduction;24
6.1;Who This Book Is For;24
6.2;What This Book Covers;24
6.3;How This Book Is Organized;25
6.4;How to Download the Sample Code;25
7;Getting Your Tools;26
7.1;Obtaining Visual Studio 2008;27
7.2;Installing SQL Server Management Studio Express;28
7.3;Installing the Northwind Sample Database;29
7.4;Installing the AdventureWorks Sample Database;34
7.5;Summary;38
8;Getting to Know Your Tools;39
8.1;Microsoft . NET Framework Versions and the Green Bit and Red Bit Assembly Model;39
8.2;Using Microsoft Visual Studio 2008;40
8.3;Using SQL Server Management Studio Express;46
8.4;Summary;50
9;Getting to Know Relational Databases;51
9.1;What Is a Database?;51
9.2;Choosing Between a Spreadsheet and a Database;52
9.3;Why Use a Database?;52
9.4;Benefits of Using a Relational Database Management System;53
9.5;Comparing Desktop and Server RDBMS Systems;53
9.6;The Database Life Cycle;55
9.7;Mapping Cardinalities;56
9.8;Understanding Keys;58
9.9;Understanding Data Integrity;60
9.10;Normalization Concepts;60
9.11;Drawbacks of Normalization;62
9.12;Summary;62
10;Writing Database Queries;63
10.1;Comparing QBE and SQL;64
10.2;Beginning with Queries;65
10.3;Common Table Expressions;66
10.4;GROUP BY Clause;68
10.5;PIVOT Operator;70
10.6;ROW_ NUMBER() Function;72
10.7;PARTITION BY Clause;73
10.8;Pattern Matching;74
10.9;Aggregate Functions;80
10.10;DATETIME Functions;83
10.11;Joins;85
10.12;Summary;96
11;Manipulating Database Data;97
11.1;Retrieving Data;97
11.2;Using SELECT INTO Statements;107
11.3;Inserting Data;112
11.4;Updating Data;115
11.5;Deleting Data;117
11.6;Summary;118
12;Using Stored Procedures;119
12.1;Creating Stored Procedures;119
12.2;Modifying Stored Procedures;127
12.3;Displaying Definitions of Stored Procedures;130
12.4;Renaming Stored Procedures;131
12.5;Working with Stored Procedures in C#;132
12.6;Deleting Stored Procedures;139
12.7;Summary;141
13;Using XML;142
13.1;Defining XML;142
13.2;Why XML?;143
13.3;Benefits of Storing Data As XML;143
13.4;Understanding XML Documents;144
13.5;Understanding the XML Declaration;146
13.6;Converting Relational Data to XML;146
13.7;Using the xml Data Type;153
13.8;Summary;156
14;Understanding Transactions;157
14.1;What Is a Transaction?;157
14.2;When to Use Transactions;158
14.3;Understanding ACID Properties;159
14.4;Transaction Design;160
14.5;Transaction State;160
14.6;Specifying Transaction Boundaries;161
14.7;T- SQL Statements Allowed in a Transaction;161
14.8;Local Transactions in SQL Server 2005;161
14.9;Distributed Transactions in SQL Server 2005;163
14.10;Guidelines to Code Efficient Transactions;164
14.11;How to Code Transactions;165
14.12;Summary;178
15;Getting to Know ADO.NET;179
15.1;Understanding ADO. NET;179
15.2;The Motivation Behind ADO. NET;180
15.3;Moving from ADO to ADO. NET;181
15.4;Understanding ADO. NET Architecture;184
15.5;Working with the SQL Server Data Provider;186
15.6;Working with the OLE DB Data Provider;193
15.7;Working with the ODBC Data Provider;199
15.8;Data Providers Are APIs;209
15.9;Summary;210
16;Making Connections;211
16.1;Introducing the Data Provider Connection Classes;211
16.2;Connecting to SQL Server Express with SqlConnection;212
16.3;Improving Your Use of Connection Objects;221
16.4;Connecting to SQL Server Express with OleDbConnection;227
16.5;Summary;230
17;Executing Commands;231
17.1;Creating a Command;231
17.2;Executing Commands;237
17.3;Executing Commands with Multiple Results;241
17.4;Executing Statements;244
17.5;Command Parameters;249
17.6;Summary;255
18;Using Data Readers;256
18.1;Understanding Data Readers in General;256
18.2;Getting Data About Data;272
18.3;Getting Data About Tables;277
18.4;Using Multiple Result Sets with a Data Reader;280
18.5;Summary;285
19;Using Datasets and Data Adapters;286
19.1;Understanding the Object Model;287
19.2;Working with Datasets and Data Adapters;291
19.3;Propagating Changes to a Data Source;310
19.4;Concurrency;331
19.5;Using Datasets and XML;332
19.6;Using Data Tables Without Datasets;336
19.7;Understanding Typed and Untyped Datasets;339
19.8;Summary;340
20;Building Windows Forms Applications;342
20.1;Understanding Windows Forms;342
20.2;User Interface Design Principles;343
20.3;Best Practices for User Interface Design;343
20.4;Working with Windows Forms;346
20.5;Understanding the Design and Code Views;348
20.6;Sorting Properties in the Properties Window;349
20.7;Setting Properties of Solutions, Projects, and Windows Forms;351
20.8;Working with Controls;352
20.9;Setting Dock and Anchor Properties;356
20.10;Adding a New Form to the Project;361
20.11;Implementing an MDI Form;363
20.12;Summary;368
21;Building ASP.NET Applications;369
21.1;Understanding Web Functionality;369
21.2;Introduction to ASP. NET and Web Pages;371
21.3;Understanding the Visual Studio 2008 Web Site Types;371
21.4;Layout of an ASP. NET Web Site;374
21.5;Using Master Pages;382
21.6;Summary;388
22;Handling Exceptions;389
22.1;Handling ADO. NET Exceptions;389
22.2;Handling Database Exceptions;399
22.3;Summary;410
23;Working with Events;411
23.1;Understanding Events;411
23.2;Properties of Events;412
23.3;Design of Events;412
23.4;Common Events Raised by Controls;413
23.5;Event Generator and Consumer;414
23.6;Summary;422
24;Working with Text and Binary Data;423
24.1;Understanding SQL Server Text and Binary Data Types;423
24.2;Storing Images in a Database;424
24.3;Retrieving Images from a Database;433
24.4;Working with Text Data;439
24.5;Summary;450
25;Using LINQ;451
25.1;Introduction to LINQ;452
25.2;Architecture of LINQ;453
25.3;LINQ Project Structure;455
25.4;Using LINQ to Objects;457
25.5;Using LINQ to SQL;459
25.6;Using LINQ to XML;465
25.7;Summary;467
26;Using ADO.NET 3.5;468
26.1;Understanding ADO. NET 3.5 Entity Framework;468
26.2;Understanding the Entity Data Model;469
26.3;Working with the Entity Data Model;470
26.4;Summary;484
27;Index;485
