DocumentClient.CreateStoredProcedureQuery Method

Definition

Overloads

CreateStoredProcedureQuery(String, FeedOptions)

Overloaded. This method creates a query for stored procedures under a collection in an Azure DocumentDB database service. It returns An IOrderedQueryable{StoredProcedure}.

CreateStoredProcedureQuery(Uri, FeedOptions)

Extension method to create query for stored procedures in the Azure DocumentDB database service.

CreateStoredProcedureQuery(String, SqlQuerySpec, FeedOptions)

Overloaded. This method creates a query for stored procedures under a collection in an Azure DocumentDB database using a SQL statement using a SQL statement with parameterized values. It returns an IQueryable{dynamic}. For more information on preparing SQL statements with parameterized values, please see SqlQuerySpec.

CreateStoredProcedureQuery(String, String, FeedOptions)

Overloaded. This method creates a query for stored procedures under a collection in an Azure DocumentDB database using a SQL statement. It returns an IQueryable{dynamic}.

CreateStoredProcedureQuery(Uri, SqlQuerySpec, FeedOptions)

Extension method to create query for stored procedures in the Azure DocumentDB database service.

CreateStoredProcedureQuery(Uri, String, FeedOptions)

Extension method to create query for stored procedures in the Azure DocumentDB database service.

CreateStoredProcedureQuery(String, FeedOptions)

Overloaded. This method creates a query for stored procedures under a collection in an Azure DocumentDB database service. It returns An IOrderedQueryable{StoredProcedure}.

public System.Linq.IOrderedQueryable<Microsoft.Azure.Documents.StoredProcedure> CreateStoredProcedureQuery (string collectionLink, Microsoft.Azure.Documents.Client.FeedOptions feedOptions = null);
Parameters
collectionLink
String

The link to the parent collection resource.

feedOptions
FeedOptions

The options for processing the query result feed. For details, see FeedOptions

Returns

An IOrderedQueryable{StoredProcedure} that can evaluate the query with the provided SQL statement.

CreateStoredProcedureQuery(Uri, FeedOptions)

Extension method to create query for stored procedures in the Azure DocumentDB database service.

public System.Linq.IOrderedQueryable<Microsoft.Azure.Documents.StoredProcedure> CreateStoredProcedureQuery (Uri storedProceduresUri, Microsoft.Azure.Documents.Client.FeedOptions feedOptions = null);
Parameters
storedProceduresUri
Uri

the URI to the stored procedures.

feedOptions
FeedOptions

The options for processing the query results feed.

Returns

The query result set.

CreateStoredProcedureQuery(String, SqlQuerySpec, FeedOptions)

Overloaded. This method creates a query for stored procedures under a collection in an Azure DocumentDB database using a SQL statement using a SQL statement with parameterized values. It returns an IQueryable{dynamic}. For more information on preparing SQL statements with parameterized values, please see SqlQuerySpec.

public System.Linq.IQueryable<dynamic> CreateStoredProcedureQuery (string collectionLink, Microsoft.Azure.Documents.SqlQuerySpec querySpec, Microsoft.Azure.Documents.Client.FeedOptions feedOptions = null);
Parameters
collectionLink
String

The link to the parent collection resource.

querySpec
SqlQuerySpec

The SqlQuerySpec instance containing the SQL expression.

feedOptions
FeedOptions

The options for processing the query result feed. For details, see FeedOptions

Returns

An IQueryable{dynamic} that can evaluate the query with the provided SQL statement.

Remarks

Refer to https://msdn.microsoft.com/en-us/library/azure/dn782250.aspx and http://azure.microsoft.com/documentation/articles/documentdb-sql-query/ for syntax and examples.

CreateStoredProcedureQuery(String, String, FeedOptions)

Overloaded. This method creates a query for stored procedures under a collection in an Azure DocumentDB database using a SQL statement. It returns an IQueryable{dynamic}.

public System.Linq.IQueryable<dynamic> CreateStoredProcedureQuery (string collectionLink, string sqlExpression, Microsoft.Azure.Documents.Client.FeedOptions feedOptions = null);
Parameters
collectionLink
String

The link to the parent collection resource.

sqlExpression
String

The SQL statement.

feedOptions
FeedOptions

The options for processing the query result feed. For details, see FeedOptions

Returns

An IQueryable{dynamic} that can evaluate the query with the provided SQL statement.

Remarks

Refer to https://msdn.microsoft.com/en-us/library/azure/dn782250.aspx and http://azure.microsoft.com/documentation/articles/documentdb-sql-query/ for syntax and examples.

CreateStoredProcedureQuery(Uri, SqlQuerySpec, FeedOptions)

Extension method to create query for stored procedures in the Azure DocumentDB database service.

public System.Linq.IQueryable<dynamic> CreateStoredProcedureQuery (Uri storedProceduresUri, Microsoft.Azure.Documents.SqlQuerySpec querySpec, Microsoft.Azure.Documents.Client.FeedOptions feedOptions = null);
Parameters
storedProceduresUri
Uri

the URI to the stored procedures.

querySpec
SqlQuerySpec

The sql query.

feedOptions
FeedOptions

The options for processing the query results feed.

Returns

The query result set.

CreateStoredProcedureQuery(Uri, String, FeedOptions)

Extension method to create query for stored procedures in the Azure DocumentDB database service.

public System.Linq.IQueryable<dynamic> CreateStoredProcedureQuery (Uri storedProceduresUri, string sqlExpression, Microsoft.Azure.Documents.Client.FeedOptions feedOptions = null);
Parameters
storedProceduresUri
Uri

the URI to the stored procedures.

sqlExpression
String

The sql query.

feedOptions
FeedOptions

The options for processing the query results feed.

Returns

The query result set.