Jason N. Gaylord's Blog

# re: Confusion about .NET 2.0/3.0, Orcas, Linq, Atlas, etc

Your link is broken.

# re: Confusion about .NET 2.0/3.0, Orcas, Linq, Atlas, etc

NorthWindDataContext db = new NorthWindDataContext();

           db.Log = Console.Out;

           var q =

               from s in db.Suppliers

               join c in db.Customers on s.City equals c.City into scusts

               select new

               {

                   s.CompanyName, s.ContactName,

                   scusts,

               };

           foreach (var cp in q)

           {

               Console.WriteLine("Example 8B Supplier Name {0} , Customer Name {1}, City {2} ",

                   cp.CompanyName, cp.ContactName, cp.scusts.Count());

           }

The above example returned to many columns. I expected only display 3 columns would be shown

---------

SELECT [t0].[CompanyName], [t0].[ContactName], [t1].[CustomerID],

[t1].[CompanyName] AS [CompanyName2], [t1].[ContactName] AS [ContactName2],

[t1].[ContactTitle], [t1].[Address], [t1].[City], [t1].[Region], [t1].[PostalCode], [t1].[Country], [t1].[Phone], [t1].[Fax], (

   SELECT COUNT(*)

   FROM [dbo].[Customers] AS [t2]

   WHERE [t0].[City] = [t2].[City]

   ) AS [value]

FROM [dbo].[Suppliers] AS [t0]

LEFT OUTER JOIN [dbo].[Customers] AS [t1] ON [t0].[City] = [t1].[City]

ORDER BY [t0].[SupplierID], [t1].[CustomerID]

# re: Confusion about .NET 2.0/3.0, Orcas, Linq, Atlas, etc

Hey. Cheerfulness, it would appear, is a matter which depends fully as much on the state of things within, as on the state of things without and around us. Help me! Could you help me find sites on the: Inderal la high glucose. I found only this - <a href="www.w2p.org/.../Inderal">how long does inderal last</a>. Inderal, i was based normal researchers. Inderal, what holiday should be sprayed with understanding concerns? THX ;-), Blythe from Dominican.