Entity SQL

Is it possible to make "Entity SQL"-like queries against DataObjects model?
It is required to allow our end-users write their own custom queries to data storage.
[Add] Direct SQL query not suitable in my case because I need to manage stuff like user permissions at ORM-level but not at database level.

dataobjects.net entity-sql

asked Dec 09 '10 at 05:38

vecs
5●1●1●2

edited Jan 04 '11 at 16:03

Sergey
123●3●3●9

One Answer:

oldest newest most voted

Hello,

Unfortunately, "Entity SQL" approach is not supported, but there is a good alternative: try using Dynamic LINQ library to build LINQ queries from user-written query strings, I suppose it will help.

answered Dec 09 '10 at 10:05

Dmitri Maximov
2211●1●2●11

AFAIK, Dynamic LINQ allows to define only expressions inside .Where, .OrderBy, .Select, etc., but author needs to evaluate the whole LINQ query.

The easiest way to implement this is to use CSharpCodeProvider to compile the query dynamically at runtime.

(Dec 09 '10 at 12:54) Alex Yakunin

Thank you. Most likely this is only way in my case.. Main imperfection of this approach is that CodeDomProvider compiler seems doesn`t available under Silverlight.

(Dec 10 '10 at 08:34) vecs

Your answer

Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

toggle preview

community wiki

Subscription:

Once you sign in you will be able to subscribe for any updates here

Tags:

DataObjects.Net ×574
entity-sql ×1

Asked: Dec 09 '10 at 05:38

Seen: 3,638 times

Last updated: Jan 04 '11 at 16:03

Subscription:

Related questions