Answered Querying Entities by a date field.

  • Thursday, November 27, 2008 10:45 PM
     
     
    Hi guys,

    I have stored some entities and they have a DateTime field,

    ent.Properties[ImageDate] = myObj.ImageDate // this is a DateTime field.

    I would like to query them for enties that have a specific date I can't seem to figure out the format of the query that I need to use, any idea's?

    I have tried this (and a couple format variations)

    string qry = string.Format(@"from e in entities where e[""ImageDate""] == {0} select e",dlg.SelectedDate.ToString());

All Replies

  • Thursday, November 27, 2008 11:39 PM
     
     
    tjarvis:

    i use the REST interface and this works for me when querying against a dateTime field in SDS:
    from e in entities where e["date-created"]>"2008-10-01T10:00:00" select e

    Note that i'm looking for items created after Oct 10, 2008 10AM or later.

    Hope this helps.


    Mike Amundsen [http://amundsen.com/blog/]
  • Friday, November 28, 2008 12:29 AM
     
     
     Here is the rest packet for one of the entities

    - <Comic xmlns:s="http://schemas.microsoft.com/sitka/2008/03/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:x="http://www.w3.org/2001/XMLSchema">
      <s:Id>29</s:Id>
      <s:Version>350459</s:Version>
      <ComicDate xsi:type="x:dateTime">2008-01-29T00:00:00</ComicDate>
      <Data xsi:type="x:string">R0lGODlhWAK7APIAAHNzc56env///8LCwgEBAUVFRR8fH+Li4iwAAAAAWAK7AAAD/0i63P4wykmrvTjrTYz4YAhyZGmeaKoyh+gKxirPdG3feK7vmfeKvKBwOGuJAr5PjMhsOiuGqHRKrVqv2Kx2y+16v+CwV5H8fRbitHrNbrvf1YXx0zoMQku4fs/v+68MZWaDhIWGh4iJiouMjT8AHYYKBY6VlpeYmZqLAQpzBwQHAAB4kZunqKmqq51oq6+wsbKEkII/k7O5urubkKEgAJSgpba8xsfIIa1kyc3OyLUiosFzuM/X2LC+c50DAGUxxdnj5JyB5ejpi9F4BaPVBJTq8/SPniED7iLh9f31y6b8CUzHDlgAAXMEMBvIkNy2EMH0geDXsKIzgOIsasxV8P+DLwJ3zsTbSNLYQ48GRh2cGLCky1cYX8rU1lJAgZAhrM3ceeqkgADy9tXkSbRRzKJIK3W0aaBAAXhBk0pN5HNZVIpTsxI6qrWrmaUBRgGAl9FrV58ID6glZrYtCK5u2y79CQCnwpFx3Z7Mg1fJ0LxS4QLWuvQbJJw6BxO+9zOAY8dsFWcVLDnpUgMtgo3oW1kq2h9YOxelLJrn0gIpQW4uW9rl5w8D5oRuPZM07Zdzg9lNfHvmaySk/LLu3dA28Y1gSUXlfbykzzthhQ5v7s849YaXD6bcHPU6csZOB3QILtw7SeuM1K5FOCjhD/Xw3buXlj7Eejou5s83tB/V6br/24k0nXn07GUTKeD85UI3IdwETHfiiSDeA3U1QMk3CT0FwoQL2IUQASt9EJ19BoR4BnkIYQaCUy/4oqIAHymYC3qJLCGHQgehJo1qZkRg0zkR7oOiC5opQwAwZBjRlH08jhDVAGWAuE93qix1QAwoMkcgQyeBBFKQ5RVyUifkibecIPk0pYBYAYgSgzs5BgQJeQV04M5YO0r54ZFG8rlZiOKtBEqTHsWDBJ9kqNQMjYiEheVKkDC1o4ciBBNMPGIp1JSiYE5EpZFBgSJPne4ooEQZ4nmoUww41YlToLLMRQdUW373y08j6RkmLTcuAKqIhFbqZ050MjOon0W+t0Cc/7rCQGpOCqwEK6514qPrSiViwyhVw8IoKZOU3pKliQJ0qsSnv/4IG4+iwoBqsB2M5EtUda7E2Suy2oTYvbUONGZa7s32iAETRjEtsJTwC9GtOSUBZ7wFMPhTWaBcGY+XUQ6Q6kRRqDbtdn0tSSS6xmyLSKQu6MgkucqiKPKGwUZRSCcJr1TtW0fKDLOqYcULFMM/DtBJf/4FZIfGQkM7YL/ldAnjkDDIuPCeB93bSQy8UqqzTZS00gJeoIhFacVRX3hrkFs3NeiJZ0DHo57e1IWrWEYc4BgAdztGdCYmHzI0kbY0a0a7SGbatggqb7WQQkOGkni58B4UzcEf1Klwlf8Bccgqd+kdrfHgLoSLdH5qxUafNKPbRzrqn0tTet1Ip66e6fjQXm7ssr++ocZ7H2Ig3i4I/MLN+RTqHplZp+ynyEBVzuegBod+q4Nho6QxJNh6IJ4HBJCSqtB46enK1S9DaQXLp/RtiMRTAwH1C4QXGkVQgt88s66Cg/SNtXaBYrO9VMIaR/6iqssRwkbRegHlNtYgBoQIILpCGcwYEBLK4UgoNyqUA6PWAFF0kA6W6x6uHuCYD1rIEl3Kw1WkhiTpUUpwRAoWjPz0uHWFRIYgAMULfRAjU6hsTiKEIJ9ehivIaescm2CgkVwgwkLEr4hAIJcEC9GkZonHbsPqBBP/oWa/Fg5QEEhADa0WYTdXhWuGw1JioTQmwBmOgncsiUo3hLa5oK2oW+7SWEDqhLfWHa0pn4tCH/c1lsPYbRQGE9oB+BiA1nXveizk1a3sUDq7CC+GL+AXDIVFKS1WrhjhO+OHKIWyJuLqDhKc17c+RIrDcMyI11CfJFhmLoWQjEko8iSxhIWIJkECHqxcV+CgpsYZ6uIyd5DIXZa2IKC5r3zBkiCPdEmiTjxwWG10VTD34QMw7Q80dKKSK/GDhzJ8c5frep/vGBOWN0rHEL9U3hZ5ZaJFhsMDXWTJGW6SuhzCcGOEwlo8nZewqKAMS9/wGIhilwxZDuJSHTDR9uZX/7V4zK8/oHgX3h5zF9SwqBYeRd8IQjSoUSggJLVYwnwUdq8pxuI/B9PSIYoJM8iFxH+8PBzk5oMEda3rE7piVT4/SQc/UXNKXszJLbcGRTygyKXcmp4UTBm16YiiRXjM1iDU2AqPlut9KAshY4ChHxANY4mLzFDNrGWEEFbwhMhwaI8sSjASxWskqKGgGQIEGwRSIq++ghID1KmE/lmurkgC5Asgk7Ih9fSL0hAktG5JCJqixHkjPcKXutiBKIQoQE1UI1Uth77DmA9mUiAXi4QZPcYNoo2Qk4KSnuTMk43Vn5HxSu9WsVtYyJVpzpgL0saYnk26KxgxsJdjkXiGlP/Irbkm9VOzmKopeywgVOPBU/s+dCcjUDV4acQUncqgw0achJJuyi1w+/Hb9UKjJqhp7TIr8d0RNMUpAvzu3642giGJyil8PANJv1tDnBWKfh6KmDGL6p6hloJJDTZnbdc5PTIgdlfupUd7M8yL7LSTc46Ix3yu6M+qYWY9JI6tEpbbvtDedpWaxZk88tdKP5XXWhpKrz796aF4epCyD33xCy7J4XFsuMiQVYZTqmjAAzKgOy7FGgJDoUTxIKizUVjksNrlAJY5+JRIqugUfuSr1cwPWMyNGhCw3DUH9Na6uyUy4CqFj/h2oAUOyqGGDmsjKE9VT4cy7gjJ842OeS//DzZqE6KXZb4l5Ei13FjTMWiUUEczhQw4QULHXvS0wW16JIJ1RZ0jG5JDBSVZlZPiAoKTV75u6E1106qIABUOa4RaHva0tFIUlBCZimmjjZQQuZLWTsNpV0TQEcs7kqaMgxT7ucJ+z7F/0oJnB6edCbF2DtvpIWa/RdmkmIZK3gznHIImkndMAvbuiOWvNam8dUI0dRPaWbelhIgLK5Uw0LCkQ8kbQHeVAsDrfZcBoxRTTWZFmn8AlDdpyE6WC044AAwPoi0ZU7i672phtkL5xbtQ7gPCnUQ4ieT26eOQY/KGWq3gq0UEWPNT8K5R5U6lIbkePjGMh+QsrPDJKXCM/8EpzPamxPpKCG7BETRUMctEnCwBMc5GeskWPjiG+VI1G7cWdYO3HJEizIbbtPKC+xtFzIqMs7gWIYeYRS5T4nunmijIIhtJDRDfXB1oyUdEWbI01NAMNQM96l3uIXSwmyGmd7gP4orh6pzKk4mfzaCU3s6Lbd34gp6CUTGcUr29RomwX9fZFLXo0u+KLFKr1SU1tZiqN3mpO31pYq9FuY6AhOVOI+ro3efhEzelJiQ8b5AHfBEbFzeSdoYyBVUtCPl0L6vpdGgdavqJpP3UaaWfJdg9SH7T1u3CZFXM5ZGsqbfMLn1FUSqRohYbL+DD3oMhhwjBIPHXUQXlcTochv/F8Nmtl/Uw6RETbChke8EQFrnna5fAULCBO7aTQ8MFPyO2W/rhgKJTWQlBNG9GbrXHMGFRN0qCbkSleX6xLh1yKjOUMCjCfPH3Se5QRyOQeKuGRvwyUIhTW6ZULfwFMjCIgKoAfp8VFcPAIWcDEnZgQF2EQISFPAIWRUf1XR/Bahu0YlFEYlcCgybCVN8QMfXCQUanCHJ3E1q4L8yECGI1eRCQbQ0QHBYTg2jWAU4nCETkSSHEQw0gOkugIbYELpgHDGA0YZiAFhGREMF3R83kXeSiM3xERCqITpkEe8GhMTpyfjNkfbXlf3wyJ0sSWt6AR7EAfuTBVKwXLEL0FcP/UmC3ECJUpUMp9iGqVoM9cyuu9j0yxBlf5i62mAkdARQfZndJZFJ4U21i0T0cZSTHRzyY4hilFlGaVlTTZVBHUi9CA4Uq0Sb5ES305xfkUV6Csz1KtQpVASKPM4hMh0tL2EDsRltedy4r143mSHaSSIMNNB/nlEq4cIRAhgomw1f2cyXa40y/VDpdSE2mmEkh0kU30xfXd3Q5NSGZwTDVQlNTJEFX0jAwNoC20IC6pwqWZVwpljjBklH4gBI0SESRAkPn9AP2Ayu6hlP/ZArw2BNjFR2LpF6E4GDKNxbqMXY/olGH1wrAk1GN5IL2xUaq0Q3wsTDhok3b9ihNtZMf/0Iwekd7PUh1CjQvktM90QWDOGk6LZGQlRJveFKLKzgojrGFGUda0pMQAzUo7laWUkJTDOIm8TBjC5VA10dJFikNZTlZvAVDhTcp1JJZbJVJpBAyzsg4h5SMhDBaHjBVB8GS77M9nYc5UgUxNDkIj1WDfsEATalm/kRYCOQDABGZepVybAgs4TJOznNdcPdKpolDnUiVytMU24ERkecKsjZKeRJfmTEgylQuIWQiCSVzR4eGcwAliRecKzJiUkI+agOcidKGJzVziINc5LE4qVBfk8lEWpYkVRUgSxckDESS49cA/SgFY0MoWqQ2m0Ny6sQhNHE2xyeAGOYIHniU7/9xOu+BUb2jeABjB/kBOvrZHvbhnzMim5iggdRRB3nZDkBxnQlnCdrZhQqReNz1I8gILOyHXz4kYdEHkFUTgMwZY/vDliCTEYsYd0IGXmO4ewcqai7aNDWRD83Di6jwdtspcuVUkX+JMACmGlMkM4qXielIKNWCMhxCCVuXE+n4hyv6TjFqZAgapclgJXRjo6eQZTsCmtilHLZgljT6m5EgKmqxhdOCPIIWNUYwJ001IUp6YvuRpk5aW95wmVTaUFN6pyZRE5tybNi5CWJFXjJScmVGfwAGfA2ghKg5QpK2mUsgEgCGh/50V/JATRNCZiXIiJQ5Yi4DgrGQa571FgD/FiAeRZuSFV/xFaoR4Xc/EV+g5xJH1mkNkmlYgjNYlqns1jE6UQvoE2oXpnmG5qjMUGgmhyRN5CI2AkZ/dpW15p0wKQjAs2b3yAiWUnMGYQZA4RTRCpyRmmmWkhkNZgT5AG0eoa1rGqnoEhEkRS7R8aCHWilSeQnn5Q5Cs0ItqpEQV0eB4AOheVHmKUjLEKrx9iZJEavFWo4phRcuYmG/6i78pjP3VF8TFXT8xmqblhLHIlkpYid4FXCyZS0WdpWUGgMKCk818RH7Mq16Ogtjggadeq+pcHlvk4ScqJOrCHJgNhp5egiWgxjh1kTWhFSEQDZIcnDddiumBJtEu4d3/1RBKNKjgDlP3ghfLxShKztADENsUPoMTWQ/WadZ+zFFS4uzFYoUsepWbDNFNbSkUauOZMc/UliO1eh0/kWhUEuOUos5gqCtfuqpVxufn5Aa9ooNj7QEwWFanYRD8PhIreNJf6OzMLprDJmHith/w1F4lzcx0Fd4gOR9RdUqUPlWGEihbMNEKkutNVFsxPW3VTpWoxAxCQKzqQBIKRFgMXI8igs0NnJtAVewO2uyGScpsRhQNbsyNbVEa5ZBmBpAxWJrxbtNPfIpflt7F1l+kLpr3pl1EdJDHRJCzrhBH5GbpeAKoUaLT5ZDDYupomQ5kuoiRsA+MPJACBSvYhKT4/8Ru9hAnjbFcLkriH2ISHK6EbHqSfQnM672uCM4tLpiLlBlKM9Cthvitjqpmy1zQNIruya7t8rLgwdUIjlYBlrUcGBJDQjVFw2HKV/jXI36lWsSda97DxO1fjMEh8KYvn5RKpeIcHQ4hPdnJ9bqCHmHl3yHDQZJCbWEM6mpu2jyPAe7EwN8Ky4CY7Dlme3RLKaUo67lRhAMS5bIROSFE1i8eI2IL3yaN6tRCSJzRaDYf1chmt2yihFkXFujSyBZtqZrSjeLVZm2TdWDsoO3phiMVVDsri9LxEcCST9rOrhbWkb6PIYXNZJTsvMQq0rkC1STUDv3vEUlfhHzGqZEMzP/FDtFGDF9gbimMyEAnI0GtInjsWZkDEYmlbJKQYf2hLyZh37rsiM/2I6P15q66Zfl+VaxYb066nhGhCFkEAp4IXgDeDaeY0nT+wplqIZwtS69qp6JmrlOAb8lEatXopZMjKtJNQiCE7BxalD9OFiMepxpCBve22sks7DdQXkqSl6zw5eOQCbPssbcJH92UGBuB8I1K0GidWXa6kVbU4bkkrmly2ClZIbr8q7y6rpNcYjRnAwGSkbsYRaxShKSbBEFIYRMdrrSE6oiaGA7aqzMYUpTZFlTNF38d9Cn4pbeColAw9BMWzEoM5O4UgcQR7/1W2G+aKes+6J/WtQdBl85/yKGlXCzamu5C1Om31XKw/KSwFINJiJCDWye4lLMmrq9nCg+TeqFjJEEUELUSB2bkZvWuwBTfMXBVdw/gGZ6An1HV5gEusSNChR+TTvBl8cg8yiK11JCiDF8nKgzARxVSrJR4XjRbG0JHf3YZC0I9pQlVlt1qrbWVNzTfU1vI0E+yqtnemVh1kAmd6NHvZbO9DZknYULDncPVl1KHvyLzdxW5zvEkm3Ujn0E3bohYiERq7rND0JSEUGucVOAoQNgwX07EJF4liLc5HpV8Rs6z+0g0ybdIhIesTIUj7G6ZEScfOgOPPUknKYvmgdgjzkF5Iq+tashxKpMjeZZxaNk7v+ssYvlUYQ2Pzf1Pt8MrB+LvXG227ltDprNCKTNI6EpEneVdKJ2LGPF1TX4AILVjSJdmFmrGssMpIl6F+y8pq091hOtwQ8u4AO+ge+LsSxa4rIQq0kLQJhUgy0gdhc0maSb0hDMVEHFGCppNkDIZC+yMUErq6+8D3SHipet4hOdtaRyhSSO5PdT4IugM7r0tZ1ZeJ6kJ6MwEa/qmhD8OG63ELCyzd9VeKIGUCQd4l9plhnp5GRcW7qI22yeCmfrOI06NPdhlJ/ThFWDLeOVk68l0LHxz8PidqTsATjlC++DP/r2y5/w0dwiDll95HGOuhMmiE0+6ewH5V5IMPf12Sz/IJ0g0YQIQpsMEyNO1icNQJEmeI0ixL6E6SQYiiNBcixADcQtQTPfYOSB/AhnVDzIxZtMMT8Ch910kR/TNqvA0GOpBRFShEqmemKSWux8KGu+F+2bOmSycemYrlmazi1LFCj34T9wdJKuNR4PfEoZ/WA4oxKbKBsOQ4fI8w2SuYKICCJSwiOIdOaTrQzOZdn6TkXqpEWAxXnBPgnaWsl4ZFlZvDaTFWB+MWBeavCxhRMShCUJWVLT91K31SbeVlXbnj6/ez+R5sufO5hr5Cxf15l7FV6RRvHIQkPDaui3ldDLI2mcIb5FA63VJsuoYFy6tHTUdHlQlcdv21XoJEFo/7lPSQWfOJuSDdnWY5V/DCOOH+83Ia84RwPKPZqjybWJ8mCJRuyHQgG31pzdwqiTH/c3k4tFZy+RtWomRKnxZSBWPH8KsKl6bs4wVp7wxdtE3SOzjwjzCZSHZJtRLnkkOI2kjq7Yr6ZTHi8QnmseTxwI3nW+ObqGIeOhIk0yXaREh57qNxsJKbYxYtVmTOLG4qy39lEXBbTrmUTxI/9TzbQbd5JQ7gEmxC5CZGM/S1LLnzQodzDHVldCYY9F33YQIl3eqYAWYwbn/TDfW+LND1g7CpjRcJRD8rGAGkONAhrBIQkb/Smu8BOv4R75U0vZ9r3mm8DXGvrISAwtdaiQxv+TWXO0bpjK0ohvKufEPq1uVqHgSQgwtCNTJYAlqr04az3JwUGAGYSxnWiqrtVRsHAsz/QcLItZ73zv/0DfRGcpAA4GgGXxCi5FDkJTcLMcCNDLrbE0HD6KbEVRJHAFWEEHpyuYFZ7KpHIzFIiKM0EpIE0GVx8CX2kYeU4ZHYIVdwZeFiREiJMXU5SXmDY4JZmdnp+giZwXBg1GS1KUjowLgnNLfFpmF6ktexm3V7VoIqt0aa+6H69UObRZo2gLIrsKHwZZN4uUilZvZ33JoT4F09vflDds4OTl5ipDIDmLxpMKjnt+N3wBbiVi87SSuxZDy1L14tyCREBNQVsFq1j/EEfHjaMGvgYtKxZhQhM3ERwKKIDNSbUWpQZgi3SuBgAxJVPKENdO5ZgMEgCczHBg5sJpB0TUlMnTppUBMY8M6tnT5Yx0IADR4uckAAmd9qbkmGghDClLdjg4+sBS56yFCQ+OmfWo38GpwCxdoYfDkj0phDoG+VjBUcRskoymACA30wGRIlEExuDtC2EtDgAr/sFSW0o32NYwkYVDUCE5BUlsqnxBcqq3m/vq3YC034s4FSaPXs26x8e/iwnmbY3BpyfPlsDiOEOM1bSBFjfjQEmj8exzJMFyIaagG5zUYubAnvdF7t89i0Qi6faX9l7HpTbGUu29vHkOrTBvIuX4/7yEUDkn8PVWLGREP5VKsFOSJz6Ah0DRp8k4RmGxyxVc3AHJPsxEJ1ZqsWxw2VXnoVCaHElc1lKFHHpH1wXTJNdhCOBMaI0kgijwh1nJpFLPCMftYJxRVWxhSwA1wQVdZ6c5COJAJwBJYYeizCYBNuQRqaReH24gIofvfSNkVajVZgIJZiHF1IJNbRIjOdDURcQedTAQiCy8dPbgFbnh0mYfX1Z4IRVGhJfalkvmaU6TLbAXZ2tRboOnQrhAAVxBFm0UI5ZBzOgSWl8Jqd+DBqERYW9spnAXl3oalBc0AJxy55udlgoKn30IhZeSJH6TFUyU2mKHPWOxItOisfLgaP9KbPI0ijZZTfjZg/xkioIbGmyq5Jx3/IdMe6ZG2wmfgQnypJwRgvIqYSZGAQEEtxyyEQ5O5iqjly6RQSVEOuSUBmSDwMsmUAz8SGoLf3R0l1IdzlnTABEmKW0KQA1sUnqQXHite8R54oZhGLgBxQMhPIgsgmWYyygQu5aErD7ZbDKFZgvE0hhKV3zp2QjE3tvanBLiaTBMf86MXpUUOyvbsg1jsnIGJDOwcRRKCFsle10SmNJgVTUAVAhMjxGCN0Dxa4hogwQQW9NaYP0ytLjIbHNVNY+tZpW6TLDIwuZxtA3AIbSaAcAnNaB1UlTglG1VPdfQsdmA7wCzBhsGvlD/2YF/WLUYbJfnsuE+/A355OiAjYHAkKtL+c3ThLrtqh26sPkkko9uulllY2645qert8gVcftJJMCtc4xu7bgPHvbjNrPe+occWQ06h7bh7vftxp+u++WWm+278ghLtM7OHXYDChI4KKFLyfmNs/1mLwQtwn8RKwHa3jCUnjzkyy/F+8wDIA44XaID3fxqSMBHpsS9StyFETOpCQT8IBOtSQGApuBHKqQgE4wcT2nr21z7UPE+g10hefQrwecaByj0XeJMfTiNtaTSN0wdbVy7WAWQmlMc5EWQchMclemeZzrFiYRx9xuN9UIRnkx9BQKQuFdv0NAR+dRiFZ+TxoAK//dCw8VQGfKTFg1HBzxHYCWHRnnAN+5gjw/sgV5ZcMjnMIMkDfJhDm5QwhzugrGVuLCJTsSi6gI3RQlGbzuhkh22tlgCVW0mC/IpnkFGsge+/KIuZqjCELulAvXB0WZPnCPg6gjDO+4BXoiMoscElAkg0uIFuliOuQZJirwoES+IepCN3AjBmXFyfZEUm9kIVTvF7USP5nnRN8g3JOxxZZQrKkJexLW9YlBplChwZKnq90hPWckuqNCkqSg5uY/ArYC4LE9ZtjHEiOiCIjxxkBjSyBNCZEEYdSCZ106gzFLt8JEXusG3pCLLsVGTfQgLyB0exEEmebATujQNiEDZiP8+XuAB2IgfPMJjyKpYrxF2WCc732iwd8IxnrmSpPOQWc076sBOw/PONpsZg3Z2ym3NnJMdeELBGXIUn0c7YJX66RKZkLSFrayoRH+nDTiQ607SLBUteXq0muAomzKCwMSOOggexO+mOGXiwBoKT20MVYaju2ccT0gnpNJAqfWAwK1CpVS69S1ZO4WqOnI61bTWUBsIAkxLs/rSrQriL1Hx6kos0VAXfMAF0IifBCDgNZuCozGbgII4RlqbHJwhfjjZxKVEFjmKtpWkF/IpBbC6uau+FTXy0aJeY2BYGPg1Xpws7TfoNoQQCAUjTtEYQNTGChTtT0NJgFpl2SotlFb/NXVYNBjtjGdNe4yUpisQ61lP4FstBHUSbLyMsiaQBT3IxxoJGtk/oxrcJVm0iTBrFjvqqVY9fagmJFhbdwWTRxgAJkaqKsldevM8ZRmTthIRhCc3UkEWmFRP/X2rbaWwWWUEuLzEix6IRjuD4a6ATRHQpsXU8hVYaMCT2/riDQB5wANv4L9Lyt82dmLIp9GBqcLbpVXFEinyInhZCi7XcxOxXcLU2ChDS8KPOjKl1EQgtlwIDVjEyhjLRku0oNgwUOwAjQHeqh6OOAJZ3SqEFS8hyOt98XnO2yfqCWG5A63Q0PZbDG8oKGyUtVQUUOPZc/HWVIHyBBJeF4uGxi9B/9D4C2N9BteSFVij1cteC+xR54hW5SSvnNlr0vixTAIhwixgpoRlcYahjcVkFVuEEgciDGM2ysimEiQmniqDacQ5E/7CyHg9jL97iAQuUliyGRhIXexpBio5ADOMq0ROHM44YlRmNZgoRQJwcdUgGmQgpRY4hW82hyeAqDArpRqt73bCCHI9yo2B4C8RlFHYehkjflARCziYjMDBC+ZU79iECCGXBdY+lpza9B9Df5iLSgioHF4gqjFwp6BJmPMDqb1McAuOyDBo4K9lcKFMbYzgHJK2A7JVExBkC7+MMDhrXoMWBssg3ifYs5Z1BepOifoT+lZBbrlp5dRgWeO8qv/ruRQdPdp5493JlYHIRz7wLIs50ajedj/AgdErc1ZPPZ7LwlfzoQ642+cbOPDOeb5EqPcA6JETOjWCTeUfqLQELXJxeZrzrR/85Tq67pdH4+JlHkh6BVOneklLjgi8wjwFzd1l2hmxd263RwJigDiHHgCuH7xF6wlGm0AqbXXCSF15iA8H3Z2wvYp4zorzcerdBUflk/P5S3oQe4Wc8oMwYX1JTR+3o33gYHif3mCnPuzkPSKc2icd3n2fBFVX4PlL6I5QgCYSL10TebUXVTseT5/Qj8rIxG3ezYJHBGhs35biPN8kr5dD7qsM+rlKq73En58lo63epTsAzEjwXKj/tt+p2H8DxD7AHvVrL02QhyK+vC++a5LhruqMqfGsQWaCo39yUnM6IF0AWAS8Y1MiRoB50nsoN3ulN3/Uh3iqVQ72xwEOeDBEEDR/Jnrn0W88cIEG8yGzsk04dwIucBIRcFcZsEPtNjp5J3tvRnsUSH2vl3LlgH8qAGn3x39OsTXB1yFhIgQbWB5NIgEhkoDBAwgDZEUDVHZikkabc309Z34qcIPzp2uQpRKR536o1lNvMoQR13UfhoUbhzBzRoVt91UraB2VUASAIAHNJ1xWyF1oOFFaaHu8gwRm6HsrcYRH0VMSB0UGc2wNloej8RFGEAgzBYD/omsRRmpjkX15/+KD5gB/grOH1Kdy7EcN7eJfgshwhLgeR7dMiLgSisgkCFMKpFeEITUDfgWLKshkRTSK3pGBSSaBPDB9tKYdf3ESPPEtHEWL5wB4ULgCrfcJDSeMPkGG53FBZidzqJdPy0BLKegksOEAKiAgOgh7uNgDmlgD04cS2TYGSuEymChfddEAEIhaLDcbAeR900SNBLOKRkEXJHI3bdhgwSOCMbCOMxN3oTCOgTh9tZERLyBYTlEPArKCenERY3Bj3xKOlWNbdgB8CagXpDeN4peK/UgDX1QDIDQ2AlkOBulepfBL/BBQrpUFY8Q3RpEjZDUGSUAURJFnfWCJI2hlp/FyU//1fCBpcvn0LRu0kX1gWnUTAv7jPHcIfUgZdQ4QUXXQGQ3QHZ4kAphEG84CCPVTD3ETljiSEyIRWE+JHpKwBRyBGtDYNpsnjWPzESZABj6RjcyllPDQiEtCNwgUdTyZCSn5YFcyCO4YHVf5AdimgJ94KrnhNjMYdUg2LeBRfad4UuE4lObVijJhBr5llxrwdixQMETyBUagNTd0BygBkCURmN1oAi4TUHxxZ/WATbQxG/GjmswVmWFom/wIVAOjY0CAmQ8YPQWEiZ5JE6y2jG5pjIMWCyd5jLw4AyYQKrvHIwhnVmqwmHLmQTlIWBZpIY4RWyDVltqknZfzlwWIGoD/ZVAhKQO6GWnfOS359i1yAVKrwZrowB+JdnYTFxnxGQQVVwNahJh/SAOZxUAPU5lIV0K0mTVyQwoFah4f0ZFE1J4xoJwPdpaU8JUERRP4aDs1yA0AhJuEAWXL8Z9B8GtKRaLU0HIVamClAjcvyi1JQIWL1R41CpzrxmaFhHHHaQj6B5q0IVoNZW2PqRL4+WD1QGUNiKLcZnDx46RouWNU8H8feiropjHNtgcVtikSoyIlWHPUuYRL9x/oqYsRCRFFkBhU4DQaKo7RKTgzYD0kuIgVKYUsUJ2S2S61R49K0mIaMFT5YA3T4ElalXiaxkW+dnUcQVgfh54Y+C3jAy7D/8AHVwqnIfoD78kBI9puUhoEAAMNTJWn5kmKRAA1qOqnI4IoFTM1PMItNzdODYQGkJqGPBo3j7hw9QMwpXl6aOoSfoWYp/CVfPCrNBh9kfM+f6FbcvCpoKp/70h7RPBXXaagFVKaXpBObHBdPwI0RlBQReOHOyoITvEFbRSLNGBvVEBWMoF8g2AYLlCqWKpgraJLR7qacVocDlinrAGGKfCgtzEK3/NThpgnZjATFLqsG8Yt3qo1WgNEjSqvNUWcjbCorjFYo3p+g9VAxMhA56FOnbEQ7SaxiJCk+edekUGyAKV/ALunVkCtEAOjeeIFjwB+lZAt9RUd/BYqEcp0Yv/KFcmXc1mjVECXPW3Ss5QAN1Y1BUSKtJdgsvlpWm6hsqjGfi27m1WRGNtorefhAWGCm0O0lalhaq75H06bjwjTHF5bftxgCGFVmsIzWCXwTgpVq9SgE7URDU0gmqMBtXsBZmFls8/JdNt3m/FoCz8js0uSSErAnHXhNg9gIGszTFciLtHyEXlUlRYaaV/iH/NktuNSFg6pp8hBGiZDD86Kh7exXGvRHZVwtqCamxeqVKmLOiuArK2xX44bL22BmMnGWB1ZkqGmhjrmowkopE1FGIARhbTDSxhaDpu6b7fCBf4KnZn6ZSnAJvTBgyWhH8lyeryKUrWLGe1SQML4LG//2glrATCFmL0N+iN8cWbfF2PViq6lphb1lpGksQ5FkwbISw6k+xP4ML5zd70X20jUGTF2iwhr4A3fyDf/YRs2G7B8Khyq2iG3SQISBWn/KxHFtsCLSK+9uXo7QImEd5Pfsr2V0Q2CRpA8lGh4uxAEnD75Oqevt4zG+gkkgwc1Wh0iwbFilVAdG2sUfFCzQInkSRtDaQd31ZQ0YY/Gp2ksaLElzAfbwVTo9V1hdZMukD0u/AnRCwkbIcX9WsM6V6vpW8BsMAyR20fhlGK8GkBChrVgYXQFi4qJNnxgwUnCuWtNrEZPt3BR4jkwAZCtgm3n4xLVm0d8hbTU+q4g7Le1/5iYc4pjwmE+LAF6ZJWxm3GpzkQlSfBwIDikHNW+ArgEIGyri9BAqvWjMiwm6OOoh0YH0GDGlGB/DrkRnRGbrgXE30qM37pSmNdhK4VvOMKXUXins2LLoSkCgas1QPcFFJoSnRxhD6M4b5uxBLEJsLu/lFsCoZfGYBwnlGgI5tK+w1slgLd7rqx9aqC/c7OO3RBbBFYvLuEyw+UW8/RjOWGuY3mV3FgdY2AYAO2VT6PBwejD1WEYoHGpoZodHMtkTAYuGcJSSDoOQrEWBuFakrpO5UjHKZDE/RonE0wLAoLOpXJe9NHOVKCV73uzjeU9dQgOg8sIOhNEFVEQBQ3JdP/QVDphrgEd0PBKmhkt1ARdDAZsA5pxkyMMyYChZ5YXoCrBhtajT82CaAm3GVKqO0gclR6jjvfSvihNlJjJ0vNREallIm8BCPxKDlqUYlfzI3+VR2DgAGd31E5z117JjU5j14bRkH5910AtGfj4PUeQE5LKSRGWIw/s1s5ZqYJWdbfndzFSE5YxyrnrMnrcrclCtRNb1gnIF2DJvc1JE4NlnylhAgKX1UGzFUBLmFxBri1AvX/9rlepFKIj0GxKBUiNux8nWUCa2J/UiA5RqC+QwNxUBMPwFlar1SDtLTyG2QG4XcIrTE4yw/OKdWbtAhzxTxC5AR0MDs3bM8tKVrP/IlZ1E5u8nTUvAbTSjI497d6uOz42MRj80tCU8EfgPVjojQU5kV6BQjE/5skvqF+Na2x9EW+K5dyfByKhQh4ivRq7K0wOjM4TTtar3N1kKo7cLR6FEarcW6yp/GimAKRkVZrelrXv2t7rPRhQkBPwzduv3R2wAQbcwQUu3ttefUzDoYxQc9UnMc2gFLjcxB9MEAdD08TaqOOT7XXtkSMstuPmgNoXxkBy2zcsiuHN6gdXtHCNekZRCIXhVOBjnBInPhT4slJeKdvyrRR4+9OHedQCfdcyDuMLLeMvUuN+jWy+TcOJ5Ua5dbDaQ1s4kuXucBo9XqUY8uUeFB6ItdWl/8gRqxYtY31odkHaAgVJCGPe5czSGSEGtOOSqkmnnr1XE1mEScAFNE6th3nbci7U1OvTtl3XtM6fey0SCwnJdU3YpDPH6dPdHiBPhBUls8JHwL0RdjPPntMzboNYpW67x0TJiqsn1e114kx0xEk0QYt3PHtQg24Fp2xI1fsJzY7W4tFUrS7fcA4Gtb3QeG3Xa94dtz7rMj7G7t7XvM7Avi6TGxClhHnc+SZihPcNAxu/ZxQZoiHu+t3gNvaB1+4XUOxfBA7AMZZiZi3LExkvu9wR7xHGoGA9KGI9rb7ifd3X5krrRo3ycT7nfL3q8o7sJ3/U+W6Du4GcHqS5dFK8AP9zlZv9CV3cFqremKnlzAvve3C11OMh5W4d8bw38diuzky24b0ov/7GCBsPpBp/DpDVyCUf83wN7wvd9YCw5ryd1/Fe8i1/dgCNaF7vjsy8v5ug2BEiQEcQJU/zAkfCHyV9PXopsmFGGkTPzc9NMd4Q4XpxqKoYl8RLy9uOAlHmeFYvshQnkauZoIyw6uke1Cv/8ptf12h/8l+/8nseKjG/9m9/MwSrFU4IaQ/bEDpGO33UzQbqjq/sUCeAsJsx4t58UAJp+DTC9CqA+FGcMLza+CEHkAFqCXTzgpGfEkE4CKoN60At9m1v2/T+5rNO5+mu9nztNtrP50qfuOBtz3L/8ABNPAXTPOWI2Q8DfPvjsxkuC+45QE8Pn6J8hY9tltIKVk7GH3XrWD8IULJyBYetMgSVOOvNuxgA8XxHVJWVEDRqcwxm+blnZNKuDN/oskaBQu/FChGOBo9SYzwSGKkMILoABQKAgiHYKAiX4HDG0WVcJVlOYRVwEpLiuCAElziODKR8z980UwAAfR0HT4OHiBxGERIrGAZvh1lUDYICdQuBjgwAK52JoBYkQDQlpjMoJjAtqakqMj8DOzusL6kVJ2sNtJ5umKBNeD6WSgdTb14WD5uhfFhzCj7RnFkPgdUQc77NTJFQb1OMAkfT3OZVbgQrBsTchufwYIsYlJfe/32BlGSijc8SIB/axQNzwIAOHD3mBLixqwqLGjUeIjx1YtSpHwEXHowQ7FeiYO8sCOQwwOCBAAb9DRTzRQaDByUCLTC2BiUVSE5GcqPzz4DPAFHIrWxWKJ2IN8xCERA3tGmmI+JsMbXnUYyDbHYslfugcqaCkk6XkMH4g8gMLeyuOFrFqsWHFAsbrIULC8dbh8YsyfKhYhu3Nm6YfvKA0qAPT2GLVfVhQJcZRwILuNHZrI1HY8LGiUh8SLJREYUp9yFQj/O5eQsg+WynepCDrZUmYLg6Ndpi0x8Mu3W710Lexm/SYnV0skrdEo6A8iX1ArINtcVfTfC74Yqm652wY//B4tnJmuwhvoPfbgSwmzbjtatPzx5Le/XbtZCfv31+YywEsuP3Rf69f/cAXhfEPbkhQYweuMkxwGfeqaBaUnGcBAAksCXYDGoDaFERA631EYRO0cCWDwZffGFhI4JsspB1MFRgolzuNdYYFDbAxcJcy9WSAi1w6cUIG9RloMU11hB5TSBFHqlkkkYiqeSTTUbp5JFMVrnklVMmac2WWELJZJdTSpkFmEd2WAUFUwl1Yhg4feYFHCCotswOUb0gC5I43bfgmqdBRY0GZu4RSGNVpjYFUHe+OMEKip7IBUdePOmFCGw9ZExJMA1KCw9EmMIDKhTpAIKnNmjjRFULVsj/56pWscqCDwRmqJwEarpaHYPqGPpPEFp0Z5RPjeXD1FK2fuTnYxkEKseEaumXhkhZjoAGo6XhJlOGW1RkA3Lc3RcVUBOC48VxOvaASym2nAuDEJ7O0JEUpBUr77xh8MSAA6oduBm99zJoQBTSbtDmERBuQCy/gh6rwqDlKBtHCGEimcmWDzyQqxmCTMFqIAUpx5xZKoLgRQpAnCTLMxSRMEtdFZS1ClkFSUXLu/f6NBXCONNrb1aZIYiwrzlhcLEGQGfGwR035+wBaha4GJLDYrDjhzRTnRTSMxqvKp5EQ5Tq9QcBN6IOIzzmMASoNRBREbsp06xNwUrHvXGs5MS1/0Ct/II0dB753WxeOqo2AEk1csujsEusERhhHd32+o01m7z4SdZ8ZhEXp+021+uEFYckV0lk32g2KqCS+mlLB/0NhxZJF+66hTt/ULc4eNNblBP1LJihCEyxo/fBjQzOSLyvK6LwTAJBDQZAc0zR4hqM5DOAe5lIIARKrkp2nFRqF8mrFxXrhjz0aqvcSrmtlEXtLCz4+u+Mxce/ZuxVGMF34LYC1mgVcNxxwThAMEoUdscOwdymeEybSVKUtwR/lINXnQgCU0KkFnJgZVUzUhe6MoQNFonsCpiAwYRy5LLzQeQWM6iASS5iqlPBTX4wbErs8IUMvh3QVvDTAPbuJf8ZdgDPV53wzP8yQLwYPgV4HGCgEvwhPgsEa1zWOyLB5FVATqVtUKFzwQSywBTrKMCKo4NIGCWCplNwJB1GTCNnYlcSyt1tXznb0wYKoUPJtKMkSGBHtThxw8IlUEkcUpwYmJiBINyHRNNxwgsttAXSiZFXYLSFMpLCnba4rCFdS9unVpi6IKnxk/Ggn8HgmDMt+KGIRBxiG/A3GyTCMIGyiGUg+8gBJraOaFLMj7zGxhy3vAYoz7HL9KT2j0LsSJg2IsVbSiaXpu1IBu4DpTRDKUgN1A5npHTQNV9yqgaFYW+vPJ7AqgkGf1juCtMDinuIlAwLTIaKvSSOi7Imxrv/cFAK2xFdQsgykx0dswRwspHqpknQv5BTaNlEWEkaCbZ0VAtXg6Sl0gBzy1n2gXlcUYtG1RLLKARjkQmCQBZn0IWWmWEmoSMmBp41QJQ65KUu2YSLXCKOjnT0pjjNqU53ytOe+vSnQA2qUIdK1KLe6aC0QspGl8rUpjr1qVBdarDUUTSCLfV3Vo2qddSh1a569ate9UxFU6NUsHqRo4jyqVp8VROzujWsQGlrTbRzBQpwxzoRvM9V5QNCcK1BVnU9K4CCYJ0tDPY7uEqsYhfL2MY69rGQjaxkJytZWlL2spjNrGY3y9nMjtUenQ2taEdL2tKa9rSoTa1qH2vZ1br2D7WwDe1nBxbb2tr2tp9JAAA7</Data>
      </Comic>

    I have even tried the actual string literal in testing like this...

    string qry = @"from e in entities where e[""ComicDate""] == ""2008-01-29T00:00:00"" select e";

    to no avail :-(

    Very frustrating indeed.

  • Friday, November 28, 2008 4:41 AM
     
     
    tjarvis:

    Yep. I was able to confirm your results by entering the data using my Provisioning Client (Web UI via REST, not SOAP).

    I first copied your Entity directly into one of my existing containers, then executed your example query.

    The following query *does not* return any records
    from e in entities where e["ComicDate"] == "2008-01-29T00:00:00" select e

    The following query returns the record in question:
    from e in entities where e["ComicDate"] > "2008-01-29T00:00:00" select e

    This seems wrong to me. Maybe I don't understand how queries treat the dateTime type? Maybe the rules for constructing queries for the dateTime type need to be done differently?

    Anyone else have insight into this situation?
    Mike Amundsen [http://amundsen.com/blog/]
  • Friday, November 28, 2008 10:02 PM
    Moderator
     
     Answered
    You need to explictly cast the literal values to be of type DateTime. For example:

    “from e in entities where e["ComicDate"] == DateTime("2008-1-30T00:00:00") select e”

    There is an example in the documentation. See example J.

    http://msdn.microsoft.com/en-us/library/cc512431.aspx

    Rick Negrin
    Lead Program Manager
    SQL Data Services
  • Sunday, November 30, 2008 10:49 PM
     
     
    Thanks for that.