SQL转LINQ[高手进]
select c.customer_id 客户编号,
c.customer_name 客户名称,
c.customer_value 客户价值等级,
c.customer_type 客户类别,
c.customer_state 客户状态,
(select top 1 connect_time
from dbo.business b
where b.connect_time<=getDate()
and b.customer_id=c.customer_id
order by connect_time DESC) 最近跟进时间,
(select top 1 connect_time
from dbo.business b
where b.connect_time>=getDate()
and b.customer_id=c.customer_id
order by connect_time asc) 下次跟进时间,
c.remark 备注
from dbo.customer c
where c.user_id=@id;
[解决办法]
vs2008 存在linq to sql功能
你可以将存储过程映射到**.dbml 文件中，无需任何修改...
使用如下
StandardLMSDataContext db = new StandardLMSDataContext(); //实例化映射文件
db.date(userID);//调用存储过程,data为存储过程名称，userid为输入条件
