Hi,

For each DB table we have some common fields like:

CompanyID: Indicates the owner of the record. UserID: Indicates the last user who had performed an action on the record. UserAction: Indicates the last action performed by the user on the record. LastModificationDate: Indicates the last modification date on the record.

These fields should be read-only for the application developer. Our core framework classes are responsible for manipulation of these fields.

I wonder if it might be feasible to implicitly assign a value to the specified fields before CRUD operations?

Is it possible to force LLBLGen to add an extra where clause to LINQ queries or the generated SQL commands to read current user's company id and filter table rows for the specified company?

Regards, Farzad Badili

Implicit Entity Field Assignment can be done in validation, specifically ValidateEntityBeforeSave.

Thanks for your answer.

What is your solution for select statements and reading data(LINQ and etc.)?

Did you check the Authorization feature?

I have many rows in my table and I would like to filter them for a specified CompanyID and then perform pagination on the result. I would like to perform these operations on the DB side not in the client. Is it possible with Authorization feature?

I'm working on a solution for this problem, please have a look at this and tell me your idea:

http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14583

I have many rows in my table and I would like to filter them for a specified CompanyID and then perform pagination on the result. I would like to perform these operations on the DB side not in the client. Is it possible with Authorization feature?

No, Authorization only works on client side.

I'm working on a solution for this problem, please have a look at this and tell me your idea: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14583

I've replied on that thread.