EntityDataSource and Custom Stored Procedure Usage For GridView

 First of all let me say I not using the most currently release version, but I using the most current previous as you can hopefully see in my example that has allowed me to use EntityDataSource. I searched high and low here, but was not able to see example using EntityDataSource for Gridview using Custom View or Procedure?

 I created my stored procedure _Orders_SelectWithNull and included in codesmith. This is all working great and can see available in my intellisense in my code behind:

DataRepository.OrdersProvider.SelectWithNull(int opt1, int opt2, int op3)

 I verified everything working with just using OrdersProvider, How do I reference the custom method I just added on the OrdersProvider and also send it the storeprocedure/method parameters it's expecting

How do you reference custom provider entity?

 <data:EntityDataSource ID="OrdersDataSource" runat="server"
ProviderName="OrdersProvider"
EntityTypeName="exampleDB.BLL.OrdersProvider, exampleDB.BLL"
SelectMethod="GetPaged"
EnablePaging="True"
EnableSorting="True">

Once referenced? use?

<data:DataParameter

data:DataParameter

<data:DataParameter

data:DataParameter

<data:DataParameter

data:DataParameter

<data:DataParameter

data:DataParameter

<data:DataParameter

If your csp is returning a dataset have a look at my tip here http://community.codesmithtools.com/forums/thread/18699.aspx 

swin

That tip is great, thanks. Here is what I ended up doing before reading your post. Hope it helps the next person. You are correct, the automatic paging and sorting with gridview only work with a sqldatasource or objectdatasource as I found out. Otherwise you have to make your own events methods for OnPaging and OnSorting. The paging event is simple, but the sorting gets messy and very manual filtering. The builtin paging and sorting events run much better.

<asp:SqlDataSource id="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:netTiersConnectionString%>" SelectCommandType="StoredProcedure" SelectCommand="_ProjectItems_SelectProjectItemsStatusByProjectIDLocIDS">
<SelectParameters>
<asp:Parameter Direction=Input DefaultValue=0 Name="Param1" Type="Int32" />
<asp:Parameter Direction=input DefaultValue=0 Name="Param2" Type="Int32" />
<asp:Parameter Direction=input DefaultValue=0 Name="Param3" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>