>>>>Hi,
>>>>
>>>>I am modifying a web page to use a different set of data for a DevExpress ASPXGridView control.
>>>>I created the new view, then created the new LINQ to SQL class, just as I remember doing for the previous data.
>>>>Now I am getting this error and have no idea what is wrong:
>>>>
>>>>

 Unable to obtain IQueryable instance from 'RESREPRICER.Web.DataClassesTransactionsSuccessDataContext'.'viewTransactionsSuccess' or Selecting event
>>>>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: Unable to obtain IQueryable instance from 'RESREPRICER.Web.DataClassesTransactionsSuccessDataContext'.'viewTransactionsSuccess' or Selecting event
>>>>
>>>>Source Error:
>>>>
>>>>
>>>>Line 15:             if (!IsPostBack)
>>>>Line 16:             {
>>>>Line 17:                 ASPxGridViewMain.ExpandRow(0);
>>>>Line 18:             }
>>>>Line 19:         }
>>>>
>>>>
>>>>Source File: D:\Development\VS2010\RESREPRICER_asp4\ReportAdmin1Success.aspx.cs    Line: 17
>>>>
>>>>Stack Trace:
>>>>
>>>>
>>>>[InvalidOperationException: Unable to obtain IQueryable instance from 'RESREPRICER.Web.DataClassesTransactionsSuccessDataContext'.'viewTransactionsSuccess' or Selecting event]
>>>>   DevExpress.Data.Linq.LinqServerModeDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +3966819
>>>>   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +22
>>>>   DevExpress.Web.Internal.DataHelper.PerformSelect() +222
>>>>   DevExpress.Web.Internal.GridDataHelper.PerformSelect() +286
>>>>   DevExpress.Web.ASPxDataWebControlBase.PerformSelect(String dataHelperName) +29
>>>>   DevExpress.Web.ASPxGridBase.DataBindNoControls() +82
>>>>   DevExpress.Web.ASPxGridView.ExpandRow(Int32 visibleIndex) +16
>>>>   RESREPRICER.Web.ReportAdmin1Success.Page_Load(Object sender, EventArgs e) in D:\Development\VS2010\RESREPRICER_asp4\ReportAdmin1Success.aspx.cs:17
>>>>   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
>>>>   System.Web.UI.Control.OnLoad(EventArgs e) +95
>>>>   System.Web.UI.Control.LoadRecursive() +59
>>>>   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +678
>>>>
>>>>
>>>>Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.2623.0

>>>>
>>>>Can anyone help me understand this?
>>>
>>>https://www.devexpress.com/Support/Center/Question/Details/Q586117/aspxgridview-unable-to-obtain-iqueryable-instance-from-dataclassesdatacontext1-orders-or
>>
>>I've worked out what I was doing wrong, but have no idea why!
>>
>>When I look at the DataClass the view name is viewTransactionsSuccess.
>>However, if I write code like this:
>>
>>

            RESREPRICER.Web.DataClassesTransactionsSuccessDataContext db = new DataClassesTransactionsSuccessDataContext();
>>            e.KeyExpression = "GUID";
>>            e.QueryableSource = from viewTransaction in db.viewTransactionsSuccesses
>>                                select new
>>                                {

>>
>>Note that the name has magically changed to viewTransactionsSuccesses
>>
>>So once I changed my aspx markup to refer to that name, it works.
>>
>>I have no idea what is going on here.
>
>I think that's the code generator pluralizing the collection of viewTransactionSuccess ?

Makes sense, but where in the interface do I find that setting? The only place I encountered it was when I wrote the code and used intellisense.