David Overton's Blog and Discussion Site
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small. I specialise in Windows Intune and SBS 2008.
This blog is purely the personal opinions of David Overton. If you can't find the information you were looking for e-mail me at admin@davidoverton.com.

To find out more about my Windows Intune BOOK - Microsoft Windows Intune 2.0: Quickstart Administration click here

To find out more about my SBS 2008 BOOK - Small Business Server 2008, Installation, Migration and Configuration click here

Want to make life easier developing databases apps against SQL, XML and other databases (Oracle, MySQL, PostgreSQL) - look at the Beginning LINQ development articles
David Overton's Blog

Buy my books

Windows Intune:Quickstart Administration


This is the RAW book (Read as Written).
Click here for more information
Buy or pre-order today

SBS 2008 - Installation, Migration and Configuration

Small Business Server 2008 – Installation, Migration, and Configuration

Buy today in book or e-book form

Request a Review Copy

Twitter

Syndication

LINQ looks like another amazingly simple move for app developers (I've written a few DB apps myself over the years).  While Microsoft provides support for Objects, SQL and XML, others provide for other platforms such as Oracle, MySQL and PostgreSQL (http://code2code.net/DB_Linq/).  The reason why it is so nice is because the gap between the process of writing SQL queries and then programming them into your code is considerably removed.  For example, a query might now look like:

var q = from p in db.Products            
         where p.ProductName == "Pen"
         select p.ProductID;        

I think that looks very much like a SQL query, which is really good for developers and database peeps alike, especially since the underlying execution is very efficient. To make understanding all this easier there has been a number of articles written including...

Beginning LINQ development, Part 1


Brian Eastwood, Site Editor

The Language Integrated Query, or LINQ, is one of the most important of the new features afoot in VB 9.0 and C# 3.0.Developers can use LINQ to query to data sources like ADO.NET, SQL and XML. The idea, of course, is that data queries are now an integrated part of Visual Basic and C# and an immeasurable improvement over data integration in the days of preprocessors.

LINQ first emerged at PDC 2005, and though it is intended for the next version of Visual Studio, code-named "Orcas," LINQ is available for use with Visual Studio 2005.

A good starting point for learning more about LINQ is Hooked on LINQ, a wiki for anyone interested in dipping his toe in the water. Among the site's resources are "five-minute overviews" of using LINQ with objects, SQL and XML.

For more on LINQ-to-SQL queries, which were previously called DLINQ queries, check out the Scott Guthrie post Understanding LINQ to SQL Query Translations. (Guthrie is the head of ASP.NET development at Microsoft.) Here you can find hints for working with stored procedures, Where clauses and mathematics functions.

Beginning LINQ development, Part 1

and

 

Beginning LINQ development, Part 2
LINQ, the Language Integrated Query, dramatically changes database programming in Visual Studio 2008. Here we examine the ins and outs of LINQ to SQL queries.

Beginning LINQ development, Part 3
LINQ works well for managed code and for RAD, but the language enhancements it brings to the .NET Framework should be considered carefully.

Visual Studio 2008 Learning Guide: LINQ
This section of the Visual Studio 2008 Learning Guide looks at LINQ, which is arguably the most important new feature of VS 2008.

 

ttfn

David


Posted Fri, Jan 18 2008 6:03 PM by David Overton

Comments

Geek Lectures - Things geeks should know about » Blog Archive » Want to make life easier developing databases apps against SQL, XML and other databases (Oracle, MySQL, PostgreSQL) - look at the Beginning LINQ development articles wrote Geek Lectures - Things geeks should know about » Blog Archive » Want to make life easier developing databases apps against SQL, XML and other databases (Oracle, MySQL, PostgreSQL) - look at the Beginning LINQ development articles
on Fri, Jan 18 2008 6:57 PM

Pingback from  Geek Lectures - Things geeks should know about » Blog Archive   »  Want to make life easier developing databases apps against SQL, XML and other databases (Oracle, MySQL, PostgreSQL) - look at the Beginning LINQ development articles

Add a Comment

(optional)  
(optional)
(required)  
Remember Me?

(c)David Overton 2006-13