DocumentClient.CreateConflictQuery Method

Definition

Namespace:

Microsoft.Azure.Documents.Client

Assemblies:

Microsoft.Azure.DocumentDB.Core.dll, Microsoft.Azure.Documents.Client.dll

Packages:

Microsoft.Azure.DocumentDB v2.18.0, Microsoft.Azure.DocumentDB.Core v2.18.0

Overloads

CreateConflictQuery(Uri, SqlQuerySpec, FeedOptions)	Extension method to create a query for conflicts in the Azure Cosmos DB service.
CreateConflictQuery(Uri, String, FeedOptions)	Extension method to create a query for conflicts in the Azure Cosmos DB service.
CreateConflictQuery(String, String, FeedOptions)	Overloaded. This method creates a query for conflicts under a collection in an Azure Cosmos DB service. It returns an IQueryable{Conflict}.
CreateConflictQuery(Uri, FeedOptions)	Extension method to create a query for conflicts in the Azure Cosmos DB service.
CreateConflictQuery(String, FeedOptions)	Overloaded. This method creates a query for conflicts under a collection in an Azure Cosmos DB service. It returns An IOrderedQueryable{Conflict}.
CreateConflictQuery(String, SqlQuerySpec, FeedOptions)	Overloaded. This method creates a query for conflicts under a collection in an Azure Cosmos DB database with parameterized values. It returns an IQueryable{dynamic}. For more information on preparing SQL statements with parameterized values, please see SqlQuerySpec.

CreateConflictQuery(Uri, SqlQuerySpec, FeedOptions)

Extension method to create a query for conflicts in the Azure Cosmos DB service.

public System.Linq.IQueryable<dynamic> CreateConflictQuery (Uri conflictsUri, Microsoft.Azure.Documents.SqlQuerySpec querySpec, Microsoft.Azure.Documents.Client.FeedOptions feedOptions = default);

abstract member CreateConflictQuery : Uri * Microsoft.Azure.Documents.SqlQuerySpec * Microsoft.Azure.Documents.Client.FeedOptions -> System.Linq.IQueryable<obj>
override this.CreateConflictQuery : Uri * Microsoft.Azure.Documents.SqlQuerySpec * Microsoft.Azure.Documents.Client.FeedOptions -> System.Linq.IQueryable<obj>

Public Function CreateConflictQuery (conflictsUri As Uri, querySpec As SqlQuerySpec, Optional feedOptions As FeedOptions = Nothing) As IQueryable(Of Object)

Parameters

conflictsUri

Uri

the URI to the conflicts.

querySpec

SqlQuerySpec

The sql query.

feedOptions

FeedOptions

The options for processing the query results feed.

Returns

IQueryable<Object>

The query result set.

Implements

CreateConflictQuery(Uri, SqlQuerySpec, FeedOptions)

CreateConflictQuery(Uri, String, FeedOptions)

Extension method to create a query for conflicts in the Azure Cosmos DB service.

public System.Linq.IQueryable<dynamic> CreateConflictQuery (Uri conflictsUri, string sqlExpression, Microsoft.Azure.Documents.Client.FeedOptions feedOptions = default);

abstract member CreateConflictQuery : Uri * string * Microsoft.Azure.Documents.Client.FeedOptions -> System.Linq.IQueryable<obj>
override this.CreateConflictQuery : Uri * string * Microsoft.Azure.Documents.Client.FeedOptions -> System.Linq.IQueryable<obj>

Public Function CreateConflictQuery (conflictsUri As Uri, sqlExpression As String, Optional feedOptions As FeedOptions = Nothing) As IQueryable(Of Object)

Parameters

conflictsUri

Uri

the URI to the conflicts.

sqlExpression

String

The sql query.

feedOptions

FeedOptions

The options for processing the query results feed.

Returns

IQueryable<Object>

The query result set.

Implements

CreateConflictQuery(Uri, String, FeedOptions)

CreateConflictQuery(String, String, FeedOptions)

Overloaded. This method creates a query for conflicts under a collection in an Azure Cosmos DB service. It returns an IQueryable{Conflict}.

public System.Linq.IQueryable<dynamic> CreateConflictQuery (string collectionLink, string sqlExpression, Microsoft.Azure.Documents.Client.FeedOptions feedOptions = default);

abstract member CreateConflictQuery : string * string * Microsoft.Azure.Documents.Client.FeedOptions -> System.Linq.IQueryable<obj>
override this.CreateConflictQuery : string * string * Microsoft.Azure.Documents.Client.FeedOptions -> System.Linq.IQueryable<obj>

Public Function CreateConflictQuery (collectionLink As String, sqlExpression As String, Optional feedOptions As FeedOptions = Nothing) As IQueryable(Of Object)

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

IQueryable<Object>

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

Implements

CreateConflictQuery(String, String, FeedOptions)

Examples

This example below queries for conflicts by id.

var query = new SqlQuerySpec("SELECT * FROM conflicts c WHERE c.id = @id", new SqlParameterCollection(new SqlParameter[] { new SqlParameter { Name = "@id", Value = "summary" }}));
Conflict conflict = client.CreateConflictQuery(collectionLink, query).AsEnumerable().FirstOrDefault();

Remarks

Refer to https://docs.microsoft.com/azure/cosmos-db/sql-query-getting-started/ for syntax and examples.

See also

• Conflict
• IDocumentQuery

CreateConflictQuery(Uri, FeedOptions)

Extension method to create a query for conflicts in the Azure Cosmos DB service.

public System.Linq.IOrderedQueryable<Microsoft.Azure.Documents.Conflict> CreateConflictQuery (Uri conflictsUri, Microsoft.Azure.Documents.Client.FeedOptions feedOptions = default);

abstract member CreateConflictQuery : Uri * Microsoft.Azure.Documents.Client.FeedOptions -> System.Linq.IOrderedQueryable<Microsoft.Azure.Documents.Conflict>
override this.CreateConflictQuery : Uri * Microsoft.Azure.Documents.Client.FeedOptions -> System.Linq.IOrderedQueryable<Microsoft.Azure.Documents.Conflict>

Public Function CreateConflictQuery (conflictsUri As Uri, Optional feedOptions As FeedOptions = Nothing) As IOrderedQueryable(Of Conflict)

Parameters

conflictsUri

Uri

the URI to the conflicts.

feedOptions

FeedOptions

The options for processing the query results feed.

Returns

IOrderedQueryable<Conflict>

The query result set.

Implements

CreateConflictQuery(Uri, FeedOptions)

CreateConflictQuery(String, FeedOptions)

Overloaded. This method creates a query for conflicts under a collection in an Azure Cosmos DB service. It returns An IOrderedQueryable{Conflict}.

public System.Linq.IOrderedQueryable<Microsoft.Azure.Documents.Conflict> CreateConflictQuery (string collectionLink, Microsoft.Azure.Documents.Client.FeedOptions feedOptions = default);

abstract member CreateConflictQuery : string * Microsoft.Azure.Documents.Client.FeedOptions -> System.Linq.IOrderedQueryable<Microsoft.Azure.Documents.Conflict>
override this.CreateConflictQuery : string * Microsoft.Azure.Documents.Client.FeedOptions -> System.Linq.IOrderedQueryable<Microsoft.Azure.Documents.Conflict>

Public Function CreateConflictQuery (collectionLink As String, Optional feedOptions As FeedOptions = Nothing) As IOrderedQueryable(Of Conflict)

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

IOrderedQueryable<Conflict>

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

Implements

CreateConflictQuery(String, FeedOptions)

Examples

This example below queries for conflicts by id.

Conflict conflict = client.CreateConflictQuery(collectionLink).Where(c => c.Id == "summary").AsEnumerable().FirstOrDefault();

See also

• Conflict
• IDocumentQuery

CreateConflictQuery(String, SqlQuerySpec, FeedOptions)

Overloaded. This method creates a query for conflicts under a collection in an Azure Cosmos DB database 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> CreateConflictQuery (string collectionLink, Microsoft.Azure.Documents.SqlQuerySpec querySpec, Microsoft.Azure.Documents.Client.FeedOptions feedOptions = default);

abstract member CreateConflictQuery : string * Microsoft.Azure.Documents.SqlQuerySpec * Microsoft.Azure.Documents.Client.FeedOptions -> System.Linq.IQueryable<obj>
override this.CreateConflictQuery : string * Microsoft.Azure.Documents.SqlQuerySpec * Microsoft.Azure.Documents.Client.FeedOptions -> System.Linq.IQueryable<obj>

Public Function CreateConflictQuery (collectionLink As String, querySpec As SqlQuerySpec, Optional feedOptions As FeedOptions = Nothing) As IQueryable(Of Object)

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

IQueryable<Object>

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

Implements

CreateConflictQuery(String, SqlQuerySpec, FeedOptions)

Examples

This example below queries for conflicts by id.

var query = new SqlQuerySpec("SELECT * FROM conflicts c WHERE c.id = @id", new SqlParameterCollection(new SqlParameter[] { new SqlParameter { Name = "@id", Value = "summary" }}));
dynamic conflict = client.CreateConflictQuery<dynamic>(collectionLink, query).AsEnumerable().FirstOrDefault();

Remarks

Refer to https://docs.microsoft.com/azure/cosmos-db/sql-query-getting-started/ for syntax and examples.

See also

• Document
• IDocumentQuery