WhereParameters cannot be specified unless AutoGenerateWhere==true or Where is specified.

[Charles]

Hi,

Am currently evaluating RAD Controls, and haviong problems with a master/detail grid.

I have two entity data sets. Master=edsExpenseClaim Detail=edsExpenseDetail, the common ID between the two is ExpenseClaimID (a bigint in SQLServer database)

When browsing the grid the master grid is displayed correctly but when I expand to see the detail I get the following error:

Server Error in '/' Application.
--------------------------------------------------------------------------------


WhereParameters cannot be specified unless AutoGenerateWhere==true or Where is specified. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 


Exception Details: System.InvalidOperationException: WhereParameters cannot be specified unless AutoGenerateWhere==true or Where is specified.


Source Error: 


An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

The page source is:

<%@ Page Title="" Language="C#" MasterPageFile="~/Accounts.Master" AutoEventWireup="true" CodeBehind="myClaims.aspx.cs" Inherits="Accounts.myClaims" %>
<asp:Content ID="Content1" ContentPlaceHolderID="title" runat="server">
    Accounts - My Expense Claims
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" 
        AllowPaging="True" AllowSorting="True" CellSpacing="0" 
        DataSourceID="edsExpenseClaim" GridLines="None">
        <ClientSettings>
            <Scrolling AllowScroll="True" UseStaticHeaders="True" />
        </ClientSettings>
<MasterTableView AllowAutomaticDeletes="True" AllowAutomaticInserts="True" 
            AllowAutomaticUpdates="True" DataKeyNames="ExpenseClaim_ID" 
            DataSourceID="edsExpenseClaim" AutoGenerateColumns="False">
    <DetailTables>
        <telerik:GridTableView runat="server" DataKeyNames="ExpenseDetail_ID" 
            DataSourceID="edsExpenseDetail" AllowAutomaticDeletes="True" 
            AllowAutomaticInserts="True" AllowAutomaticUpdates="True">
            <ParentTableRelation>
                <telerik:GridRelationFields DetailKeyField="ExpenseClaim_ID" 
                    MasterKeyField="ExpenseClaim_ID" />
            </ParentTableRelation>
            <CommandItemSettings ExportToPdfText="Export to PDF" />
            <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
                <HeaderStyle Width="20px" />
            </RowIndicatorColumn>
            <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">
                <HeaderStyle Width="20px" />
            </ExpandCollapseColumn>
            <EditFormSettings>
                <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                </EditColumn>
            </EditFormSettings>
        </telerik:GridTableView>
    </DetailTables>
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>


<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>


<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column" 
        Visible="True">
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>


    <Columns>
        <telerik:GridBoundColumn DataField="ExpenseClaim_ID" DataType="System.Int64" 
            FilterControlAltText="Filter ExpenseClaim_ID column" 
            HeaderText="ExpenseClaim_ID" ReadOnly="True" SortExpression="ExpenseClaim_ID" 
            UniqueName="ExpenseClaim_ID">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Claimant_ID" DataType="System.Int64" 
            FilterControlAltText="Filter Claimant_ID column" HeaderText="Claimant_ID" 
            SortExpression="Claimant_ID" UniqueName="Claimant_ID">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ClaimCurrency_ID" DataType="System.Int64" 
            FilterControlAltText="Filter ClaimCurrency_ID column" 
            HeaderText="ClaimCurrency_ID" SortExpression="ClaimCurrency_ID" 
            UniqueName="ClaimCurrency_ID">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ClaimStatus_ID" DataType="System.Int64" 
            FilterControlAltText="Filter ClaimStatus_ID column" HeaderText="ClaimStatus_ID" 
            SortExpression="ClaimStatus_ID" UniqueName="ClaimStatus_ID">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ClaimDate" DataType="System.DateTime" 
            FilterControlAltText="Filter ClaimDate column" HeaderText="ClaimDate" 
            SortExpression="ClaimDate" UniqueName="ClaimDate">
        </telerik:GridBoundColumn>
    </Columns>


<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>
</MasterTableView>


<FilterMenu EnableImageSprites="False"></FilterMenu>


<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>
    </telerik:RadGrid>
    <asp:EntityDataSource ID="edsExpenseClaim" runat="server" 
        ConnectionString="name=AccountsEntities" 
        DefaultContainerName="AccountsEntities" EnableDelete="True" 
        EnableFlattening="False" EnableInsert="True" EnableUpdate="True" 
        EntitySetName="ExpenseClaims">
    </asp:EntityDataSource>
    <asp:EntityDataSource ID="edsExpenseDetail" runat="server" 
        ConnectionString="name=AccountsEntities" 
        DefaultContainerName="AccountsEntities" EnableDelete="True" 
        EnableFlattening="False" EnableInsert="True" EnableUpdate="True" 
        EntitySetName="ExpenseDetails"
        Where="it.ExpenseDetail.ExpenseClaim_ID = @ExpenseClaim_ID">
        <WhereParameters>
            <asp:SessionParameter name="ExpenseClaim_ID" Type="Int64" />
        </WhereParameters>
    </asp:EntityDataSource>
</asp:Content>

Any pointers to a solution would be most appreciated!!!

Cheers,

Charles

[Charles]

I am sure I tried this before, without luck... But, as suggested in the error message changing:

 <asp:EntityDataSource ID="edsExpenseDetail" runat="server" 
        ConnectionString="name=AccountsEntities" 
        DefaultContainerName="AccountsEntities" EnableDelete="True" 
        EnableFlattening="False" EnableInsert="True" EnableUpdate="True" 
        EntitySetName="ExpenseDetails"
        Where="it.ExpenseDetail.ExpenseClaim_ID = @ExpenseClaim_ID">
        <WhereParameters>
            <asp:SessionParameter name="ExpenseClaim_ID" Type="Int64" />
        </WhereParameters>
    </asp:EntityDataSource>

to 
 <asp:EntityDataSource ID="edsExpenseDetail" runat="server" 
        ConnectionString="name=AccountsEntities" 
        DefaultContainerName="AccountsEntities" EnableDelete="True" 
        EnableFlattening="False" EnableInsert="True" EnableUpdate="True" 
        EntitySetName="ExpenseDetails"
        Where="it.ExpenseDetail.ExpenseClaim_ID = @ExpenseClaim_ID"
        AutoGenerateWhere="true">
        <WhereParameters>
            <asp:SessionParameter name="ExpenseClaim_ID" Type="Int64" />
        </WhereParameters>
    </asp:EntityDataSource>


fixed the problem...