Converting SQL to LINQ, Part 2: FROM and SELECT (Bill Horst)

Free People Searches » Converting SQL to LINQ, Part 2: FROM and SELECT (Bill Horst)

Wed, 28 Nov 2007 22:36:37 GMT

PingBack from http://www.absolutely-people-search.info/?p=718

Converting SQL to LINQ, Part 3: DISTINCT, WHERE, ORDER BY and Operators (Bill Horst)

The Visual Basic Team — Tue, 04 Dec 2007 22:14:52 GMT

This post assumes you’ve read the previous posts in this series: Converting SQL to LINQ, Part 1: The

Converting SQL to LINQ, Part 3: DISTINCT, WHERE, ORDER BY and Operators (Bill Horst)

Noticias externas — Tue, 04 Dec 2007 22:23:46 GMT

This post assumes you’ve read the previous posts in this series: Converting SQL to LINQ, Part 1: The

Aprendiendo LINQ para Visual Basic 2008

Jorge Serrano - MVP Visual Developer - Visual Basic — Wed, 05 Dec 2007 09:16:35 GMT

Si quieres aprender LINQ para Visual Basic 2008, quizás te interesen los siguientes artículos que el

Converting SQL to LINQ, Part 4: Functions (Bill Horst)

The Visual Basic Team — Wed, 12 Dec 2007 21:35:55 GMT

This post assumes you’ve read the previous posts in this series: Converting SQL to LINQ, Part 1: The

re: Converting SQL to LINQ, Part 2: FROM and SELECT (Bill Horst)

Lennart — Mon, 17 Dec 2007 16:31:06 GMT

Hi Bill,

One addition: when using an alias, the member name must be preceded by a period. So it must be:

Select .ContactName = Contact.Name, ContactID = Contact.CustomerID

re: Converting SQL to LINQ, Part 2: FROM and SELECT (Bill Horst)

Name (required)* — Tue, 18 Dec 2007 01:43:25 GMT

How do you Select all columns from two tables?

Dim igetanerror = from i in db1, j in db2 Select i, j

re: Converting SQL to LINQ, Part 2: FROM and SELECT (Bill Horst)

VBTeam — Wed, 19 Dec 2007 03:03:29 GMT

Hi Lennart,

Which version of VS are you using? I don't think this period should be necessary.

re: Converting SQL to LINQ, Part 2: FROM and SELECT (Bill Horst)

VBTeam — Wed, 19 Dec 2007 03:05:18 GMT

To the anonymous poster above, what error are you seeing?

Converting SQL to LINQ, Part 5: GROUP BY and HAVING (Bill Horst)

The Visual Basic Team — Wed, 19 Dec 2007 03:09:13 GMT

This post assumes you’ve read the previous posts in this series: Converting SQL to LINQ, Part 1: The

Converting SQL to LINQ, Part 5: GROUP BY and HAVING (Bill Horst)

Noticias externas — Wed, 19 Dec 2007 04:00:39 GMT

This post assumes you’ve read the previous posts in this series: Converting SQL to LINQ, Part 1: The

re: Converting SQL to LINQ, Part 2: FROM and SELECT (Bill Horst)

Name (required)* — Thu, 20 Dec 2007 01:01:21 GMT

Dim iiresult = From ii In db.InventoryItems, il In db.InventoryLogs Select ii, il

GridView2.DataSource = iiresult

GridView2.DataBind()

Server Error in '/' Application.

--------------------------------------------------------------------------------

The data source for GridView with id 'GridView2' did not have any properties or attributes from which to generate columns. Ensure that your data source has content.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: The data source for GridView with id 'GridView2' did not have any properties or attributes from which to generate columns. Ensure that your data source has content.

Source Error:

Line 80:

Line 81: GridView2.DataSource = iiresult

Line 82: GridView2.DataBind()

Line 83:

Line 84:

Aprendiendo LINQ para Visual Basic 2008

El blog de Jorge — Thu, 20 Dec 2007 10:16:38 GMT

Si quieres aprender LINQ para Visual Basic 2008, quizás te interesen los siguientes artículos que el

re: Converting SQL to LINQ, Part 2: FROM and SELECT (Bill Horst)

Name (required)* — Wed, 26 Dec 2007 22:06:33 GMT

How can we do something like this? Do we have to specify all the fields for both tables?

Dim iiresult = From ii In db.InventoryItems, il In db.InventoryLogs Select ii, il

GridView2.DataSource = iiresult

GridView2.DataBind()

Server Error in '/' Application.

--------------------------------------------------------------------------------

The data source for GridView with id 'GridView2' did not have any properties or attributes from which to generate columns. Ensure that your data source has content.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Source Error:

Line 80:

Line 81: GridView2.DataSource = iiresult

Line 82: GridView2.DataBind()

Line 83:

Line 84:

Converting SQL to LINQ, Part 6: Joins (Bill Horst

The Visual Basic Team — Mon, 31 Dec 2007 21:49:09 GMT

This post assumes you’ve read the previous posts in this series: Converting SQL to LINQ, Part 1: The

Converting SQL to LINQ, Part 6: Joins (Bill Horst)

Noticias externas — Mon, 31 Dec 2007 21:57:24 GMT

This post assumes you’ve read the previous posts in this series: Converting SQL to LINQ, Part 1: The

引用:从SQL到LINQ, Part 3: DISTINCT, WHERE, ORDER BY and Operators (Bill Horst)

zack — Fri, 04 Jan 2008 05:42:24 GMT

引用: 从SQL到LINQ,Part3:DISTINCT,WHERE,ORDERBYandOperators(BillHorst) [原文作者]:BillHorst...

引用:从SQL 到 LINQ, Part 2: FROM 和 SELECT(Bill Horst)

zack — Fri, 04 Jan 2008 05:54:35 GMT

引用:从SQL到LINQ,Part2:FROM和SELECT(BillHorst) [原文作者]:BillHorst

[原文链接]:ConvertingSQLtoL...

Converting SQL to LINQ, Part 7: UNION, TOP, Subqueries (Bill Horst)

The Visual Basic Team — Tue, 08 Jan 2008 22:35:48 GMT

This post assumes you’ve read the previous posts in this series: Converting SQL to LINQ, Part 1: The

Converting SQL to LINQ, Part 7: UNION, TOP, Subqueries (Bill Horst)

Noticias externas — Tue, 08 Jan 2008 23:33:48 GMT

This post assumes you’ve read the previous posts in this series: Converting SQL to LINQ, Part 1: The

Translating your T-SQL brain to LINQ

Hot Topics — Mon, 11 Feb 2008 03:14:56 GMT

Bill Horst of the VIsual Basic team at Microsoft has been writing a great series on Converting SQL to

SQL から LINQ への変換、パート 7 : UNION、TOP、サブクエリ (Bill Horst)

The Visual Basic Team — Thu, 29 May 2008 10:46:28 GMT

ここでは、このシリーズの前の投稿をお読みになっていることを前提としています。 Converting SQL to LINQ, Part 1: The Basics ( 英語 ) Converting SQL

re: Converting SQL to LINQ, Part 2: FROM and SELECT (Bill Horst)

Jimbo — Thu, 05 Feb 2009 05:38:57 GMT

This is horrible.

Most people do not use in memory tables, they use "real" SQL tables from a server. How do we reference a table on a server ??????