Base solution for your next web application
Open Closed

SQL Query through custom Repository #3093


User avatar
0
bilalhaidar created

Hi, In the case I am writing a custom method to query DB directly as I need to do a complicated query involving Pivot with dynamic pivot columns and multiple columns at the same time.

I am currently adding 2 filters on my query: TenantId and IsDeleted. Do I need to add anything else to make sure data retrieved is per Tenant?

Thanks Bilal


2 Answer(s)
  • User Avatar
    0
    alirizaadiyahsi created

    Hi,

    You are right, you don't need additional filter to base filtering...

  • User Avatar
    0
    bilalhaidar created

    Thanks :-)

    Are you a developer on the framework?