>>>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 ?