[Cache("DateCache", "Lru", FlushInterval = 6000)]
[Cache("LruCache", "Lru", FlushInterval = 6000)]
[Cache("UserCache", "Fifo", FlushOnExecutes = new[] {"UpdateUserName"})]
public interface IUsedCacheRepository
{
[ResultCache("DateCache", Key = "GetNow")]
[Statement(Sql = "Select Now();")]
DateTime GetNow();
[ResultCache("LruCache", Key = "GetId:$id")]
[Statement(Sql = "Select @id;")]
int GetId(long id);
[ResultCache("UserCache", Key = "GetUserById:$id")]
[Statement(Sql = "select * from T_User where id=@id;")]
User GetUserById(long id);
[Statement(Sql = "update T_User set UserName=@userName where id=@id;")]
int UpdateUserName(long id, string userName);
}-> https://github.com/Smart-Kit/SmartSql-Docs
