Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to use ExecuteQueryMultiple cache? #1044

Closed
seongguk92 opened this issue Apr 20, 2022 · 3 comments
Closed

How to use ExecuteQueryMultiple cache? #1044

seongguk92 opened this issue Apr 20, 2022 · 3 comments
Assignees
Labels
enhancement New feature or request fixed The bug, issue, incident has been fixed. question Further information is requested

Comments

@seongguk92
Copy link

seongguk92 commented Apr 20, 2022

Hello.
I am using it so well.
Is there any way to use cache for ExecuteQueryMultiple ?

var cache = CacheFactory.GetMemoryCache();
using (var connection = new SqlConnection(connectionString))
{
    var expirationInMinutes = 60 * 24; // 1 day
    var products = connection.QueryAll<Product>(cacheKey: "products",
        cacheItemExpiration: expirationInMinutes, cache: cache);
}

When proceeding with a paging operation
Call two select statements.

(paging data (5)/ total count (21))

@seongguk92 seongguk92 added the question Further information is requested label Apr 20, 2022
@mikependon mikependon self-assigned this Apr 21, 2022
@mikependon
Copy link
Owner

@seongguk2i the QueryMultiple is currently not supporting the caching capability, however, we are planning to introduce it on our upcoming releases. We will put this on our priority backlog.

@mikependon mikependon added the enhancement New feature or request label Aug 24, 2022
@mikependon mikependon pinned this issue Aug 24, 2022
mikependon added a commit that referenced this issue Aug 25, 2022
#1044 Supported the 'cache' in the 'QueryMultiple' operation.
mikependon added a commit that referenced this issue Aug 29, 2022
#1044 Added the cache to the DbRepository.QueryMultiple
mikependon added a commit that referenced this issue Aug 29, 2022
#1044 Support to DbRepository.QueryMultiple + more updates on DbConne…
@mikependon
Copy link
Owner

The code sample written above is for QueryMultiple operation but the title is referencing to the ExecuteQueryMultiple operation. We would like to emphasize that these are 2 separate methods and that they do different capabilities when calling both the Fluent and Raw operations. We will support the caching capability to both on the next release.

mikependon added a commit that referenced this issue Sep 6, 2022
#1044 Support of the cache to the ExecuteQueryMultiple operation.
@mikependon mikependon unpinned this issue Sep 6, 2022
@mikependon mikependon added the fixed The bug, issue, incident has been fixed. label Sep 6, 2022
@mikependon
Copy link
Owner

The fixes to this will be available on the next version > RepoDB v1.12.10.

mikependon added a commit that referenced this issue Sep 6, 2022
#1044 Support to the DbRepository.ExecuteQueryMultiple.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request fixed The bug, issue, incident has been fixed. question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants