HomeActive Query BuilderEntity SQL

Entity SQL


Are there any plans to include a Microsoft "Entity SQL" syntax provider?
Pierre Alain | email
February 3 2010, 08:09 PM
Dear Pierre,

It is possible to make such syntax. Colud you explain, how do you plan to use our component with this syntax? Who will be the users of this facility? We'll be glad to hear your thoughts about area of appliance of this syntax. I can see that the Entity SQL introduces many things that are not familiar to the database users, such as Ref, Deref, Key, Row, etc. The programmers don't seem to be in need of this tool as they can easily write simple SQL queries by hand. This dialect is not intended to build too complex queries: it has no sub-queries, derived tables, etc.

We are now in the process of making an advanced expression editor that will ease writing of complex expressions. With this editor, our component might be useful to build Entity SQL queries.
Sergey Smagin | email
9 hours, 20 mins since original post
Thank you for your reply.

We are still at a very preliminary stage, but here's the basic need. Users, with some working knowledge of SQL and query designing, need to access a very complex database. To simplify query designing, we want to take advantage of ADO.NET Entity Framework and build a simpler conseptual model on top of the database, and have the users query that model directly.

This means we would use Entity SQL with the EntityClient data provider to fill a dataset the usual way. We would not be using the object model itself.

I am not yet very familiar with Entity SQL, but from what I saw, it's very similar to T-SQL and seems to support sub-queries and derived table.
Pierre Alain | email
1 day, 12 hours since original post
Dear Pierre,

It is possible to include support of Entity SQL in one of the next minor version. What is the timeframe for your task?
Sergey Smagin | email
1 week, 6 days since original post
Hi Sergey. That's great.

If we could have it working for the beginning of May, it would be great.
Pierre Alain | email
1 week, 6 days since original post
Any idea when this will be available?
Pierre Alain | email
3 months, 4 weeks since original post
This topic is closed