Programming Microsoft® ADO.NET 2.0 Core Reference.

Format:

Book

Author/Creator:

Sceppa, David.

Language:

English

Subjects (All):

ActiveX.

Application software--Development.

Database design.

Microsoft .NET Framework.

Object-oriented programming (Computer science).

Database design--Development.

Application software.

Local Subjects:

ActiveX.

Application software--Development.

Database design.

Microsoft .NET Framework.

Object-oriented programming (Computer science).

Physical Description:

1 online resource (0 p.)

Edition:

2nd ed.

Other Title:

ADO.NET

Place of Publication:

Sebastopol : Microsoft Press, 2009.

Language Note:

English

System Details:

text file

Summary:

Build your expertise as you move beyond the basics-and delve into the essential topics of programming with ADO.NET 2.0. This comprehensive reference offers expert guidance, hands-on instruction, and code samples in Microsoft Visual C# and Visual Basic to help advance your mastery of developing database applications for Microsoft Windows and the Web. Discover how to: Work with design-time data access features in Microsoft Visual Studio 2005Use Microsoft .NET Framework 2.0 data providers to connect to databases Build connection strings and enable connec

Contents:

Programming Microsoft® ADO.NET 2.0 Core Reference; Introduction; How This Book Is Organized; System Requirements; Configuring SQL Server 2005 Express Edition; Code Samples; Support for This Book; I. Getting Started with Microsoft ADO.NET 2.0; The ADO.NET Object Model; Why Use Separate Classes and Libraries?; Greater Extensibility; Proliferation; Coverage of .NET Data Providers in This Book; Connected Objects; Connection Class; ConnectionStringBuilder Class; Command Class; DataReader Class; Transaction Class; Parameter Class; DataAdapter Class; Disconnected Classes; DataColumn Class

Constraint ClassDataRow Class; DataSet Class; DataRelation Class; DataView Class; Metadata; Strongly Typed DataSet Classes; Questions That Should Be Asked More Frequently; 2. Building Your First ADO.NET Application with Microsoft Visual Studio 2005; Creating Your Data Access Form Without Code; Add a New Data Source; Connect to Database; Connecting to Other Types of Databases; Saving the Connection String; Select Tables and Columns to Display; What Did the Data Source Configuration Wizard Create?; A New Connection in Server Explorer; A New Data Source

Using the Data Source to Add Items to the FormNavigation Control; Strongly Typed DataSet; BindingSource; TableAdapter; Adding Other Items to the Form; Running the Project; Navigate Through the Available Customers; Modify Data and Submit Changes; Verifying Your Changes Were Submitted; Adding Related Data to the Form; What Was Added?; Re-Run the Project; Modifying Order Information; Examining the Code Generated by Visual Studio; SaveItem Click Event; You Can Write Better Data-Access Code Than the Designers!; SaveItem Click Event; Questions That Should Be Asked More Frequently

II. Getting Connected: Using a .NET Data ProviderOpening SqlConnection Objects; Closing SqlConnection Objects; Cleaning Up After Yourself; Connection Strings; Connecting to a Named Instance; Specifying an Initial Catalog; Connecting Using a Specific User Name and Password; Connecting Using Integrated Security; Introducing Connection String Builders; Connection Strings, Meet IntelliSense; IntelliSense, Meet Connection Strings; Handling Complex Connection String Option Values; Malicious Connection String Input, Also Known as Connection String Injection

Preventing Connection String Injection with Connection String BuildersRecognizing Keyword Aliases; Creating a Connection-String Dialog Box with a Connection-String Builder; Connection String Security; Combining Permissions; Synonyms for Connection String Keywords; Scoping Permissions; Enforcing Connection String Security Through Procedure Attributes; Connection Pooling; What Is Connection Pooling?; How Connection Pooling Can Improve Your Code; Enabling Connection Pooling; When Will My Pooled Connection Be Closed?; Disabling Connection Pooling

Answering Your Own Questions About Connection Pooling

Notes:

Description based upon print version of record.

ISBN:

9780735635678

0735635676

OCLC:

609857046