A lot of times I use COUNT to control certain user interaction and rights manipulation. Below is an example of a running LINQ code that determines the user’s screen using COUNT.
The problem with the above code is that it will not compile in Microsoft Lightswitch. See below.
The solution is to add an EXECUTE clause after the WHERE and before COUNT.
You know what, the solution is simple but it took me a while to figure this out.
If you find this blog helpful, you can make the donation by clicking the Paypal button below.