Entity framework - ObjectQuery return int property and assign it to variable

Question

Hi, I need to get UserCarId(int) from this query and assign to int type variable.

 int UserCarId;


 Entities ctx = new Entities();
                var query = from enq in ctx.UserCars.Include("aspnet_Users")
                            where enq.aspnet_Users.UserId == currentUserId
                            select enq.UserCarId ;
                UserCarId = query;

Answer 1

If you want to get a single record use the FirstOrDefault method

UserCarId = query.FirstOrDefault();

In the case of int the default value is 0, so if no record is found then 0 will be returned.