Simpledata random ordering
===

A SimpleData issue

I have two tables: Company and products. When I query and get products of all companies meeting a certain criteria, I want to have the results randomly ordered each time they are returned. How do I do that? 

Also,

I would love, (If you can help with this) to have a max number of products per company. So

    Database.Default.Products.All().Where(Database.Default.Products.Companies.Status=3)

Will return all the products, but i only want a max of 3 or each.


