Browse by Tags

All Tags » Linq2Sql (RSS)
How to implement ISNULL(SUM(ColumnName),0) in Linq2SQL
I had a Linq2Sql statement like this: var q = from o in db.OrderItem where o.UserId == UserId select o.Amount; And then I was trying to get the sum of the OrderItem.Amount column by doing this: total = q.Sum(); This worked fine as long as there were rows...
Posted 20 July 2010 03:36 PM by Jeff Widmer | 7 comment(s)
Filed under: , ,
Linq2Sql: How to join tables on more than one column
You can join two tables in Linq2Sql by using an anonymous type to specify the join.  var r =     from o in db.Orders     join p in db.Products on o.ProductId equals p.ProductId     join pu in db.ProductUsers...
Posted 01 February 2010 10:38 AM by Jeff Widmer | 1 comment(s)
Filed under: , ,
More Posts

Search

Go

This Blog

News

Recommended Blogs

Syndication