All Words
Any Word
Exact Phrase
Partial Match
www.entityspaces.net
Developer Documentation
»
Dynamic Query
»
Custom Loads
Custom Loads
C#
public partial class EmployeesQuery: esEmployeesQuery { public bool CustomLoad() { Select(EmployeeID, FirstName, LastName, TitleOfCourtesy) .Where ( Or(LastName.Like("%A%"), LastName.Like("%O%")), this.BirthDate.Between("1/1/1940", "1/1/2006") ) .OrderBy(LastName.Descending, FirstName.Ascending); return this.Load(); } }
VB
Partial Public Class EmployeesQuery Inherits esEmployeesQuery Public Function CustomLoad() As Boolean Select(EmployeeID, FirstName, LastName, TitleOfCourtesy).Where(Or(LastName.Like("%A%"), LastName.Like("%O%")), Me.BirthDate.Between("1/1/1940", "1/1/2006")).OrderBy(LastName.Descending, FirstName.Ascending) Return Me.Load End Function End Class
Collapse All
|
Expand All
Developer Documentation
Getting Started
EntitySpaces 2009
EntitySpaces Providers
Entity
Collection
Custom Classes
Databinding
Dynamic Query
Join
Operator
Sub Operator
SubQuery
Arithmetic Expressions
Basic Group By
Basic Select
Conjunctions
Custom Loads
Distinct
Enumerations
Group By And Where Clause
Group By And OrderBy
Last Query
Load Stored Procedure
Paging
Query Caching
Top
Hierarchical Model
Metadata
Multi Provider Mode
Serialization
Transactions
Utility
WebServices