Build a generic C# global query filter in EF Core 6

₹600-1500 INR

Closed

Posted

over 1 year ago

₹600-1500 INR

Paid on delivery

I'm looking for developer(s) to build a generic global query filter in c# using EntityFramework Core 6. The method must be stateless and allow different users to pass through. Example: Generic method filters all Entities in application to allow [login to view URL] = userId variable. Instead of the following snippet, create a generic filter that applies property TenantId and IsDeleted on all entities in the C# project. The expression filter must support variables (ex. different TenantId for different users and cannot be static). ``` [login to view URL]<Blog>().HasQueryFilter(b => [login to view URL]<string>(b, "_tenantId") == _tenantId); [login to view URL]<Post>().HasQueryFilter(p => ![login to view URL]); ``` Example of Generic Filter: [login to view URL]@shahabganji/explore-global-query-filters-in-ef-core-9376a94c3f98 Examples of Non-generic Filters: [login to view URL]

Project ID: 35270703

About the project

4 proposals

Remote project

Active 1 yr ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

4 freelancers are bidding on average ₹2,275 INR for this job

@carlosbalsalobre

I'm sure I can help you with this project! About me: Focused on developing highly scalable, generic, high-performance software architectures aligned with business challenges, using mainly Microsoft technologies (Asp Net MVC, Asp Net Core, Web Api 2, SQL Server, Windows Azure, Azure Search, VSTS, Microsoft Bus Service, Visual Studio) and also web technologies (html, css, javascript, bootstrap), as well as solid communication and architecture standards (DDD, REST, OO, microservices, etc).

₹1,050 INR in 7 days

0.0

(0 reviews)

0.0

@VarunTeja2000

Hi, Does all entities configured in DbSet, does all entities/poco have tenantId and isDeleted properties in them? Do u follow same pattern of creating a interface and implementing in all entities? I do have good experience in developing Generics, Reflection and LINQ expression translator. I had built a library FirestoreLINQ which translates LINQ query to respective firebase query. I am sure I can solve this problem for you. Let's connect once for more understanding.

₹2,500 INR in 3 days