tags:

views:

83

answers:

3
+1  Q: 

Using plain sql queries with Entity Framework

I'd swear I've seen this documented somewhere on MSDN site, but I cannot find it now - I'm searching for EF equivalent of Hibernate named queries - ability to encapsulate database specific sql queries in SSDL and then call them just like mapped stored procedures to get Entity Types in return.

[Edit] The rationale behind using it is optimization of linq/ESQL queries translated by EF Provider (sometimes they're awful).

A: 

Entity SQL and its related functionality might be what you're looking for.

Justin Swartsel  2009-12-09 14:26:49
Entity SQL is not database-specific.
Devart  2009-12-09 14:43:59
Yep, that should be ultimate mean to optimize queries unefficiently translated by given EF provider, so there's no difference between LINQ and entity SQL from that point of view.
deadbeef  2009-12-09 15:14:52
+1  A: 

Create Function in SSDL and set CommandText to it like this is described here.
Then make Function Import for it like here.

Devart  2009-12-09 14:38:39
A: 

OK, found it thanks to Devart's link (it's described in the same section) - they call it DefiningQuery

deadbeef  2009-12-09 15:20:33
If you are going to work with DefiningQueries, you will have to create an entity in SSDL (with all columns returned by DefiningQuery), then an entity in CSDL and write the correct mappings in MSL.
Devart  2009-12-09 15:40:08
You're right, Custom SSDL Function seems to fit better.
deadbeef  2009-12-28 09:45:33

related questions

SQL tracing LINQ to Entities
SQL Anywhere 11 (Sybase) with Entity Framework in Visual Studio SP1?
ADO.NET Entity Framework and identity columns
Is anyone using Entity Framework with an Oracle database?
LINQ to entities - Building where clauses to test collections within a many to many relationship.
Entity Framework: how to return a base type from L2E
Unit Testing in .NET: How to Mock Entity Data Provider
Entity Framework - Can you map the result type of an imported stored procedure to a custom entity type?
Entity Framework and Application Architecture (loose coupling, etc)
Can you use Microsoft Entity Framework with Oracle?
Using MySQL with Entity Framework
How to Implement Database Independence with Entity Framework
What is the best data access paradigm for scalability?
ADO.NET Entity Framework tutorials
How do you create a database from an EDM?
Anyone using the Entity Framework *Well*?
What real-world usages of ADO.NET Entity Framework do you know?
Which ORM framework can best handle an MVCC database design?
Where to start with Entity Framework
How to customize Entity Framework classes?
Linq to Entities vs ESQL
ADO.NET Entity vs NHibernate
Update database schema in Entity Framework
Expression.Invoke in Entity Framework?
Entity Framework vs LINQ to SQL