SQL server

Use SQL server as a backend state store

Dapr 在保存和检索状态时不会转换状态值。 Dapr requires all state store implementations to abide by a certain key format scheme (see Dapr state management spec. You can directly interact with the underlying store to manipulate the state data, such querying states, creating aggregated views and making backups.

1. Connect to SQL Server

The easiest way to connect to your SQL Server instance is to use the Azure Data Studio (Windows, macOS, Linux) or SQL Server Management Studio (Windows).

NOTE: The following samples use Azure SQL. When you configure an Azure SQL database for Dapr, you need to specify the exact table name to use. The follow samples assume you’ve already connected to the right database with a table named “states”.

2. 通过 App ID 列出键

To get all state keys associated with application “myapp”, use the query:

  1. SELECT * FROM states WHERE [Key] LIKE 'myapp||%'

The above query returns all rows with id containing “myapp||”, which is the prefix of the state keys.

3. 获取特定状态数据

To get the state data by a key “balance” for the application “myapp”, use the query:

  1. SELECT * FROM states WHERE [Key] = 'myapp||balance'

Then, read the Data field of the returned row.

要获取状态version/ETag ，请使用以下命令:

  1. SELECT [RowVersion] FROM states WHERE [Key] = 'myapp||balance'

4. Get filtered state data

To get all state data where the value “color” in json data equals to “blue”, use the query:

  1. SELECT * FROM states WHERE JSON_VALUE([Data], '$.color') = 'blue'

5. Read actor state

To get all the state keys associated with an actor with the instance ID “leroy” of actor type “cat” belonging to the application with ID “mypets”, use the command:

  1. SELECT * FROM states WHERE [Key] LIKE 'mypets||cat||leroy||%'

And to get a specific actor state such as “food”, use the command:

  1. SELECT * FROM states WHERE [Key] = 'mypets||cat||leroy||food'

警告 您不应手动更新或删除存储区中的状态。 所有写入和删除操作都应通过 Dapr 运行时完成。

Last modified January 1, 0001