Monthly Archives: March 2009

>Query keywords – orderby

> orderby: Is used for sorting the records. In comprehension syntax it is just like we use it in SQL. i.e: from c in Customers orderby c.Country, c.CompanyName descending select c Here we are ordering by Country (default ascending) and … Continue reading

Posted in Uncategorized | Leave a comment

>Query keywords – group and into

> group (… by ): Is used for grouping the results based on a key. The key can be a plain or composite key. In Linq, the result of grouping is a List of Lists. You can think of it … Continue reading

Posted in Uncategorized | Leave a comment

>Query keywords – select

> Before starting "select" I would like to list where to find LinqPad, SQL express, sample Northwind database, VC# express. To follow you need LinqPad (VS or VC# express IDE would do too, but I repeat LinqPad is a cool … Continue reading

Posted in Uncategorized | Leave a comment

>Query keywords – where

> where: Just like in SQL “where” is used to filter the query results. Though not supported by all flavors (like Linq to SQL doesn’t support) if method syntax is used, then you can also filter on based on position … Continue reading

Posted in Uncategorized | Leave a comment

>Query keywords – from

> <!– /* Font Definitions */ @font-face {font-family:”Cambria Math”; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:162; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;}@font-face {font-family:calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:162; … Continue reading

Posted in Uncategorized | Leave a comment

>Query or method syntax

> There are a series of “Query Keywords” which most of them should be familiar to any VFP developer. They are very similar to the SQL clauses we are familiar with and results they provide are more or less similar. … Continue reading

Posted in Uncategorized | Leave a comment