Page 1 :
ADO.NET, UNIT 5
Page 2 :
INTRODUCTION, What is data ?, What is Database?, What is Relational database?, What is RDBMS?, What is SQL?
Page 3 :
INTRODUCTION, What is ADO.NET ?, Its is a part of .Net framework technology that allows us to access and modify data from different data source., It support many types of data source such as Oracle , SQL server…etc, The .Net framework provides a number of data provider that we can use., ADO.NET provide a bridge between the front end and the backend database.
Page 4 :
ASP.NET Data Source Controls
Page 5 :
What is ADO.NET ?, A rich set of classes, interfaces, structures and enumerated types that manage data access from different types of data stores, Features, A robust disconnected model., Integrate XML support. , Data from varied Data Sources , Familiarity to ADO programming model., Enhanced performance
Page 6 :
SQL Managed Provider, SQL ServerDatabase, Managed Provider, ADO.NET Managed Provider, ADO Managed Provider, OLE DB Provider, Database, Your Application
Page 7 :
ADO.NET architecture, Microsoft introduced ADO a data access technology for connecting to the database in 1996., , ADO is an object oriented database access technology that supports both connected and disconnected mode of operation., , You can use ADO.NET to perform CRUD (Create,Read,Update,Delete) operation in your application., , It also provides support for XML data access and it has a rich object model.
Page 8 :
ADO.NET architecture
Page 9 :
ADO.NET architecture, Component, DataSource component
Page 11 :
What is LINQ?, Language Integrated Query (LINQ, pronounced "link")., LINQ is a uniform programming model for querying and manipulating data with a consistent model from any data source., LINQ is just another tool for embedding SQL queries into code., Extends powerful query capabilities to C#, VB.NET languages.
Page 13 :
LINQ Features, Language Integration, Single general purpose Declarative Programming, Standard Query Operators that allow, traversal, filter, and projection operations, Transparency Across Different Type Systems, Query expressions benefit from, rich metadata, compile-time syntax checking, static typing , IntelliSense
Page 14 :
The Syntax, from id in source, join id in source on expr equals expr, let id = expr , where condition , orderby ordering, ordering, … }, select expr | group expr by key, var contacts =, from c in customers, where c.City == "Hove", select new { c.Name, c.Phone };, var contacts =, customers, .Where(c => c.City == "Hove"), .Select(c => new { c.Name, c.Phone });, Query expressions, Lambda expressions, Extension methods
Page 15 :
Query Operators
Page 16 :
LINQ to Objects, It is the use of LINQ queries with any IEnumerable or , IEnumerable(T) collection directly, without the use of an intermediate, LINQ provider or API such as LINQ to SQL or LINQ to XML. , It allows query any enumerable collections such as , List(T),, Array, or , Dictionary(TKey, TValue). , The collection may be user-defined or may be returned by a .NET Framework API.
Page 18 :
LINQ to SQL, Used for managing relational data as objects. , Maps the relational data model to an object model in .NET language. , Translates into SQL the language-integrated queries and sends them to the database for execution. , LINQ to SQL translates the results back to objects that you can work with in your own programming language.
Page 19 :
[Table(Name="Customers")], public class Customer, {, public string CustomerID;, public string City;, }, , // DataContext takes a connection string , DataContext db = new DataContext("c:\\northwind\\northwnd.mdf");, , // Get a typed table to run queries, Table<Customer> Customers = db.GetTable<Customer>();, , // Query for customers from London, var q = from c in Customers, where c.City == "London", select c;, LINQ to SQLAccessing relational data with LINQ
Page 20 :
LINQ to SQL, Allow developers to access database as object in c#., , By using LINQ we are able to use LINQ query operators and methods instead of learning SQL.
Page 21 :
LINQ TO XML - XLINQ, API to work with XML in .NET with the power of LINQ. , XLINQ Features :, It provides an in-memory XML programming interface that leverages, The .NET Language-Integrated Query (LINQ) Framework. , It provides functionality to read, write, and manipulate XML documents., XLinq lets you run SQL like queries on XML documents., It works as cleaner, simpler, smaller and faster XML API