Chili.Opf3 Send comments on this topic.
SqlQueryBuilder Class
See Also  Members   Example 
Chili.Opf3.Query Namespace : SqlQueryBuilder Class




A class that creates an instance of an SqlQuery class.

Syntax

Visual Basic (Declaration) 
Public NotInheritable Class SqlQueryBuilder
Visual Basic (Usage)Copy Code
Dim instance As SqlQueryBuilder
C# 
public sealed class SqlQueryBuilder
Managed Extensions for C++ 
public __gc __sealed class SqlQueryBuilder
C++/CLI 
public ref class SqlQueryBuilder sealed

Example

The following example shows how to use SqlQueryBuilder in your application.
C#Copy Code
// ... Other code 
 
SqlQueryBuilder sqb = new SqlQueryBuilder("select * from USERS"); 
sqb.AddConditionIfParameterNotNull("lower(LAST_NAME) like {0}", lastName); 
sqb.AddConditionIfParameterNotNull("lower(FIRST_NAME) like {0}", firstName); 
 
ObjectSet<Call> os = context.GetObjectSet<Call>(sqb.ToSqlQuery()); 
 
// ... Other code.

Remarks

This class creates an instance of an SqlQuery class. It allows to specify the different items that can be added to an SqlQuery. For more information about the SqlQuery, please consult the documentation of that class.

Inheritance Hierarchy

System.Object
   Chili.Opf3.Query.SqlQueryBuilder

Requirements

Namespace: Chili.Opf3.Query

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

Assembly: Chili.Opf3 (in Chili.Opf3.dll)

See Also