Inner Join表连接

首先是建表语句

USE [LinqSqlDemo]
GO

/****** Object:  Table [dbo].[Classx]    Script Date: 10/27/2018 10:26:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Classx](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL,
	[AddTime] [datetime] NULL,
	[Status] [bit] NULL,
 CONSTRAINT [PK_Classx] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[Student](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[ClassID] [int] NULL,
	[AddTime] [datetime] NULL,
	[Status] [bit] NULL,
 CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[Product](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[Price] [int] NOT NULL,
	[Sid] [int] NOT NULL,
 CONSTRAINT [PK__Product__3214EC070519C6AF] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GOCode language: PHP (php)

我们现在要统计的东西，列出下面的东西：

张三 沙发999,跑步机 888

李四 衣服999,跑步机 888，健身车 666

class Program
{
    static void Main(string[] args)
    {
        using (var db = new DataClasses1DataContext())
        {
            var query = from s in db.Student
                        join p in db.Product
                        on s.ID equals p.Sid
                        select new { ID = s.ID, Name = s.Name, ProductName = p.Name, Price = p.Price };
            var result = query.ToArray();
        }
    }
}Code language: JavaScript (javascript)