!
http://www.softcomplex.com/products/tigra_calendar/
!
!
2009/11/24
2009/11/05
LINQ Retrieve Last Records
var GenerateCodeList = (from a in dc.allProductInfos
join b in dc.Processors on new {id = a.id} equals new {id = b.id} into b_join
from b in b_join.DefaultIfEmpty()
where a.id.Contains("QRT%")
orderby a.MRTP_id descending
select new ProductItem
{
ProductCode = a.id,
MST = b.mst,
CPC = b.cpc_cd,
GroupId = a.prd_grp_id,
GroupName = a.prd_grp_txt,
Requestor = b.user,
DateCreated = b.change_date
}).Take(20).ToList();
!
join b in dc.Processors on new {id = a.id} equals new {id = b.id} into b_join
from b in b_join.DefaultIfEmpty()
where a.id.Contains("QRT%")
orderby a.MRTP_id descending
select new ProductItem
{
ProductCode = a.id,
MST = b.mst,
CPC = b.cpc_cd,
GroupId = a.prd_grp_id,
GroupName = a.prd_grp_txt,
Requestor = b.user,
DateCreated = b.change_date
}).Take(20).ToList();
!
Subscribe to:
Posts (Atom)
Labels
- .Net (1)
- AES (1)
- c# (8)
- cmd (3)
- Database Script (1)
- DES (1)
- dll (3)
- Error (1)
- Event Viewer (1)
- File Operation (1)
- FireFox (1)
- Gmail (1)
- HashMap (1)
- HashTable (1)
- HeidiSQL (1)
- HMAC (1)
- ip (1)
- Java (2)
- Java Bean (1)
- Javascript (1)
- LINQ (1)
- Marshall Class (4)
- MD5 (1)
- Microsoft System Configuration Utility (1)
- MVC (1)
- MySQL (3)
- Opera (1)
- PRNG (1)
- Regedit (1)
- Run Command (3)
- SHA (1)
- String Operation (1)
- struct (1)
- Stylish (1)
- Technical Interview Questions (1)
- Unmanaged Memory Operation (3)
- Virtual Machine (1)
- Visual Studio 2005 (2)
- Warning (1)
- Web Application (3)