如何从两个表中获取最后两条更新记录 [英] How to get last two updated record from two table
本文介绍了如何从两个表中获取最后两条更新记录的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
这里我显示两个表table-1和2现在我想要来自Table-1的ID 3数据和来自table-2的ID-4数据意味着日期明确地在实体框架工作ID中的最后两个更新数据和seqNum colum的数据类型是很长。
表-1
ID日期
1 21/10/2016
2 22/10/2016
3 24/10/2016
表-2
seqNum LCdate
1 21/10/2016
2 22/10/2016
3 23/10/2016
4 25/10/2016
我的尝试:
(来自的 db.Table-1
select new
{
s.ID,
seqNum = 0 ,
LCdate = s.date
}
.Concat(来自 s in db.Table-2
选择 new
{
ID = 0 ,
s.seqNum,
s.LCdate
});
解决方案
var result =(来自a />
(来自于db.Table-1中的s
选择新的
{
s.ID ,
seqNum = 0,
LCdate = s.date
}
.Concat(来自s in db .Table-2
选择新的
{
ID = 0,
s.seqNum,>
s.LCdate
})
orderby a.LCdate descending
选择a).Take(2);
Here i show two table table-1 and 2 now i want ID 3 data from Table-1 and ID-4 data from table-2 means date wise last two updated data in entity frame work ID and seqNum colum's data type is long.
Table-1
ID date
1 21/10/2016
2 22/10/2016
3 24/10/2016
Table-2
seqNum LCdate
1 21/10/2016
2 22/10/2016
3 23/10/2016
4 25/10/2016
What I have tried:
(from s in db.Table-1
select new
{
s.ID ,
seqNum= 0,
LCdate=s.date
}
.Concat(from s in db.Table-2
select new
{
ID=0 ,
s.seqNum,
s.LCdate
});
解决方案
var result = (from a in
(from s in db.Table-1
select new
{
s.ID ,
seqNum= 0,
LCdate=s.date
}
.Concat (from s in db.Table-2
select new
{
ID=0 ,
s.seqNum,
s.LCdate
})
orderby a.LCdate descending
select a).Take(2);
这篇关于如何从两个表中获取最后两条更新记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文