Skip to main content

Advanced Search

Projected result for your current search: 0

Search Operators:

You can use operators in your search query to narrow down your results even more. Click on the search operator to see an explanation of how it works.
Finds documents with exactly this word group, in exactly this word order and spelling (e.g. "employer branding").
Finds documents with both search terms (e.g. sales AND bonus).
Finds documents with one or the other search term (e.g. porsche OR volkswagen).
Finds documents with all search terms. Blank space is understood as AND (e.g. man robot production).
Finds documents with no appearance of the word behind NOT (e.g. ford NOT "harrison ford").
Finds documents where the search term is mentioned at least "n" times."n" may be any number (e.g. COUNT(gear)>8).
Finds documents with both search terms in any word order, permitting "n" words as a maximum distance between them. Best choose between 15 and 30 (e.g. NEAR(recruit, professionals, 20)).
Finds documents with the search term in word versions or composites. The asterisk * marks whether you wish them BEFORE, BEHIND, or BEFORE and BEHIND the search term (e.g. lightweight*, *lightweight, *lightweight*).
Finds documents with the search term in different spellings. "?" allows only one character (e.g. organi?ation).
Special characters are understood as AND (e.g. Miller Bros. & Sons).

Semantic Search

powered by (Link opens in a new window)
loading …
Log in
Top

21. Data Access with ADO.NET

  • 2021
  • OriginalPaper
  • Chapter
Published in:
Authors
Andrew Troelsen
Phillip Japikse
Published in
Pro C# 9 with .NET 5
Publisher
Apress

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

The chapter begins by defining ADO.NET as the .NET Core platform's set of namespaces for interacting with relational database systems. It then delves into the role of ADO.NET and the core types and namespaces it offers. The chapter covers the common functionality provided by various data providers and introduces the data provider factory pattern, which allows for building a single code base that can consume various data providers in a declarative manner. Additionally, the chapter explores working with connection objects, command objects, and data readers, and highlights the importance of using parameterized queries to enhance security and performance. The chapter also discusses the benefits and potential drawbacks of the data provider factory model and provides practical examples of how to implement it. Throughout the chapter, the author emphasizes the importance of understanding the common functionality offered by ADO.NET to build flexible and maintainable data access libraries.
AI Generated

This summary of the content was generated with the help of AI.

Please log in to get access to your license.

Log in Register for free

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Business + Economics & Engineering + Technology"

Online-Abonnement

Springer Professional "Business + Economics & Engineering + Technology" gives you access to:

  • more than 102.000 books
  • more than 537 journals

from the following subject areas:

  • Automotive
  • Construction + Real Estate
  • Business IT + Informatics
  • Electrical Engineering + Electronics
  • Energy + Sustainability
  • Finance + Banking
  • Management + Leadership
  • Marketing + Sales
  • Mechanical Engineering + Materials
  • Insurance + Risk


Secure your knowledge advantage now!

inform now

Springer Professional "Engineering + Technology"

Online-Abonnement

Springer Professional "Engineering + Technology" gives you access to:

  • more than 67.000 books
  • more than 390 journals

from the following specialised fileds:

  • Automotive
  • Business IT + Informatics
  • Construction + Real Estate
  • Electrical Engineering + Electronics
  • Energy + Sustainability
  • Mechanical Engineering + Materials





 

Secure your knowledge advantage now!

inform now

Springer Professional "Business + Economics"

Online-Abonnement

Springer Professional "Business + Economics" gives you access to:

  • more than 67.000 books
  • more than 340 journals

from the following specialised fileds:

  • Construction + Real Estate
  • Business IT + Informatics
  • Finance + Banking
  • Management + Leadership
  • Marketing + Sales
  • Insurance + Risk



Secure your knowledge advantage now!

inform now
previous chapter File I/O and Object Serialization
next chapter Introducing Entity Framework Core
Title
Data Access with ADO.NET
Authors
Andrew Troelsen
Phillip Japikse
Copyright Year
2021
Publisher
Apress
Book
Pro C# 9 with .NET 5

Print ISBN: 978-1-4842-6938-1

Electronic ISBN: 978-1-4842-6939-8

Copyright Year: 2021

DOI
https://doi.org/10.1007/978-1-4842-6939-8_21

Premium Partner

    Image Credits
    Neuer Inhalt/© ITandMEDIA, Nagarro GmbH/© Nagarro GmbH, AvePoint Deutschland GmbH/© AvePoint Deutschland GmbH, AFB Gemeinnützige GmbH/© AFB Gemeinnützige GmbH, USU GmbH/© USU GmbH, Ferrari electronic AG/© Ferrari electronic AG