Entity SQL is a storage-independent query language that is similar to SQL.
Entity SQL is a storage-independent query language that is similar to SQL. Entity SQL allows you to query entity data, either as objects or in a tabular form.
Questions tagged [entity-sql]
98 questions
0
votes
1 answer
Teradata .NET provider code first fiasco - Entity Functions not supported
Alright. I worked so hard over the past few weeks to learn the .NET data provider for teradata and set up an infrastructure to query Teradata data sources. Everything is great except....
Canonical Entity functions are not supported by the provider.…
Sundar Venkataraman
- 133
- 6
0
votes
1 answer
Entity SQL vs CreateQuery where one works and the other errors for the same query
I can use following line of code to create a query that only returns objects of 'ActivityEntity' type....
var q = CreateObjectSet("EntityBases").OfType()
.. and running the query works as expected. But I want to actually…
Phil Wright
- 22,580
- 14
- 83
- 137
0
votes
1 answer
Force entity framework to load related end using a ExecuteStoreQuery / esql
I have a 1-1 relation in my database and when I use .Include() EF generates a horrible query that takes ages to execute (mutliple joins). So I thought - I will write my own query to load those entities. What I tried:
I tried using…
Jefim
- 3,017
- 4
- 32
- 50
0
votes
1 answer
Query conceptual model with Entity SQL
My application is based on Entity Framework. I am offering users to query a particular table by saving their queries in another table. For example, TopQuery table in database stores all the queries which are popular among users.
These queries are…
user1485190
- 55
- 4
0
votes
0 answers
ESQL aggregation `COUNT()` in nested query
I have an ASP.NET page get request with url parameter of SQL for AJAX to get JSON response.
E.g.: url: 'GridService.aspx?query=SELECT VALUE s.Name, s.Email FROM ModelContainer.StudentSet AS s' will get information of Name and Email.
In order to…
Ovilia
- 7,066
- 12
- 47
- 70
0
votes
1 answer
Entity SQL doesn't work if edmx file in another project
I'm trying to use Enitity SQL to query data, but if the edmx file in another project, there will be an exception thrown. Below is my test steps.
Create a Class Library project and add an edmx file to it, create from database.
Create a Console…
James
- 2,570
- 7
- 34
- 57
0
votes
1 answer
ESQL doesn't work in self-tracking entitites
I've followed this walkthrough to create a wcf+ef+self-tracking entities project.
Walkthrough: Serialize Self-Tracking Entities
In the Service, Linq to Entities can work well, but if I add a method which uses ESQL, for example:
public string Test()
…
James
- 2,570
- 7
- 34
- 57
-1
votes
1 answer
Entity SQL problems?
I'm learning about Entity SQL but I'm having some problem about how to code, I found on the Internet that most of the code they're all written like this.
ObjectQuery example = new…
Bùi Lê Minh
- 1
- 1