ADO.NET Data Services

As I already explained in a previous post, ADO.NET Data Services are very interesting since they generate a layer on top of our data model in a REST accessible way. Being this technology without any doubt very interesting and very helpful when building our solutions, we don’t always remember the notation that we should use in order to execute actions like:

• Sorting - orderby
• Filtering - filter
• Selection of only a determined set of elements – Top
• Ignore a set of records – Skip
• Make String operations
  • substring
  • endswith
  • startswith
  • length
  • …
• Make Date operations
  • day
  • month
  • year
  • hour
  • minute
  • second
  • …
• Make Math operations
  • round
  • floor
  • ceiling
  • …
• Make Type operations
  • isof
  • cast
  • …

If you’re like me, you never remember the exact notation to use, and for this reason I reminded that it could be interesting to place here a link for the ADO.NET Data Services Datasheet provided by Robert Maclean.

And once again thank Robert for his excellent job into creating this Datasheet that comes so handy.