Random

[bricelam]

Allow using the random() and randomblob() functions in LINQ. They don't quite align to .NET's Random class an probably need new functions on EF.Functions with client-side implementations.

Consider adding this to the actual provider.

[bricelam]

Evaluating these functions server-side seems to have no value that I can see. Closing as won't fix, but if you have a scenario for this, I'd love to hear it.

[bricelam]

These can be useful for sampling data:

var sample = db.Data.OrderBy(_ => EF.Functions.Random()).Take(100);

[bricelam]

With some bit twiddling, the random function can probaly used to translate members of the Random class.

[bricelam]

To get a more standard range...

SELECT abs(random() / 9223372036854775807.0);