book

Professional C# 5.0 and .NET 4.5.1

by Christian Nagel, Jay Glynn, Morgan Skinner

February 2014

Intermediate to advanced

1560 pages

50h 21m

English

Wrox

Read now

Unlock full access

The Relationship of C# to .NETThe Common Language RuntimeA Closer Look at Intermediate LanguageAssemblies.NET Framework ClassesNamespacesCreating .NET Applications Using C#The Role of C# in the .NET Enterprise ArchitectureSummary
Fundamental C#Your First C# ProgramVariablesPredefined Data TypesFlow ControlEnumerationsNamespacesThe Main() MethodMore on Compiling C# FilesConsole I/OUsing CommentsThe C# Preprocessor DirectivesC# Programming GuidelinesSummary
Creating and Using ClassesClasses and StructsClassesAnonymous TypesStructsWeak ReferencesPartial ClassesStatic ClassesThe Object ClassExtension MethodsSummary
InheritanceTypes of InheritanceImplementation InheritanceModifiersInterfacesSummary
Generics OverviewCreating Generic ClassesGenerics FeaturesGeneric InterfacesGeneric StructsGeneric MethodsSummary
Multiple Objects of the Same and Different TypesSimple ArraysMultidimensional ArraysJagged ArraysArray ClassArrays as ParametersEnumerationsTuplesStructural ComparisonSummary
Operators and CastsOperatorsType SafetyComparing Objects for EqualityOperator OverloadingUser-Defined CastsSummary
Referencing MethodsDelegatesLambda ExpressionsEventsSummary
Examining System.StringRegular ExpressionsSummary

OverviewCollection Interfaces and TypesListsQueuesStacksLinked ListsSorted ListDictionariesSetsObservable CollectionsBit ArraysImmutable CollectionsConcurrent CollectionsPerformanceSummary
LINQ OverviewStandard Query OperatorsParallel LINQExpression TreesLINQ ProvidersSummary
Dynamic Language RuntimeThe Dynamic TypeHosting the DLR ScriptRuntimeDynamicObject and ExpandoObjectSummary
Why Asynchronous Programming Is ImportantAsynchronous PatternsFoundation of Asynchronous ProgrammingError HandlingCancellationSummary
Memory ManagementMemory Management Under the HoodFreeing Unmanaged ResourcesUnsafe CodeSummary
Manipulating and Inspecting Code at RuntimeCustom AttributesUsing ReflectionSummary
IntroductionException ClassesCatching ExceptionsUser-Defined Exception ClassesCaller InformationSummary
Working with Visual Studio 2013Creating a ProjectExploring and Coding a ProjectBuilding a ProjectDebugging Your CodeRefactoring ToolsArchitecture ToolsAnalyzing ApplicationsUnit TestsWindows Store Apps, WCF, WF, and MoreSummary
Deployment as Part of the Application Life CyclePlanning for DeploymentTraditional DeploymentClickOnceWeb DeploymentWindows Store AppsSummary
What are Assemblies?Application DomainsShared AssembliesConfiguring .NET ApplicationsVersioningSharing Assemblies Between Different TechnologiesSummary
Diagnostics OverviewCode ContractsTracingEvent LoggingPerformance MonitoringSummary
OverviewParallel ClassTasksCancellation FrameworkThread PoolsThe Thread ClassThreading IssuesSynchronizationTimersData FlowSummary
IntroductionAuthentication and AuthorizationEncryptionAccess Control to ResourcesCode Access SecurityDistributing Code Using CertificatesSummary
.NET and COMUsing a COM Component from a .NET ClientUsing a .NET Component from a COM ClientPlatform InvokeSummary
File and the RegistryManaging the File SystemMoving, Copying, and Deleting FilesReading and Writing to FilesMapped Memory FilesReading Drive InformationFile SecurityReading and Writing to the RegistryReading and Writing to Isolated StorageSummary
IntroductionOverviewDatabase and Entity ClassesTraditional TransactionsSystem.TransactionsDependent TransactionsIsolation LevelCustom Resource ManagersFile System TransactionsSummary
NetworkingThe HttpClient ClassDisplaying Output as an HTML PageUtility ClassesLower-Level ProtocolsSummary
What Is a Windows Service?Windows Services ArchitectureCreating a Windows Service ProgramMonitoring and Controlling Windows ServicesTroubleshooting and Event LoggingSummary
Global MarketsNamespace System.GlobalizationResourcesWindows Forms Localization Using Visual StudioLocalization with ASP.NET Web FormsLocalization with WPFA Custom Resource ReaderCreating Custom CulturesLocalization with Windows Store AppsSummary
Uses of XAMLXAML FoundationDependency PropertiesBubbling and Tunneling EventsAttached PropertiesMarkup ExtensionsReading and Writing XAMLSummary
IntroductionMEF ArchitectureDefining ContractsExporting PartsImporting PartsContainers and Export ProvidersCatalogsSummary
OverviewWindows Runtime ComponentsWindows Store AppsThe Life Cycle of ApplicationsApplication SettingsSummary
ADO.NET OverviewUsing Database ConnectionsCommandsFast Data Access: The Data ReaderAsynchronous Data Access: Using Task and AwaitManaging Data and Relationships: The DataSet ClassXML Schemas: Generating Code with XSDPopulating a DataSetPersisting DataSet ChangesWorking with ADO.NETSummary
Programming with the Entity FrameworkEntity Framework MappingEntitiesData ContextRelationshipsQuerying DataWriting Data to the DatabaseUsing the Code First Programming ModelSummary
XMLXML Standards Support in .NETIntroducing the System.Xml NamespaceUsing System.Xml ClassesReading and Writing Streamed XMLUsing the DOM in .NETUsing XPathNavigatorsXML and ADO.NETSerializing Objects in XMLLINQ to XML and .NETWorking with Different XML ObjectsUsing LINQ to Query XML DocumentsMore Query Techniques for XML DocumentsSummary
Understanding WPFShapesGeometryTransformationBrushesControlsLayoutStyles and ResourcesTriggersTemplatesAnimationsVisual State Manager3-DSummary
IntroductionMenu and Ribbon ControlsCommandingData BindingTreeViewDataGridSummary
IntroductionText ElementsFlow DocumentsFixed DocumentsXPS DocumentsPrintingSummary
OverviewMicrosoft Modern DesignSample Application Core FunctionalityApp BarsLaunching and NavigationLayout ChangesStoragePickersLive TilesSummary
OverviewSearchingSharing ContractCameraGeolocationSensorsSummary
.NET Frameworks for Web ApplicationsWeb TechnologiesHosting and ConfigurationHandlers and ModulesGlobal Application ClassRequest and ResponseState ManagementASP.NET Identity SystemSummary
OverviewASPX Page ModelMaster PagesNavigationValidating User InputAccessing DataSecurityAjaxSummary
ASP.NET MVC OverviewDefining RoutesCreating ControllersCreating ViewsSubmitting Data from the ClientHTML HelpersCreating a Data-Driven ApplicationAction FiltersAuthentication and AuthorizationSummary
WCF OverviewCreating a Simple Service and ClientContractsService BehaviorsBindingHostingClientsDuplex CommunicationRoutingSummary
OverviewCreating ServicesCreating a .NET ClientWeb API Routing and ActionsUsing ODataSecurity with the Web APISelf-HostingSummary
A Workflow OverviewHello WorldActivitiesCustom ActivitiesWorkflowsSummary
Peer-to-Peer Networking OverviewPeer Name Resolution Protocol (PNRP)Building P2P ApplicationsSummary
OverviewMessage Queuing ProductsMessage Queuing ArchitectureMessage Queuing Administrative ToolsProgramming Message QueuingCourse Order ApplicationReceiving ResultsTransactional QueuesMessage Queuing with WCFMessage Queue InstallationSummary

Content preview from Professional C# 5.0 and .NET 4.5.1

Chapter 32Core ADO.NET

WHAT’S IN THIS CHAPTER?

Connecting to the database
Executing commands
Calling stored procedures
The ADO.NET object model
Using XML and XML schemas

WROX.COM CODE DOWNLOADS FOR THIS CHAPTER

The wrox.com code downloads for this chapter are found at www.wrox.com/go/procsharp on the Download Code tab. The code for this chapter is divided into the following major examples:

ExecutingCommands
StoredProcs
DataReader
IndexerTesting
AsyncDataReaders
SimpleDataset
ManufacturedDataset
DataAdapter
DataAdapterUpdate
Auditing

ADO.NET OVERVIEW

This chapter discusses how to access data from your C# programs using ADO.NET. It shows you how to use the SqlConnection and OleDbConnection classes to connect to and disconnect from the database. You learn the various command object options and see how commands can be used for each of the options presented by the Sql and OleDB classes; how to call stored procedures with command objects; and how the results of those stored procedures can be integrated into the data cached on the client.

The ADO.NET object model is significantly different from the objects available with ADO. This chapter covers the DataSet, DataTable, DataRow, and DataColumn classes as well as the relationships between tables and constraints that are part of DataSet. The class hierarchy has changed significantly since the release of the .NET Framework 2.0, and some of these changes are also described. Finally, you examine the XML framework on which ADO.NET is ...