dotnet/orleans

Is AdoNetStorage provider has 'DeleteStateOnClear' or any alternatives?

Open

#8,059 创建于 2022年10月25日

在 GitHub 查看
 (2 评论) (1 反应) (0 负责人)C# (10,777 star) (2,123 fork)batch import
area-persistencehelp wanted

描述

Hello,

We use SQL Server in our system, hence we use AdoNetStorage provider for persistence according documentation: https://learn.microsoft.com/en-us/dotnet/orleans/grains/grain-persistence/relational-storage

When we trying to clear state using "ClearStateAsync" with AdoNet storage provider it just NULL state of the record in database w/o removing it.

Does MS Orleans have any ways to completely remove a record from a SQL Server database?

I see Azure storage provider has option 'DeleteStateOnClear', but AdoNet not.

贡献者指南

技术栈
csharp
领域
backenddatabase
议题类型
feature
难度面向新贡献者的预计实现难度，1 表示很小改动，5 表示专家级工作。
3
预计时间有经验贡献者完成调查、实现、测试并准备 pull request 的粗略时间范围。
half day
活动状态议题当前的可参与程度：新鲜、活跃、陈旧、阻塞或等待维护者输入。
needs maintainer response
清晰度议题是否清楚说明期望改动、验收标准和下一步。
mostly clear
前置要求
Orleans grain persistenceADO.NET storage provider
新手友好度1-100 的估计分数，表示该议题对首次贡献者的友好程度。
40
研究方向
Investigate the AdoNetStorage provider implementation in Orleans, specifically the ClearStateAsync method. Look at the Azure storage provider's DeleteStateOnClear option for comparison. Check the Orleans documentation and source code in the dotnet/orleans repository, focusing on the storage provider files (e.g., AdoNetGrainStorage.cs). The issue asks whether a similar feature exists or can be added; a contributor should explore the codebase to understand the current behavior and propose a solution.