ansaurus

Question

Can I call a Stored Procedure from an EntityDataSource?

Answer 1

+3 A:

Try using the Function Import.

Right click on the EntitySet Name (the heading part)
Choose Add->Function Import

Here is a good blog post for you to check out. ADO.NET Entity Framework Tools: Stored Procedures, by Guy Burstein

Update: Sorry I missed the part about the EntityDataSource so I don't know of any property exposed to access a function import from the EDS, but your can try to use the CommandText property.

<asp:EntityDataSource ID="SolutionsDataSource" runat="server" 
    CommandText="DataModel.SearchFunction(@Keywords)"
    ConnectionString="name=AdventureWorksEntities">
    <CommandParameters>
        <asp:ControlParameter Name="Keywords" 
            ControlID="SearchTextbox" Type="String"/>
    </CommandParameters>
</asp:EntityDataSource>

Update: Well it seems that I have some bad news. After using Reflector to dive deep into the EntityDataSource. The EntityDataSourceView is constructed using QueryBuilderUtils.ConstructQuery, which then in turn calls context.CreateQuery<T>. What you would need to execute the function import is a call to context.ExecuteFunction<T>. There doesn't seem to be any support for the ExecuteFunction in this release, the blogs I was reading did mention that it was planned, but it didn't make it into this release, whether or not it will be in future releases I can't say.

That being said I would recommend using an ObjectDataSource, which you can construct in a way that still supports paging, sorting, etc. If you open an ObjectDataSource question on this topic send me a comment here and I'll take a look.

bendewey 2009-04-04 20:36:37

Thanks for the link, I read it through, and this I have. I can search via my SP, I just miss the part where I can bind that up to the GridView I have, via an EntityDataSource (if possible).

miccet 2009-04-04 20:48:51

I added an update

bendewey 2009-04-04 21:00:45

I tried to add the function to the CommandText, but it won't work. Landing on the error "The EntitySet 'SearchSolutions' is not defined in the EntityContainer 'solutioncottageEntities'., near multipart identifier."

miccet 2009-04-04 21:29:30

Try using DataModel.SearchFunction(@Keywords) for your CommandText.

bendewey 2009-04-04 22:13:28

Next error message: 'solutioncottageModel.SearchSolutions' cannot be resolved into a valid type constructor or function., near function, method or type constructor, line 1, column 37.Using: CommandText="solutioncottageModel.SearchSolutions(@SearchString)"

miccet 2009-04-04 22:29:35

Added an update.

bendewey 2009-04-05 01:07:37

I was using an ObjectDataSource together with a DataSet previously but was looking into switching to the Entity framework. Maybe there are better ways to accomplish what I'm doing here, but that's another question. I'll accept this as the answer and thanks for your extended research!

miccet 2009-04-05 12:14:14

ansaurus

tags:

views:

answers:

Can I call a Stored Procedure from an EntityDataSource?

related questions