1 / 11

Overview

Overview. LINQ – Language INtegrated Query SQL-like syntax in C# statements to work with “queryable” collections and databases System.Data ADO.NET – ActiveX Data Objects (not) for .NET Databinding Binding control values to data in databases, xml, etc. System.IO File I/O & folder management.

paiva
Download Presentation

Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Overview • LINQ – Language INtegrated Query • SQL-like syntax in C# statements to work with “queryable” collections and databases • System.Data • ADO.NET – ActiveX Data Objects (not) for .NET • Databinding • Binding control values to data in databases, xml, etc. • System.IO • File I/O & folder management

  2. LINQ Intro & Resources In a LINQ query, you are always working with objects. You use the same basic coding patterns to query and transform data in XML documents, SQL databases, ADO.NET Datasets, .NET collections, and any other format for which a LINQ provider is available.

  3. LINQ Example with Generics Object intializers (>= 3.0 Framework)

  4. System.Data (ADO.NET) DataReader – connected, read-only,

  5. Npgsql ADO.NET Provider for PostgreSQL Writes the values of the Name column to the console.

  6. System.Data (ADO.NET) DataSet – disconnected, read/write

  7. Database Explorer

  8. ConnectionStrings.com

  9. Databinding – binding controls to data

  10. System.IO The System.IO namespace contains types that allow reading and writing to files and data streams, and types that provide basic file and directory support.

  11. File.Write* / Read*

More Related