1 / 21

LINQ

LINQ. Presented By : SHAIKH SHARYAR JAVED Software Engineer (Daedalus Software Inc.) Technology Teacher (AUC Technologies) MCP(Microsoft Certified Professional) MCTS(Microsoft Certified Technology Specialist) MCPD(Microsoft Certified Professional Developer)

borka
Download Presentation

LINQ

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. LINQ Presented By : SHAIKH SHARYAR JAVEDSoftware Engineer (Daedalus Software Inc.)Technology Teacher (AUC Technologies) MCP(Microsoft Certified Professional) MCTS(Microsoft Certified Technology Specialist) MCPD(Microsoft Certified Professional Developer) http://www.sharyarjaved.blogspot.com

  2. Problem Data IS Everywhere But Data != Objects

  3. Why “Data !=Object”? Because Data driven application development was not as common as it is TODAY

  4. “Data !=Object” -History • Traditionally, programming language were mostly used for applications like: • Operating Systems / Compilers / System Softwares • Word Processors / Spreadsheets • Games / Browsers / Email clients / Chat Easily Managed Files Single User Limited Data

  5. “Data !=Object” -History • For Data driven application, we used DBMS tools like: • Dbase • FoxPro • Access • Oracle etc. Own Languages like SQL, PL/SQL etc. Only for Data Oriented Task

  6. Today’s World • E-Commerce Sites • Social Media. • Facebook, MySpace • Blogs, Twitter etc • Online Forums • … Targeted to millions of users Use of Database is Must! Tons of Data

  7. Problem Data IS Everywhere But Data != Objects

  8. Objects Data !=

  9. Data Storing Types • Flat • Objects • CSV • Excel • Hierarchical • XML • Etc… • Relational • Database • Each requires learning different API

  10. Relational Data with ADO.Net

  11. Manipulating data with Objects

  12. The LINQ Project

  13. LINQ Prerequisite C# 3.0 Features • Automatic Properties • Implicit Type Variables • Anonymous Types • Lambda Expressions

  14. LINQ Prerequisite C# 3.0 Language Innovations

  15. Deferred Query Execution

  16. LINQ to SQL Access data today!

  17. LINQ to SQL Access data with LINQ!

  18. LINQ to SQL • Language integrated data access • Maps tables and rows to classes and objects • Builds on ADO.NET and .NET Transactions • Mapping • Encoded in attributes or external XML file • Relationships map to properties • Persistence • Updates through SQL or stored procedures

  19. LINQ Architecture

  20. LINQ Components • Language Integrated Query for .NET • Native query syntax in C# 3.0 and VB 9.0 • LINQ to Objects • SQL-like queries for any .NET collection • LINQ to SQL • Query enabled data access framework • LINQ to XML • Query enabled, smaller, faster XML DOM

  21. ? Questions Thank You!

More Related