1 / 11

Welcome

Welcome . Mike DiRenzo , CEO Business Automation Systems, Inc . Cool Coyotes, Inc. Mike@coolcoyotes.com Micha l.direnzo@gmail.com Twitter: @ mike_direnzo Software Architect and Developer with 20 years of experience Published on: CodeProject.com TopXML.com SQLServerCentral.com

marv
Download Presentation

Welcome

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. Welcome • Mike DiRenzo, CEO Business Automation Systems, Inc. Cool Coyotes, Inc. Mike@coolcoyotes.com Michal.direnzo@gmail.com Twitter: @mike_direnzo • Software Architect and Developer with 20 years of experience • Published on: CodeProject.com TopXML.com SQLServerCentral.com • I have been using LINQ for two years.

  2. What is LINQ? • LINQ - Language Integrated Query • Created by Matt Warren of Microsoft 2003 • Query information from: • In memory collections • Database • XML files • WMI • Other • Same capabilities as SQL and more

  3. Why use LINQ? • Why do we need another query language? • Productivity (most cases) • LINQ is Integrated with C# (or VB) • Eliminates the impedance mismatch between programming languages and databases (switch between TSQL and C#) • Provides a single query interface for multiple data sources

  4. Why use LINQ? • Simpler, tidier, higher-level than TSQL • working in a modern language and not having to worry about lower-level details is a big win. • Query Multiple Data Sources • SQL • Objects • XML • WMI • Almost anything • LINQ is easier to master than SQL Select * from customers or Customers.Take(50);

  5. Why use LINQ and not SQL?SQL isn't broken, so why fix it? • SQL is old (1974) and relatively complex

  6. Why use SQL and not LINQ? • When not to use LINQ for querying databases • Hand-tweaked queries (locking hints) Select * from customers (nolock) • Queries that involve selecting into temporary tables and then querying said tables • Predicated updates and bulk inserts • Triggers, stored procedures, and functions (If you still use them!)

  7. Where is LINQ being Used? • Corporate application development • In DotNetNuke development • Modules • http://www.adefwebserver.com/DotNetNukeHELP/Blogs/Linq_FirstLook.htm

  8. Linqpadwww.linqpad.com • A very useful tool for writing: • Scratch applications • Building LINQ Queries • Examining the generated SQL • It is mini Visual Studio C# compiler • Allows App and web config file references • Allows Snippets, third party libraries and/or GAC integration

  9. Linqpadwww.linqpad.com LINQPAD for the Dot Net Framework • LINQ to SQL For Dot Net Framework 3.5 http://www.linqpad.net/GetFile.aspx?LINQPad.exe • Entity Framework For Dot Net Framework 4.0 http://www.linqpad.net/GetFile.aspx?LINQPad4.zip

  10. Useful LINQs • Origin of LNQ http://blogs.msdn.com/b/mattwar/archive/2007/05/31/the-origin-of-linq-to-sql.aspx • Why LINQ? http://www.linqpad.net/WhyLINQBeatsSQL.aspx • Linq Pad http://www.linqpad.com • Linq Kit – Extensions http://www.albahari.com/nutshell/linqkit.aspx • Predicate Builder http://www.albahari.com/nutshell/predicatebuilder.aspx

  11. Useful LINQsMike DiRenzo Articles • XSLT - Search and Replace • XSLT - HTML Image Tag • XSLT- HTML Input Tag • XSLT- Select/Option Tag • XSLT- Date Filtering and Sorting • Dynamic Node Tree Fragment • XML Pivot Table  • Using the Information Schema Views • Yet Another TSQL PAD Utility

More Related