storing WorkFlowRules (Workflows) & Rules in a db

[asulwer]

anyone using EF and RulesEngine models directly? my Workflows are stored as json in my db but what about storing the models directly in the db and interfacing with DbSet?

sorry about terminology here

[tisdalestar6git]

yes this is the table being used:
CREATE TABLE [dbo].[process_rule](
[process_rule_id] [bigint] IDENTITY(1,1) NOT NULL,
[execution_name] varchar NOT NULL,
[rule_name] varchar NOT NULL,
[create_datetime] datetime2 NOT NULL,
[success_event_num] [int] NOT NULL,
[error_message] varchar NULL,
[error_type] varchar NULL,
[rule_expression] varchar NULL,
[rule_expression_type] varchar NULL,
CONSTRAINT [process_rule_id_pkuc_idx] PRIMARY KEY CLUSTERED
(
[process_rule_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

[asulwer]

what i am asking is something a little different.

RulesEngine Models

i want to add all of these, codefirst, into my db. then use DbSet to access

[asulwer]

the models are already setup, i just to need to migrate them to my db. why cant i?

[abbasc52]

@asulwer We have a new demo app with EF integration - https://github.com/microsoft/RulesEngine/tree/main/demo/DemoApp.EFDataExample

You can check it out and see if it answers your question.

[asulwer]

this is exactly what i had in mind