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.

30 thoughts on “ADO.NET Data Services

  1. I think that to get the loan from creditors you ought to present a great motivation. But, one time I have got a student loan, just because I wanted to buy a house.

  2. Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with more information? It is extremely helpful for me.

  3. I think this is one of the most vital information for me. And i am glad reading your article. But should remark on some general things, The website style is ideal, the articles is really excellent : D. Good job, cheers….

  4. Where else could I get this kind of information written in such an incite full way? I have a project that I am just now working on, and i am sure this will help me a lot..and I have been looking for such information since from few days….Thanks!!!!!

  5. I am really enjoying reading your well written articles. I think you spend numerous effort and time updating your blog. I have bookmarked it and I am taking a look ahead to reading new articles. Please keep up the good articles!

Leave a Reply

Your email address will not be published. Required fields are marked *