Joining tables in Sterling and Documentation

Mar 11, 2013 at 9:24 PM
I'm completely new to Sterling and my experience is Sybase. I'm considering using Sterling for a Windows Phone project and am wondering about its support for table joins.

So far my requirement is pretty simple. There is a list of items and a list of times. Each item can have one or more times.

Will Sterling be able to perform the join?
What are Sterling's limitations with respect to joins?
Mar 14, 2013 at 8:02 AM
Sterling doesn't really work with tables, but it does support LINQ to Objects. You can read about it here, under 'Complex queries' (at the bottom).

Though in your case, you might want to take a more document-based approach. Just have the item be the aggregate root and let it have a collection of times.

Hope this helps.