OrmLiteCacheClient sql table schema

ServiceStack Caching
1

Hello,
I’m using the services cache on Sql database.
Is it possible to use a different schema than dbo for CacheEntry table?

Thanks to all.

2

As long as there is an existing CacheEntry table with a minimum of these properties it should work:

public class CacheEntry
{
    public string Id { get; set; }
    [StringLength(StringLengthAttribute.MaxText)]
    public string Data { get; set; }
    public DateTime? ExpiryDate { get; set; }
    public DateTime CreatedDate { get; set; }
    public DateTime ModifiedDate { get; set; }
}

Otherwise you’ll need to take a copy of OrmLiteCacheClient and modify it to suit your needs.

3

I tryed[quote=“mythz, post:2, topic:2500”]
As long as there is an existing CacheEntry table with a minimum of these properties it should work:
[/quote]

I tried to create a copy of CacheEntry table with different schema but doesn’t work.

Is there other solutions? Otherwise I have to rewrite the OrmLiteCacheClient class and put the right attributes in the top of CacheEntry class.

Thanks to all.

4

Can you be more specific on what doesn’t work and what exceptions you’re getting? I’m assuming you’re using a SuperSet of the CacheEntry table right? i.e. contains all existing fields but just adds new ones?

If so what’s the POCO Schema of the table you want to use instead? and what’s the reason you want to use a different table? The CacheEntry table should ideally be a transparent impl detail encapsulated within OrmLiteCacheClient.