240 likes | 462 Views
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)
E N D
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
Problem Data IS Everywhere But Data != Objects
Why “Data !=Object”? Because Data driven application development was not as common as it is TODAY
“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
“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
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
Problem Data IS Everywhere But Data != Objects
Objects Data !=
Data Storing Types • Flat • Objects • CSV • Excel • Hierarchical • XML • Etc… • Relational • Database • Each requires learning different API
LINQ Prerequisite C# 3.0 Features • Automatic Properties • Implicit Type Variables • Anonymous Types • Lambda Expressions
LINQ Prerequisite C# 3.0 Language Innovations
LINQ to SQL Access data today!
LINQ to SQL Access data with LINQ!
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
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
? Questions Thank You!