DocumentQueryable.CreateDatabaseQuery Method

Namespace:   Microsoft.Azure.Documents.Linq
Assembly:  Microsoft.Azure.Documents.Client (in Microsoft.Azure.Documents.Client.dll)

Overload List

	Name	Description
	CreateDatabaseQuery(DocumentClient, FeedOptions)	Overloaded. This method creates a query for database resources under an account. It returns An IOrderedQueryable{Database>.
	CreateDatabaseQuery(DocumentClient, SqlQuerySpec, FeedOptions)	Overloaded. This method creates a query for database resources under an account by 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.
	CreateDatabaseQuery(DocumentClient, String, FeedOptions)	Overloaded. This method creates a query for database resources under an account by using a SQL statement. It returns an IQueryable{dynamic}.

See Also

DocumentQueryable Class
Microsoft.Azure.Documents.Linq Namespace

Return to top

DocumentQueryable.CreateDatabaseQuery Method (DocumentClient, FeedOptions)

Overloaded. This method creates a query for database resources under an account. It returns An IOrderedQueryable{Database>.

Syntax

public static IOrderedQueryable<Database> CreateDatabaseQuery(
    this DocumentClient client,
    FeedOptions feedOptions = null
)

public:
[ExtensionAttribute]
static IOrderedQueryable<Database^>^ CreateDatabaseQuery(
    DocumentClient^ client,
    FeedOptions^ feedOptions = null
)

<ExtensionAttribute>
Public Shared Function CreateDatabaseQuery (
    client As DocumentClient,
    feedOptions As FeedOptions
) As IOrderedQueryable(Of Database)

Parameters

• client
  Type: Microsoft.Azure.Documents.Client.DocumentClient

  the DocumentClient instance to execute the query.

• feedOptions
  Type: Microsoft.Azure.Documents.Client.FeedOptions

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

Return Value

Type: System.Linq.IOrderedQueryable<Database>

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

Examples

This example below queries for databases by id.

Database database = client.CreateDatabaseQuery().Where(d => d.Id == "mydb").AsEnumerable().FirstOrDefault();

See Also

Database
IDocumentQuery

Return to top

DocumentQueryable.CreateDatabaseQuery Method (DocumentClient, SqlQuerySpec, FeedOptions)

Overloaded. This method creates a query for database resources under an account by 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.

Syntax

public static IQueryable<object> CreateDatabaseQuery(
    this DocumentClient client,
    SqlQuerySpec querySpec,
    FeedOptions feedOptions = null
)

public:
[ExtensionAttribute]
static IQueryable<Object^>^ CreateDatabaseQuery(
    DocumentClient^ client,
    SqlQuerySpec^ querySpec,
    FeedOptions^ feedOptions = null
)

<ExtensionAttribute>
Public Shared Function CreateDatabaseQuery (
    client As DocumentClient,
    querySpec As SqlQuerySpec,
    feedOptions As FeedOptions
) As IQueryable(Of Object)

Parameters

• client
  Type: Microsoft.Azure.Documents.Client.DocumentClient

  the DocumentClient instance to execute the query.

• querySpec
  Type: Microsoft.Azure.Documents.SqlQuerySpec

  The SqlQuerySpec instance containing the SQL expression.

• feedOptions
  Type: Microsoft.Azure.Documents.Client.FeedOptions

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

Return Value

Type: System.Linq.IQueryable<Object>

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 https://azure.microsoft.com/documentation/articles/documentdb-sql-query/ for syntax and examples.

Examples

This example below queries for databases by id.

var query = new SqlQuerySpec("SELECT * FROM dbs d WHERE d.id = @id",
    new SqlParameterCollection(new SqlParameter[] { new SqlParameter { Name = "@id", Value = "mydb" }}));
dynamic database = client.CreateDatabaseQuery<dynamic>(query).AsEnumerable().FirstOrDefault();

See Also

Database
IDocumentQuery

Return to top

DocumentQueryable.CreateDatabaseQuery Method (DocumentClient, String, FeedOptions)

Overloaded. This method creates a query for database resources under an account by using a SQL statement. It returns an IQueryable{dynamic}.

Syntax

public static IQueryable<object> CreateDatabaseQuery(
    this DocumentClient client,
    string sqlExpression,
    FeedOptions feedOptions = null
)

public:
[ExtensionAttribute]
static IQueryable<Object^>^ CreateDatabaseQuery(
    DocumentClient^ client,
    String^ sqlExpression,
    FeedOptions^ feedOptions = null
)

<ExtensionAttribute>
Public Shared Function CreateDatabaseQuery (
    client As DocumentClient,
    sqlExpression As String,
    feedOptions As FeedOptions
) As IQueryable(Of Object)

Parameters

• client
  Type: Microsoft.Azure.Documents.Client.DocumentClient

  the DocumentClient instance to execute the query.

• sqlExpression
  Type: System.String

  The SQL statement.

• feedOptions
  Type: Microsoft.Azure.Documents.Client.FeedOptions

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

Return Value

Type: System.Linq.IQueryable<Object>

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 https://azure.microsoft.com/documentation/articles/documentdb-sql-query/ for syntax and examples.

Examples

This example below queries for databases by id.

Database database = client.CreateDatabaseQuery("SELECT * FROM dbs d WHERE d.id = 'mydb'").AsEnumerable().FirstOrDefault();

See Also

Database
IDocumentQuery

Return to top