| More

Recent News » SQL

LINQ Query Syntax C# vs. VB vs. SQL

Posted by: Paul Litwins Blog, on 09 Jun 2008 | View original | Bookmarked: 0 time(s)

FWIW, I found it helpful to create this table to compare the query syntax of C# and VB and how it translates into SQL. C# LINQVB LINQANSI SQLfromFromFROMselectSelectSELECTwhereWhereWHEREorderbyOrder ByORDER BYjoinJoinJOINgroupGroup ByGROUP BYDistinct()DistinctDISTINCTintoIntoINTOletLetASCount(), Sum(),…AggregateCOUNT, SUM,… with no groupSkip()Skipn/aSkipWhile()Skip Whilen/aTake()Taken/aTakeWhile()Take Whilen/aShare this post: email it! | bookmark it! | digg it! | reddit! | kick...

Advertisement

Free Agile Project Management Tool from Telerik TeamPulse Community Edition helps your team effectively capture requirements, manage project plans, assign and track work, and most importantly, be continually connected with each other.

Category: SQL | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 1279 | Hits: 108

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD