how do i write the following sql query in Lambda expression

Question

how do i write the following sql query in Lambda expression.

select rating from ratingtable where movieId=@movieid and userid=@userid

Ethan Brown · Accepted Answer · 2012-03-26 23:23:11Z

1

You mean in LINQ? Like this:

var movieId = 3902;  // use valid movie ID
var userId = 5802;   // use valid user ID
ratingtable.Where( x => x.movieId==movieId && x.userid==userId )

answered Mar 26, 2012 at 23:23

Ethan Brown

27.4k5 gold badges84 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ramsey_tm · Accepted Answer · 2012-03-26 23:37:02Z

0

var results = from rt in ratingtable.Where(rt => rt.movieId == movie && rt.userid == user)
select rt

This is a great place to start as well for simple queries: http://code.msdn.microsoft.com/101-LINQ-Samples-3fb9811b

answered Mar 26, 2012 at 23:23

ramsey_tm

7925 silver badges7 bronze badges