Calling user Defined oracle functions using Code First

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
surendar
Posts: 2
Joined: Tue 24 Jan 2012 07:04

Calling user Defined oracle functions using Code First

Post by surendar » Tue 24 Jan 2012 07:13

Hello,

I am currently using Devart(Code First Entity Framework).

Can some one explain me in detail how can i call User Defined functions(Oracle) using Code First entity Framework.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 24 Jan 2012 15:26

Entity Framework Code First with fluent mapping doesn't support stored procedures: http://msdn.microsoft.com/en-us/library ... 03%29.aspx.
If fluent mapping is not important for you, and usage of DbContext and its opportunities for dynamic creating/removing database is the main point, then we recommend you to work with Entity Framework Code First using Entity Developer. You are using explicit mapping to the existing database structure, aren't you? In this case Entity Developer is a better choice comparing to manual creation of classes and mapping. Entity Developer allows to generate code for using existing database stored procedures and functions together with Entity Framework Code First in the mode when fluent mapping is not used: http://blog.devart.com/entity-developer ... plate.html.

phowe
Posts: 20
Joined: Fri 12 Jul 2013 16:51
Location: Maine

Re: Calling user Defined oracle functions using Code First

Post by phowe » Tue 07 Jan 2014 14:28

Post has a broken link and I think that document has what we need! This link is broken:

http://www.devart.com/blogs/dotconnect/ ... plate.html.

Can someone point me to a working link? Thanks!

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Calling user Defined oracle functions using Code First

Post by Shalex » Tue 07 Jan 2014 14:54

I have updated the link in my original post.

JIC: Entity Developer now supports Model-Defined Functions as well: http://blog.devart.com/model-defined-fu ... loper.html.

Post Reply