首先创建 数据库(sql)
create database Lent
go
use lent
go
create table a
(
id int identity(1,1) primary key,
name varchar(50)
)
go
create table b
(
id int identity(1,1) primary key,
name varchar(50)
)
查询语法
var len = new LentEntities();
var a = (from aa in len.a
join bb in len.b on aa.id equals bb.id
select new
{
aa.id,
bb.name
}).ToList();
MessageBox.Show(a.Count.ToString());