Entity Framework - does it allow native SQL queries?

[H5N1]

Hi there

Not sure whethere it's a best place to post the question, but I'll
try:

I cannot find any resources about native sql queries in entity
framework - is it possibile at all (eg. to use Oracle 'Connect By'
functionality)?

thanks
H.

 

[Miha Markic]

If you need native stuff then place it into stored procedures and call them
from within EF.

 

[H5N1]

You're saying it from the position of good practices, or there's just
no other way to do it?

thanks
HP

If you need native stuff then place it into stored procedures and call them
from within EF.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & developmentwww.rthand.com
Blog:http://cs.rthand.com/blogs/blog_with_righthand/

Hi there

Not sure whethere it's a best place to post the question, but I'll
try:

I cannot find any resources about native sql queries in entity
framework - is it possibile at all (eg. to use Oracle 'Connect By'
functionality)?

thanks
H.

 

[Miha Markic]

There can't be other way since EF is designed to be an abstract layer.

 

[tobiwan_kenobi]

To do ad-hoc queries, you can go through ADO.

To get the 'connect by' functionality, you can create query (for ad-hoc) or
a view that includes a recursive common table expression (CTE). Check here

http://www.4guysfromrolla.com/webtech/071906-1.shtml

 

[H5N1]

To do ad-hoc queries, you can go through ADO.

But can I fill my entities with normal ADO queries? How?

To get the 'connect by' functionality, you can create query (for ad-hoc) or
a view that includes a recursive common table expression (CTE).  Check here

http://www.4guysfromrolla.com/webtech/071906-1.shtml

You mean I can, if I'd switch to SQL Server? That's not an option.



thanks
hp