[Solved]-Linq to sql issue in C# forms application with .mdf database-LINQ,C#

you need to access the spotlanding member of your object (which by the way, should not also be called spotlanding as that is just confusing).

also you can write your query much more concisely using the overload of count that takes a predicate:

int spot = entrytable.count(x => x.spotlanding);

where spotlanding = true

you're trying to assign a boolean value instead comparing it.

where spotlanding == true

you need to use the == operator instead of =

var spot = (from spotlanding in entrytable
                where spotlanding == true
                select spotlanding).count;