LinqServerModeDataSourceSelectEventArgs.QueryableSource Property

Gets or sets the queryable data source.

Namespace: DevExpress.Data.Linq

Assembly: DevExpress.Web.v20.2.dll

NuGet Package: DevExpress.Web

Declaration

C#

public IQueryable QueryableSource { get; set; }

VB.NET

Public Property QueryableSource As IQueryable

Property Value

Type	Description
IQueryable	An object that implements the IQueryable interface.

Example

The following example illustrates how to use the LinqServerModeDataSourceSelectEventArgs.QueryableSource property.

C#

protected void EntityServerModeDataSource1_Selecting(object sender, DevExpress.Data.Linq.LinqServerModeDataSourceSelectEventArgs e) {
    var db = new YourDataContext();
    e.KeyExpression = "ID_FIELD_FROM_YOUR_TABLE";
    e.QueryableSource = db.Products;
    //or
    e.QueryableSource = db.Products.Where(p=>p.Price > 10);
    //or other linq query
}

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the QueryableSource property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

gridview-how-to-define-calculated-fields-in-the-server-mode-webforms/CS/CalculatedFieldsInServerModeWebForms/Default.aspx.cs#L20

CalculatedFieldsTestEntities db = new CalculatedFieldsTestEntities();
e.QueryableSource = db.CustomProducts(30, new DateTime(2018, 5, 16));
e.KeyExpression = "Id";

VB.NET

gridview-how-to-define-calculated-fields-in-the-server-mode-webforms/VB/CalculatedFieldsInServerModeWebForms/Default.aspx.vb#L18

Dim db As New CalculatedFieldsTestEntities()
e.QueryableSource = db.CustomProducts(30, New DateTime(2018, 5, 16))
e.KeyExpression = "Id"